Most certainly, the word "Key" is reserved :
http://www.sqlite.org/lang_keywords.html
Regards.
--
Stéphane Pinel
Support Technique en Français
[EMAIL PROTECTED] - http://www.realsoftware.fr
Le 13 août 06 à 20:32, Norman Palardy a écrit :
On Aug 12, 2006, at 11:36 PM, Dr Gerard Hammond wrote:
I am trying to create a REAL SQL database as a local file on my
local Mac.
dbLocal.databaseFile=dbFile '
If dbLocal.CreateDatabaseFile then //proceed with database
operations...
dbLocal.sqlexecute("CREATE TABLE Prefs (Key varchar(25) NOT
NULL, Value varchar(255), PRIMARY KEY(Key), UNIQUE(Key))")
if dbLocal.ErrorMessage<>"" then
msgbox dbLocal.ErrorMessage
end
end
Check dbLocal.Error and if there is one it will be set correctly.
Don't rely solely on the ErrorMessage being ""
_______________________________________________
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>
-
_______________________________________________
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>
