![]() Oracle DB => RecordSet => Create In-Memory Table => Loop through Recordset and push data into In-Memory table If we were grabbing data from an Oracle database (as an example) the data flow would currently be: Once you have the data in an in-memory database, you could sub-select it back into other in-memory databases by doing a:Ĭreate table MyNewTable1 as select * from MyNewTable where something=somethingelse īut the initial creation of that in-memory table is problematic in itself. We jump to the middle process on how to subselect data into another SQLite table which would be the equivalent of my proposed SQLiteMemoryTable. Yes in a way, but there are some drawbacks as well. Scott Boss of Nocturnal Coding Monkeys makes a great examination on: Is Xojo Enterprise Ready?Ĭouldn’t you do run data into an in-memory database table with Xojo already?.Which was in response to Bob Keeney’s blog post of: Xojo Should Scream ‘Business’.This is a continuation from a blog post that I made here: Let’s make Xojo more business centric – Part 1.
0 Comments
Leave a Reply. |