creating sql indexes

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

Article #50

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

#50

From: Danielle
Date: Tue, 02 Mar 1999 00:00

18 lines
1015 bytes

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)

thanks kris

Technical Details

Message-ID: <7bh1qc$sl712@forums.borland.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,b5919d253e3ad68a,start
X-Google-Attributes: gidff5a1,public
From: "Danielle" <danielle_simmons@av-basesystems.com>
Subject: creating sql indexes
Date: 1999/03/02
Message-ID: <7bh1qc$sl712@forums.borland.com>
X-Deja-AN: 450396642
Organization: Av-Base Systems Inc.
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Newsgroups: borland.public.vdbase.data.sql