PRIMARY KEY(Key), UNIQUE(Key))")
(Key >>>))<<< ")
sd _ at _ sqlight _ dot _ com
----- Original Message -----
From: "Dr Gerard Hammond" <[EMAIL PROTECTED]>
To: "REALbasic-DR NUG" <[email protected]>
Sent: Sunday, August 13, 2006 12:36 AM
Subject: Problems with local REAL SQL dbs
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
The file gets created, but after the SQLexecute command, I get an error
"SQL Error: comma or parenthesis expected [07000]"
What is going on?
If I passed this SQL into SQLiteManager v2 the table gets created fine?
For some reason I am having all sorts of problems with local REAL SQL db?
(Accessing remote REAL SQL dbs is fine)
In my plugins folder, I only have the "REALSQLServerPlugin.rbx" date
12/June.
Do I need a plugin for the local REAL SQL dbs?
--
Cheers,
Dr Gerard Hammond
MacSOS Solutions
_______________________________________________
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>
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.9/417 - Release Date: 8/11/2006
_______________________________________________
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>
