Subject Re: DATA BASE LEVEL From Ken Mayer <dbase@nospam.goldenstag.net> Date Tue, 18 Apr 2023 05:19:41 -0700 Newsgroups dbase.getting-started On 4/18/2023 4:10 AM, ED FURCHE wrote: > Ken Mayer Wrote: > >> On 4/17/2023 2:51 PM, ED FURCHE wrote: >>> HOW TO I LOOK AT THE DBF LEVEL?  I HAVE TO BE AT LEVEL 5 FOR CRYSTAL TO WORK >> >> q = new query( "select * from MyTable.dbf" ) >> ? q.rowset.tableLevel >> > HOW DO I RUN THE Q COMMANDS YOU REFERENCED? (TO FIND THE LEVEL OF A DATABASE) > > MY DATABASE IS C:\TRAKKER\TRAKINV.DBF > > I TRIED: >   q = new query( "select * from C:\TRAKKER\TRAKINV.DBF" )  Didn't work.... > > Ken- use caps because it is easier to read.   I have bad eyesight. Did you do this in the Command Window? It should work, I don't know why it wouldn't. Try it the long way then: q = new query() q.sql := "select * from C:\TRAKKER\TrakInv.dbf" q.active := true Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm dBASE DOS to Windows Tutorial: http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm