Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create index for my view?
Message
From
26/06/2001 09:22:23
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00523257
Message ID:
00523517
Views:
8
>>>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é
Previous
Reply
Map
View

Click here to load this message in the networking platform