Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Checking to see in fields exist in database - dbgetprop
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00098558
Message ID:
00098648
Vues:
27
Sheena,
Instead of DBGetProp(), why not use aFields()? You WILL need to open the table, but all the information you want is there in a 16 column array. Default value is #9. If you're looking for a specific field, use ASCAN() to find it.

HTH
Barbara

>I'm writing a utility program to check and see if fields exist in a database and if not, to add them to the database. I also am adding new fields to the database.
>
>I'm using the dbgetprop function to check for fields and if they don't exist I'm using the Alter Table command as follows:
>
>cresults = dbgetprop("client.name", "Field", "defaultvalue")
> = messagebox(cresults)
> If Len(alltrim(cresults)) = 0
>
> Alter Table client ADD column name c(20) default "Murphy"
> Endif
>
>This isn't working. Is there some other way I can check programatically for the existence in a database for fields and their
>type and default values.
>
>Any assistance would be greatly appreciated. Thank you
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform