Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP + Oracle + SQL Insert
Message
From
12/01/2001 18:25:45
 
 
To
12/01/2001 18:15:04
Anderson Girardi
Athenas Automação de Escritório
Porto Alegre, Brazil
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00463273
Message ID:
00463278
Views:
13
>Dear Friends,
>
>I´m trying to do the follow statemant
>
>Insert Into Programa (Id_Programa, Data) Values ('Id_Programa.NextVal','10/10/2000)
>
>but the VFP shows me a error saying that i can insert NULL in SIC. Programas. Id_Programa.
>
>what is wrong?
>
>Thanks

My guess is that there is a field in the table not listed in the field list, so it's trying to put a NULL value (which is the native default value for all types in Oracle) into it.
Either set the field to accept nulls, or name each field and give it a non-null value, or set up default values on these fields in Oracle.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform