Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database Versions?
Message
De
08/07/2002 08:14:05
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00675528
Message ID:
00676064
Vues:
13
>>>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!

Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform