From sanScript, you use memory-based tables just
as you would any other tables. Keep in mind the following
guidelines when using memory-based tables:
Memory-based tables remain in
the current user’s Temp folder until the application is shut down
or the table is removed using the delete table statement. If
the application shuts down unexpectedly, the .DAT and .IDX files
for the table will remain on the user’s disk until manually
removed.
Memory-based tables have shared access.
This means that the table can be accessed from multiple locations
in the application simultaneously. For example, three separate
forms and a procedure could all access a single memory-based table.
Remember that the path information must be the consistent to access
the same memory-based table.
This is the most common use of a
memory-based tables–as shared access temporary tables.
Memory-based tables can be
temporary tables. If you specify temp as the physical name
of a memory-based table, it will act like other temporary tables.
The table won’t have shared access, and its physical name will be
assigned by the operating system.
