realbasic-plugins
[Top] [All Lists]

Re: RBDB API question: Create Index

To: REALbasic Plugins <realbasic-plugins at lists dot realsoftware dot com>
Subject: Re: RBDB API question: Create Index
From: Ruslan Zasukhin <sunshine at public dot kherson dot ua>
Date: Fri, 28 Jan 2005 20:53:19 +0200
Delivered-to: realbasic-plugins at lists dot realsoftware dot com
On 1/28/05 8:48 PM, "Seth Willits" <seth at freaksw dot com> 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 )

Than more it is not clear
why REALbasic send to RBDB API of plugin not correct command.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft dot com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------


_______________________________________________
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>

<Prev in Thread] Current Thread [Next in Thread>