Hi,

We are using an application that was using Paradox that now uses DBISAM.  

The applicaiton comes with the read-only DBISAM Driver.  I need to extract data from the database and previously used Subqueries which I understand are not supported by DBISAM.

Is it possible to create Memory tables with the read-only driver?

A sample of code I would like to run is:

CREATE TABLE IF NOT EXISTS DateParams
   (
      Company CHAR[20] NOT NULL,
      DateFrom DATE NOT NULL,
      DateTo DATE NOT NULL
      PRIMARY KEY (Company)
   )

If I run this I receive the ODBC driver error about the database being read-only.

How can I specify that I want this table created in memory and should this work?  I have tried the following...

CREATE TABLE IF NOT EXISTS "Memory\DateParams"
   (
      Company CHAR[20] NOT NULL,
      DateFrom DATE NOT NULL,
      DateTo DATE NOT NULL
      PRIMARY KEY (Company)
   )

Sean,

<< Is it possible to create Memory tables with the read-only driver? >>

Please see my email response.

Tim Young
Elevate Software
www.elevatesoft.com