Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server ODBC Error - NULL coming back as None
Message
De
08/06/2005 11:09:34
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
SQL Server ODBC Error - NULL coming back as None
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01021397
Message ID:
01021397
Vues:
71
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 ?

Many thanks,

-=Gary
-=Gary
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform