Sometimes you may want to look at a SQLite database in memory. It has the big advantage that you can fill it with data and run SQL queries against it to find records of data.
To create a memory database with sqlite you specify a file path of ":memory:".
In FileMaker you call:
In Xojo or Real Studio you call with SQLDatabaseMBS class:
MBS("SQL.Connect"; $Connection; ":memory:"; ""; ""; "SQLite")
In Xojo or Real Studio you call with SQLConnectionMBS class:
db.DatabaseName = "sqlite::memory:"
All data is lost if not copied elsewhere when the application quits or you close the database.
con.Connect(":memory:", "", "", SQLConnectionMBS.kSQLiteClient)