On May 29, 2004, at 1:51 AM, GAmoore at aol dot com wrote:
1. I try to create a database table and I keep getting SQL error #7 -
"missing comma or parentheses"
on this :
db.SQLExecute("create table classes( id integer not null,
primary
key (id))")
Unfortunately that section of the online reference is out of date and
needs to be updated. The new REAL Database doesn't support column
constraints, such as "not null", and it has one primary key built in
for you already. To create a table, you can say:
db.SQLExecute "create table classes( id integer )"
However, since the new REAL Database has a _rowid column built into
each table, a field such as "id" becomes much more useless.
HTH,
Jon
--
Jonathan Johnson
Testing Department
REAL Software, Inc.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|