Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
In foxpro use
replace field1 with NULL (no dots)
Also if you just replace them with "" (replace field1 with "")
The ODBC driver sets the value to NULL on the server automatically.
But if you want to update in SQL PLUS you also use the syntax NULL
update mytable set field1=NULL;
I think the default for NULLDISPLAY is .NULL. which is why ít looks this way.
So I use
SET NULLDISPLAY TO ""
In the start of my program so they look empty.
HTH
>Can't figure out how to set nulls in Oracle database ( 8.1.7 ) on NT with their ODBC driver. In remote view initially all Oracle nulls are shown correctly as .NULL. but using .NULL. as value to assign via typing in grid cell or command window "replace field1 with .NULL." result in literal string '.NULL.' after updating when then run query in SQL*Plus.
>
>Any help is appreciated.
>Michael
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