Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP + Oracle + SQL Insert
Message
De
12/01/2001 18:25:45
 
 
À
12/01/2001 18:15:04
Anderson Girardi
Athenas Automação de Escritório
Porto Alegre, Brésil
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00463273
Message ID:
00463278
Vues:
14
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform