Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Famous grid problem
Message
From
24/10/2002 11:51:50
 
 
To
24/10/2002 11:12:27
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00714638
Message ID:
00714925
Views:
19
>Be sure SET FILTER expresion is correct. I suggest this:

Thank you Armando. The filter does have a problem, but I don't know what it is.
The filter is on a memo field that may be null.

We are in KeyPress method of a textbox:
SET EXACT OFF
SET FILTER TO ALLTRIM(UPPER(NVL(table.MemoField,""))) = UPPER(ALLTRIM(This.Value))
GO TOP
etc.

Any ideas? Thanks.

Alex


>
>lcRS = Thisform.Grid1.RecordSet
>Thisform.Grid1.RecordSet = ''
>SELECT (lcRS) && Add this Line
>SET FILTER TO ...
>GO TOP
>SET STEP ON && This is a breakpoint. Program stops, from command
> && windows call SET VIEW ON , select view & browse it
>Thisform.Grid1.RecordSet = lcRS
>Thisform.Refresh()
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform