Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index doesn't accept NULL
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00502150
Message ID:
00502158
Vues:
22
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform