On Jan 28, 2005, at 11:48 AM, Seth Willits wrote:
On Jan 28, 2005, at 10:38 AM, Ruslan Zasukhin wrote:
So we define in the dialog fields to be indexed,
Press Ok,
And REALbasic calls SqlExecuteDirect with query
"create index IndexName on (f1,f2)"
What wonder us, is that by SQL standard must be
"create index IndexName on TableName (f1,f2)"
The syntax the REAL Database uses is:
create-index-statement:
CREATE INDEX <index-name-string> ON <table-name-string>
( <column-name-list )
It's in the Database Read Me.
That's the syntax you should use if you issue SQL .... but that's not
what Ruslan is doing.
The RBDB API calls this function with the string "create index
IndexName on (f1,f2)" without specifying the table
_______________________________________________
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>
|