how do you change the where clause of a cursorAdaptor

The place for peer-to-peer support for VPM Enterprise 9.1, our latest framework.

how do you change the where clause of a cursorAdaptor

Postby stecenko » Tue Jan 03, 2017 6:14 pm

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.
Richard Stecenko
Interactive Computer Services Inc.
Victoria, British Columbia
204.453.2052
stecenko
 
Posts: 822
Joined: Mon Jun 21, 2010 8:06 pm
Location: Saanich, British Columbia

Return to VPM Enterprise 9.1

Who is online

Users browsing this forum: No registered users and 1 guest

cron