Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing the DefaultValue programmatically
Message
From
11/01/2001 12:05:02
 
 
To
11/01/2001 11:57:29
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00462310
Message ID:
00462316
Views:
10
>Is there any way of changing a field's DefaultValue programmatically? Some our clients want to default certain fields differently and I'd like to do it through the DBC. Any ideas?

I would have a table of all the fields and their default values. Then, in the default value, try putting a function call (UDF, Stored Procedure, or just a Lookup() call) in there that goes and looks for the field in the table and returns the specified default value (of course you'll need to make the types match).
Previous
Reply
Map
View

Click here to load this message in the networking platform