🚀 go-pugleaf

On Tue, 2 Mar 1999 10:59:51 -0500, Danielle wrote:

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

CREATE INDEX is a local SQL command.  It doesn't know what your data
objects are.  Get Ken's paper on Undocumented features from his web
site.  It discusses some ways to do this using OODML.  OTH, if you
want to use XDML, you can try:

use :WinDB:invent exclusive
index on descrip tag temp

Or, if you want to use local SQL:

set database to WinDB
create index temp on invent descrip

Isn't it wonderful how VdB gives you so many ways to accomplish
things. <G>


Gary White

Some dBASE Stuff at
http://www.AppTools.com/dbase