Subject Re: DATA BASE LEVEL From Mervyn Bick <invalid@invalid.invalid> Date Tue, 18 Apr 2023 13:40:48 +0200 Newsgroups dbase.getting-started On 2023/04/18 13:10, ED FURCHE wrote: > 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. IT HELPS IF YOU GIVE THE ACTUAL ERROR MESSAGE INSTEAD OF THE RATHER GENERAL "Didn't work". THE PROBLEM IS CAUSED BY THE : IN THE PATH.  YOU NEED TO ENCLOSE THE FILE NAME AND ITS PATH IN QUOTES.  AS YOU HAVE ALREADY USED DOUBLE QUOTES TO DELIMIT THE SELECT STATEMENT YOU WILL NEED TO USE SINGLE QUOTES.    Q = NEW QUERY("SELECT * FROM 'C:\TRAKKER\TRAKINV.DBF'")    ? Q.ROWSET.TABLELEVEL    Q = NULL   Mervyn.