Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view save.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00507394
Message ID:
00507522
Views:
9
>I have set up a remote view and set it's cursor properties. I do an insert into the table.
> When I do a tableupdate() I get an .F. . aerror() tells me that a field will not accept null values. This is correct because the field is set up to not receive null values.
> The problem is I am not passing a null value. Does anyone know why SQL is seeing a null value when I am not passing a null value through the remote view?

Another thing to check is does the view reference more than one table? If so, and you only mean to update one table (which I would strongly recommend) be sure the other fields are not marked as updatable.
HTH,
Bill Armbrecht
VFP MCP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform