General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks, it worked for null ( without dots ). Though my ODBC driver ( from Oracle version 8.01.07.00 ) doesn't translate correctly
which doesn't become Oracle null. What happens , all Foxpro CHARs in view unless null travel back with trailing spacing and upset VARCHAR2s or maybe I am missing some settings.
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only