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:
00507401
Views:
9
Hi William,

Without some specific code and further information about what back-end database you're creating the remote view to look at, it's somewhat difficult to determine exactly what is causing this...but my initial thoughts are:

1) Logical fields -- sometimes they need a 1 or 0 and not a .T. or .F.
2) Character fields -- sometimes if the value you insert is too long for the field on the database, it shows up as null.
3) Numeric fields -- are you sending a non-integer to an integer field, or is the integer value too big for the datatype on the back end?

>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?
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN

If a vegetarian eats vegetables, what does a humanitarian eat?
Previous
Reply
Map
View

Click here to load this message in the networking platform