>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.