Subject Re: FIND LEVEL OF A TABLE (DBF) From ED <ED@UNIV-COMPUTERS.COM> Date Sat, 26 Nov 2022 17:29:27 -0500 Newsgroups dbase.getting-started Mervyn Bick Wrote: > On 2022/11/09 21:37, Mervyn Bick wrote: > > On 2022/11/09 21:04, Mervyn Bick wrote: > >> t = new tabledef() > >> t.tablename = 'whatever.dbf' > >> t.load() > >> ?t.version > >> > >> Mervyn. TRYING TO RUN THESE COMMANDS  I GET AN ERROR ON Q.ACTIVE=TRUE > > > > Alternatively > > > > q = new query() > > q.sql = 'select * from whatever.dbf' > > q.active = true > > ?q.rowset.tablelevel > > q.active = false > > > > Mervyn. > > > > For what it's worth, both options return 4 for tables created with the > level set to 5 in the BDE. > > Tabledef returns the version as a character.  The query's rowset returns > the tablelevel as a numeric value. > > Mervyn. >