Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remove nulls from a cursor
Message
 
 
À
02/04/2003 16:01:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00773243
Message ID:
00773250
Vues:
7
I created a cursor with
>
set null on
>
>I did some record manipulation that required the use of null values.
>
>Now i need to use the cursor to create a report.
>my report prints values like .NULL
>
>How do I get rid of the null values for reporting?
>
>can I change the cursor or do I have to create a new one?


Do you need to get rid of them, or just not see them? If the latter, SET NULLDISPLAY TO " ". If the former, I guess REPLACE ALL (field) with " " FOR ISNULL(field). But that requires a writable cursor.

Michelle.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform