Thank You Larry..
Here is what worked:
SET VAR vm_clcknos TEXT = NULL
SELECT (listof(clockno)) INTO vm_clcknos INDICATOR vm_i1 +
FROM hrmain WHERE company = .vcmp AND status = 'active'
IF vm_clcknos IS NOT NULL THEN
SET VAR vm_clknos = ('clockno IN (' + (CTXT(.vm_clcknos)) + ')')
EDIT USING ratehist +
WHERE &vm_clknos AND status = 'active' AND clockno < 9000 +
ORDER BY clockno AT 1,1,650,350 CAPTION 'Update Rates'
IF errvar <> 0 THEN
PAUSE 1 USING 'No Matches Found. Press any key to continue.' +
AT CENTER CENTER
ENDIF
ENDIF
I have to admit I don't understand why rbase has to parse it this
way, but hey... on the next challenge.
Thank you again
Jim Limburg
--- Lawrence Lustig <[EMAIL PROTECTED]> wrote:
> > EDIT USING formname WHERE clockno IN (.vm_clcknos)
>
> I think you need to do:
>
> WHERE ClockNo IN ( &vm_clcknos )
>
> and you probably wont be able to do this since the expression evaluation
> does not like & after a ( so you would need to do it in two steps:
>
> SET vClause = ('WHERE ClockNo IN (' + .vm_ClckNos + ')'
> EDIT USING FormName &vClause
>
> --
> Larry
>
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
