Jim,
Howz about :
EDIT USING formname +
WHERE clockno IN +
(SELECT clockno +
FROM hrmain +
WHERE company = .vcmp AND +
status = 'active' )
Ben Petersen
On 7 Oct 2002, at 11:03, Jim Limburg wrote:
> G-Day all
>
> Am i just loosing it, or can I not do this?
> The EDIT USING keeps giving me error that there is insufficient space
> to process ratehist (the form).. I have deleted all variables on the
> form and tried it - same problem. I have tried a generic request at
> the r:> with this form and it comes up fine. I have another line that
> calls the same form with this line... EDIT USING ratehist AT
> 1,1,600,250 CAPTION 'Update Rates' + WHERE clockno = .vclk and it
> works fine.
>
> This is what does not work:
> SELECT (listof(clockno)) INTO vm_clcknos INDICATOR vm_i1 FROM hrmain +
> WHERE company = .vcmp AND status = 'active' EDIT USING formname WHERE
> clockno IN (.vm_clcknos)
>
> I have tried: (which I believe to the right way of doing this)
> EDIT USING ratehist WHERE SELECT ALL FROM hrmain +
> WHERE clockno IN (.vm_clcknos)
>
> This form is based off of the hrmain table.
>
> What am I doing wrong here?
> THANKS
> Jim Limburg
>
> __________________________________________________
> 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/
>
================================================
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/
