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.
Seth Willits
------------------------------------------------------------------------
---
President and Head Developer of Freak Software - http://www.freaksw.com
REALbasic Guru at ResExcellence - http://www.resexcellence.com/realbasic
"All men are born with a nose and ten fingers, but no one was born with
a
knowledge of God."
-- Voltaire
------------------------------------------------------------------------
---
_______________________________________________
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>
|