Mirtheil: you're right. I did it this way and SUCCESS! It's a bit of a pain having to specify all the field lengths, but it seems to be necessary. Many thanks to everyone who responded.
Thanks for responding, stefes007. I tried the quotes, but still get the same result, although I didn't get the 'driver not capable' message so it's progress of a sort:
ODBC Error: SQLSTATE = 37000, Native error code = 0
Syntax Error: create table using<< ??? >> 'c:\pvsw\samples\sample.btr';
I'm trying to create a table from Pervasive Control Center's 'Execute SQL Query' using this syntax:
create table using c:\pvsw\samples\sample.btr;
..but I get this syntax error:
ODBC Error: SQLSTATE = 37000, Native error code = 0
Syntax Error: create table using<< ??? >>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.