Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle 8iLite
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00555549
Message ID:
00555565
Views:
14
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform