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
Arh, crap. I found the problem.
I had mistakenly DIMmed the variable as an old dodgey REALDatabase
and not the spiffy new REALSQLDatabase I had meant to use. No wonder
the SQL was invalid!
Thanks for all those who suggested things to try.
Dangnabit
--
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>
