Re: creating sql indexes

Article View: borland.public.vdbase.data.sql

Article #52

Back to borland.public.vdbase.data.sql Previous Next

#52

From: Romain Strieff [TeamB]
Date: Tue, 02 Mar 1999 00:00

27 lines
1336 bytes

In article <7bh1qc$sl712@forums.borland.com>, Danielle politely 
paraphrased ...
> i have an sql server, with a database on it.  in my BDE i have an alias for
> the database.  I am trying to create an index on one of the tables on the
> server in a .prg but whenever i try to create it, the .prg always looks for
> the table on the f:\ drive not on the database on the server.  Can anyone
> help me with this?  Here is a sample of my code.
> 
> myDB = new Database()
> myDB.databaseName = "WinDB"
> myDB.active = true
> 
> myQ = new Query()
> myQ.database = myDB
> myQ.sql = 'select * from invent'
> myQ.active = true
> 
> create index temp on invent (descrip)
> 
> 
MydB.ExecuteSQL("create index temp on invent (descrip)")
-- 
Romain Strieff [TeamB]
Please read this newsgroup guide below before 
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--

Technical Details

Message-ID: <MPG.11464af5e8eaabff989f70@forums.inprise.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7bh1qc$sl712@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,b5919d253e3ad68a
X-Google-Attributes: gidff5a1,public
From: teamb@opto-pps.com (Romain Strieff [TeamB])
Subject: Re: creating sql indexes
Date: 1999/03/02
Message-ID: <MPG.11464af5e8eaabff989f70@forums.inprise.com>
X-Deja-AN: 450444844
References: <7bh1qc$sl712@forums.borland.com>
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message