Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server ODBC Error - NULL coming back as None
Message
From
08/06/2005 16:40:50
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01021397
Message ID:
01021596
Views:
21
Thanks Sergey and Hilmar - right on the money with this one!

Best

-=Gary


>>Hi,
>>
>>I am getting a bit of a strange error/problem/issue. A recordset is being returned by a SQL sever stored procedure. In the SQL database, the values of a number of the columns are NULL. However, after the SQLEXEC() call, the created cursor displays these NULL values as None. If it is a character field, the value is Left Justified, if it is a numeric field, the value None is right justified.
>>
>>Any ideas what is going on and how to fix it so that Fox displays NULL ?
>>
>
>
>Gary,
>
>Check SET NULLDISPLAY setting. BTW, how do you view data, BROWSE command?
-=Gary
Previous
Reply
Map
View

Click here to load this message in the networking platform