Subject Re: FIND LEVEL OF A TABLE (DBF) From ED <ED@UNIV-COMPUTERS.COM> Date Sat, 26 Nov 2022 18:05:18 -0500 Newsgroups dbase.getting-started ED Wrote: > 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. > > > HOW AND/OR WHERE  CAN I SEE THE TRUE TABLE LEVEL?