Subject Re: DATA BASE LEVEL From ED FURCHE <ED@UNIV-COMPUTERS.COM> Date Tue, 18 Apr 2023 07:10:24 -0400 Newsgroups dbase.getting-started 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 > > > ALSO, ANY WAY TO FORCE LEVEL 5 WHEN I CREATE A DBF? > The simplest thing to do is to alter the BDE's settings using the BDE > Administrator software. Exit dBASE if it's open. Run the BDE > Administrator. Click the "Configuration" tab. Click the "+" by > "Configuration" in the window under the tab. Click the "+" by "Drivers", > and again for "Native". Click on "DBASE".  On the right you will see > "LEVEL". Change it to 5. Press Ctrl+A to save all changes, and close the > BDE Administrator. Until or unless you change that level again, the > default for any new table will be level 5 on your computer. > > 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 > 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.