![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Mon, Feb 11 2013 11:23 PM | Permanent Link |
Sean Business Evolution Group | 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) ) |
Thu, Feb 14 2013 10:42 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |