Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index doesn't accept NULL
Message
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00502150
Message ID:
00502158
Views:
23
This message has been marked as the solution to the initial question of the thread.
>Hi everybody,
>
>I have two grids on the form. The main table BldMstr sets relation into Lender table
set rela to left(lname,1) into lender
>
>If LName is NULL, I have the error, and my relation doesn't work anymore. What should I do?

I guess you van use NVL function to convert null
set rela to left(NVL(lname, "?"),1) into lender
assuming that you dont have lender names beginning with "?"
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform