Re: RBDB API question: Create Index

[Will Leshner <will dot leshner at gmail dot com>]

On Fri, 28 Jan 2005 20:38:31 +0200, Ruslan Zasukhin
<sunshine at public dot kherson dot ua> wrote:

> 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)"

You are absolutely right that the first SQL wouldn't work at all. I
wouldn't think any database engine would understand it. What version
of Rb are you seeing this in, just out of curiosity?


-- 
REALbasic database options: http://sqlabs.net
REALbasic news and tips: http://rbgazette.com
KidzMail & KidzLog: http://haranbanjo.com
_______________________________________________
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>