>>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(<b>NVL(lname, "?")</b>,1) into lender
>assuming that you dont have lender names beginning with "?"
Hi Sergey,
I finally decided to go this route, instead of my code (I may change my mind again in a future :)). I used set rela to left(nvl(lName,OldValue),1) and it suits my needs just fine. Thanks for reminding about nval function.
If it's not broken, fix it until it is.
My Blog