Re: Help To create a Dynamic Update Statement in RIA 3.2d for memory tbl


Andreas Sedlmeier
 

There's no SQL for memory tables, memory db can however be result database for direct SQL. You can use SQLite which is effectively a memory database too. I am just not a big RIA fan and therefore not sure (for memory tables neither) if you can have that DB file on client side in case of RIA. If your resultset is really dynamic (varying number of columns) you could also work with vectors to store your week totals - or with XML Blobs and XML direct access. Problem will then just be the display in a table/grid control. You could use a .NET grid control for that. Possibilities for varying number of columns with Magic table controls is limited.

Andreas

Join main@magicu-l.groups.io to automatically receive all group messages.