Message
 
 
To
17/12/2006 17:22:18
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01178443
Message ID:
01178445
Views:
16
>>I want to find a programmatic way to get a value of the DefaultValue property for a field. For example, say I have a table MyTable in the database which has a field MyField1. I want to know what is the DefaultValue set in the database for this field, if any.
>>
>>Thank you in advance for any suggestions.
>
>
open database yourdbc
>?DBGETPROP("table.field","FIELD","DefaultValue")
Dragan,

I swear I tried this exact syntax and I was getting an error. Now, after reading your message, I tried it again, and it works.

Thank you for your help
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View