Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote view save.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00507394
Message ID:
00507401
Vues:
10
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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform