Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Designing an app to support Client Server & VFP DBC back
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00153654
Message ID:
00154155
Vues:
27
Are you positive that it's marked updatable in the view? I can't think of any other reason why it wouldn't send that field in the INSERT.

>I am still getting an ODBC error that a field doesn't accept NULLs.
>
>I added a default value to my Remote view. I checked the field and it does have my default value, however when I do the TableUpdate, the INSERT command that is sent to SQL Server (checked via SQL Trace) doesn't include the field.
>
>Since the field isn't included in the INSERT, SQL Server will regard it as NULL. I can add a default value to the Table on SQL Server, but do you know why VFP is ignoring the field?
>
>Further info: I am running VFP 6, SQL Server 6.5. The field is listed as updatable in the view. This field is not bound to any control on my form.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform