>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
Check SET NULLDISPLAY - perhaps some tool is playing with this value. You can make NULL values display as whatever you like; for example, I show "???" in my applications. Note that to a non-programmer, this might be clearer than ".NULL.".
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
