Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying SQL Server NULL values in VFP
Message
From
08/07/1999 13:51:54
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00238991
Message ID:
00238996
Views:
18
set nulldisplay to "" will help

datetime values can be converted using format or inputmask proprieties, or by changing the field to type "D" using dbsetprop or one of the similar commands.
You could also make the value of the textbox be something like eval(dtoc(mydatefield))

>Is there a way to display SQL Server NULL values as blanks without resetting the value of all NULL fields? When I add a new record, I'm trying to avoid setting all the fields to "" values. Any ideas?
>
>Thanks,
>Doug
--Todd Sherman
-Wake Up! Smell the Coffee!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform