Hi;
   1-  How to  Check if the In-Memory Database Exist?

Thanks

Salem


Same way as any database under ElevateDB - query the configuration database.

eg

select Path from databases where Name = 'InMemory'

And check if the path is empty.

Roy Lambert

Salem


Realised I was slightly wrong.

1. Query the configuration for a specific named database (you can now have as many in-memory databases as you want)
2. Check to see if any result has been returned. If not the database doesn't exist
3. If the database does exist check the path column, if that's empty its in memory

Roy Lambert

Roy,

<< 3. If the database does exist check the path column, if that's empty its
in memory >>

I should probably add a column to the Databases table for an in-memory flag.

--
Tim Young
Elevate Software
www.elevatesoft.com