Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I am executing an SQL INSERT from a NET website. The insert statement has an incomplete list of the fields in the table. The intention is that the fields not listed would be left blank. The table is structured to not allow null values. The insert from the website fails with a message that the field does not allow null values. I am trying to find a way to deal with this. One solution is to revise the table to allow the nulls but this is undesireable. Another solution might be to establish a default value for each field (untested). But this is also undesireable. I would prefer the empty fields just be left blank.
>
There are some possibilities I see, depending on the backend.
Do you INsert into a vfp table ?
Is this single Record Insert or Bulk Insert operation ?
regds
thomas
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement