realbasic-plugins
[Top] [All Lists]

RBDB API question: Create Index

To: REALbasic Plugins <realbasic-plugins at lists dot realsoftware dot com>
Subject: RBDB API question: Create Index
From: Ruslan Zasukhin <sunshine at public dot kherson dot ua>
Date: Fri, 28 Jan 2005 20:38:31 +0200
Delivered-to: realbasic-plugins at lists dot realsoftware dot com
Hi All,

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


So why RB send us non-standard command ?
Seems to be a bug/glitch which should be fixed.




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