Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database Versions?
Message
From
08/07/2002 08:14:05
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00675528
Message ID:
00676064
Views:
14
>>>Hello all,
>>>
>>>I've just discovered that you can get the version number of a database with DBGetProp. Does anyone know if this is automatically incremented or if it has to always be set manually?
>>>I'm getting a value of 10 back which seems a strange number to start at :)
>>>
>>>Thanks in anticipation
>>>
>>>I've just discovered that this is a ReadOnly property so what causes it to increment?
>>>Thanks
>>
>>I think this property is for internal use from VFP. AFAIK it increments with dfferent FoxPro versions.
>>See Error 1750 from VFP help
>>
>>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/err1750.asp
>>
>>HTH
>Thanks Zlatin, I was afraid that would be the answer.
>
>Any ideas how other people determine if a local database (just containing views) needs to be updated to the most recent version?

Compare database info to own-made data-dictionary table.
You may utilize these functions to get database info:
ADBOBJECTS()
INDBC()
DBGETPROP()
CURSORGETPROP()
AFIELDS()
and other... (AFIELDS() is not applicable in case of local DBC with views definition - use CursorGetProp to get the SQL statement for the view.)
Note that you may need to open each view in order to get its info.

Another possibilities are to work directly with the DBC as a table or to combine both approaches.

HTH
Zlatin Zlatev,
MCSD (VS6)

Make solutions, not programs!

Previous
Reply
Map
View

Click here to load this message in the networking platform