General information
Category:
Forms & Form designer
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only