Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle 8iLite
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Divers
Thread ID:
00555549
Message ID:
00555565
Vues:
13
This message has been marked as the solution to the initial question of the thread.
Louis,
Is the view set up with all fields updateable? By default, VFP creates views where the key field is not marked as updateable. Since the key field is usually the primary key and this can't be NULL, you would get this error.

HTH.

>Hi!
>
>I'm using Oracle 8i Lite with ODBC. I used to get problems when I try to update some of my view.
>
>For example, I've a view with 2 fields. VIEW1 (FLD1 c(5), FLD2 c(40)).
>
>APPEND BLANK
>REPLACE FLD1 WITH "00000", ;
> FLD2 WITH "HELLO WORLD!" IN VIEW1
>=TABLEUPDATE(1)
>
>Note: Tableupdate() returned .F. then
>
> AERROR(XX)
>XX[1] = 1526
>XX[3] = "[POL-4304] can't insert NULL into NOT NULL column"
>
>Any idea?
>
>Thanks
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform