Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index doesn't accept NULL
Message
De
01/05/2001 14:33:39
Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada
 
 
À
01/05/2001 14:29:04
Naomi Nosonovsky
Wisconsin, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Re: Index doesn't accept NULL
Divers
Thread ID:
00502150
Message ID:
00502155
Vues:
17
This message has been marked as a message which has helped 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?

Try including the condition to take care of the NULL possibility such as using IIF(ISNULL(),...
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform