Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to populate default values for a new record?
Message
From
28/07/2010 10:51:59
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How to populate default values for a new record?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01474230
Message ID:
01474286
Views:
39
>One time job?
>If so:
>
>EXEC sp_MSForEachTable 'EXEC sp_columns ''?'''
>
>
>:-))))))))))

No, this would not do. I need to write a query to see if I have Defaults in any of the tables.
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