Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Are you by any chance connecting to Oracle.
I had this problem I solved it by using a specialized function...
CSEMPTY which treats NULL's as EMPTY..
I then had to replace all EMPTY's with CSEMPTY in all places...
The problem is if you update an Oracle table to the EMPTY value it is null..
I.E. there is no EMPTY value in a table just a null. Foxpro however treats NULL's and empty's separetly.
This is probably the same for other databases...
There is no way to convert all NULL's to empty but you could do...
replace field with "" for field=NULL
for all fields in the DB..
FUNCTION CSEMPTY()
**ADDS CHeck for is null to existing code..
**Note: 0 is empty......
LPARAMETERS carg
LOCAL lreturn
lreturn=EMPTY(carg) OR ISNULL(carg)
RETURN lreturn
Hope that helps..
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