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.