Subject Re: DATA BASE LEVEL From Ken Mayer <dbase@nospam.goldenstag.net> Date Tue, 18 Apr 2023 07:10:00 -0700 Newsgroups dbase.getting-started On 4/18/2023 5:19 AM, Ken Mayer wrote: > 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 Others noted the real issue -- you need to delimit the path, if you are including the drive, so: q.sql := "select * from 'C:\TRAKKER\TrakInv.dbf'" In my defense, I was looking for spaces in the path, and didn't think about the colon in there. 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