I wonder if there any SQL commands that are not supported by SQLite. I
am trying to read an entire DDL script file as a string and pass it as
one SQL command to SQLite. The same script worked fine in Firebird batch
execution.  But with SQLite I get an SQLite exception:

{"SQLite error\r\nnear \"DOMAIN\": syntax error"}
 

Here is the part that it complains about right at the beginning of the
script:

CREATE DOMAIN D_BOOLEAN AS SMALLINT DEFAULT 0
CHECK (VALUE BETWEEN 0 AND 1);

Any Advise?

Cheers


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to