Quoting Tim Jones <[EMAIL PROTECTED]>:
> Hi all you RB DBA's,
>
> I've an odd table create error that I can't pin down. I've dug through the
> SQLite docs and according the the create notes this should work. Can anyone
> spot the issue that is generating the SQLExecute error
>
> ("near "autoincrement": syntax error")?
>
> CatalogDB.SQLExecute "create table paths (pathid integer not null
> autoincrement primary key, pathname blob not null)"
It turned out to be an order issue. Changing the line to read:
CatalogDB.SQLExecute "create table paths (pathid integer
primary key autoincrement not null, pathname blob not null)"
... allows this to work.
So, is it SQLite or RB's implementation that is so picky about order?
Tim
--
Tim Jones
[EMAIL PROTECTED]
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
