Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to create index for my view?
Message
De
26/06/2001 09:22:23
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00523257
Message ID:
00523517
Vues:
9
>>>I have a view that was created with left outer join. As a result that cursor contains NULL values.
>>>
>>>Now I want to index that view to use in a grid in a form. The problem is that I can't create the index with NULL.
>>>
>>>How can I solve this problem?
>>
>>Forget about that I found what was needed.
>
>NVL function, I guess :) BTW, I had a similar thread about two months ago.

No I used IsNull().
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform