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>
