Home > Archive > Programming with dBASE > October 2005 > database level









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author database level
Charles

2005-10-24, 8:24 pm

Is there a way to tell what level (4,5,7, etc.) a database is? Clicking on properties does not do it.

Charles
Todd Kreuter

2005-10-24, 8:24 pm

Charles wrote:
>
> Is there a way to tell what level (4,5,7, etc.) a database is? Clicking on properties does not do it.



Just so there is no confusion... A database is a collection of tables,
all of which can be different versions. To get the version of a table,
you can:

Read the rowset.tableLevel property of any open query, or

Use tableDef like so (untested):

t = new tableDef()
t.tableName = "Customer.dbf"
t.load()
? t.tableLevel

--
Todd Kreuter [dBVIPS]
Charles

2005-10-24, 8:24 pm

Todd Kreuter Wrote:

> Just so there is no confusion... A database is a collection of tables,
> all of which can be different versions. To get the version of a table,
> you can:
>
> Read the rowset.tableLevel property of any open query, or
>
> Use tableDef like so (untested):
>
> t = new tableDef()
> t.tableName = "Customer.dbf"
> t.load()
> ? t.tableLevel
>
> --
> Todd Kreuter [dBVIPS]



When testing the above code, I get a variable undefined error for the t.tablelevel

Charles

Michael Nuwer [dBVIPS]

2005-10-24, 8:24 pm

Charles wrote:
>
> When testing the above code, I get a variable undefined error for the t.tablelevel


The property to test should be "version"

t = new tableDef()
t.tableName = "fish.dbf"
t.load()
? t.version

Todd Kreuter

2005-10-27, 7:28 am

"Michael Nuwer [dBVIPS]" wrote:
>
> Charles wrote:
>
> The property to test should be "version"


I knew tableLevel did not look right, thats why I included "untested".
Memory lapse ;(


--
Todd Kreuter [dBVIPS]
Jim Peterson

2005-10-27, 7:28 am

Any dBase table may be opened in "Design" mode ...

Then simply set the inspector combo box to the top level and the inspector tells you all about the table, including the version.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com