I have added a CA to the data enevironment of a form with NoData=.t.
I have a button with the following...
sloCA = GETCURSORADAPTER('caBench')
IF TYPE('sloCA') <> 'O'
MESSAGEBOX('Nope')
RETURN .f.
ENDIF
WITH sloCA
STORE .selectCmd TO dlcCmd
STORE dlcCmd+[ where cBnchDescription like 'L%'] TO .selectCmd
STORE .cursorRefresh() TO dllOk
endwith
IF dllOk
SELECT caBench
BROWSE normal
ELSE
dimension dlaError[1,2]
STORE AERROR(dlaError) TO dlnError
IF dlnError>0
MESSAGEBOX(ALLTRIM(STR(dlaError[1]))+CHR(10)+;
dlaError[2])
endif
endif
But the browse contains all the records, not just the ones starting with L
I think that using CAs will help me solve the problem from my previous post.