General information
Category:
Coding, syntax & commands
Title:
Replacing Null Fields
If I do a select Left Outer join, I end up with Nulls in the fields where no match exists in the Joined Table.
Is there any VFP setting where I can default these to zero (if numeric) or spaces(if Character) rather then Null.
I know I can post process the table and do an if Isnull() , but my prererence is to avoid having to do this if it can be done.
Thanks in advance
Gerard
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