Information générale
Titre:
Inserts, SQL and Nulls
I know it's common practice in VFP to not allow nulls. I assume this is also the case in SQL server. My problem is that when I do an SQL INSERT to insert a blank record for editing, any field left 'blank' is actually null filled and the insert fails. Two solutions come to mind. 1. Set a default value for each field in the SQL table (or VFP remote view). 2. Cycle through the record checking for nulls. Is there a better way? Should I allow nulls?
TIA
John
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