Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to populate default values for a new record?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01474230
Message ID:
01474257
Views:
40
>>>>No. It's a result of SQLEXEC command.
>>>
>>>Then in the method where you add record REPLACE default values :-)
>>
>>How? I want to replace with the defaults from the database. In other words, looks like we need to bring the defaults for the columns in a separate statement...
>>
>>All sounds quite tricky, but as I examined our tables yesterday, I found that we're not using defaults.
>
>
>sp_columns 'NamerOfTheTable' 
>
>And check Column_Def column.

Can you get this info by a different method? I wanted to test every table in DB just to see if either table has defaults (I think here we're not favoring defaults).
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform