Subject Re: FIND LEVEL OF A TABLE (DBF) From Mervyn Bick <invalid@invalid.invalid> Date Thu, 10 Nov 2022 11:17:49 +0200 Newsgroups dbase.getting-started 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. > > 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.