Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote views and null values
Message
 
To
07/02/2000 14:48:36
Jorge Haro
Independent Consultant
Juarez, Mexico
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00328428
Message ID:
00328534
Views:
18
Hi Jorge,

I assume you're using SQL Server!
The error VFP is giving to you cannot be solved with SET NULL ..., because the problem becomes from SQL Server. You must "uncheck" the ALLOW NULLS column at all fields of your table (by the way, give always a DEFAULT value too). It sounds terrible "unchecking" for all fields, but you can do it by code, when you are creating your table.
Like you can check the UPDATABLE column at the creation of your views (use DBSETPROP()).

Say anything if you need.

Good luck,

Ricardo
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform