Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.NULL. field
Message
From
10/04/2006 13:40:20
 
 
To
10/04/2006 13:32:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01112086
Message ID:
01112088
Views:
12
>why when i insert in sql server the field that are empty write .null.

When you insert a record, any field you do not specify a value for will be inserted as whatever was specified as default in that field, or NULL if not. Unless the field (column) is specifically marked as NOT NULL whereas you will get an error saying that no nulls are accepted.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform