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.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao