main logo
Subject: Re: DELETE FROM with subselect
Author: "Michael J. Babcock"
Posted: 2004/02/28 07:17:00
 
View Entire Thread
New Search


Rob Anderson wrote:

> Hi Michael....
>
> How about "SET RELATION TO nJobID INTO crap"
>
> DELETE FOR EOF("crap")
>
> (I'm sure there are better ways of doing it though...)
>
> Hth, Robbo.

I ended up doing something like this:

select crap
scan
if seek(crap.njobid,"jobs","iid") then
delete in jobs
endif
endscan

Thanks for your tip, though!

--

Michael J. Babcock, MCP
President/CSA, MB Software Solutions, LLC
http://mbsoftwaresolutions.com
"Bettering your bottom line by helping you work smarter, not harder,
with custom software solutions."



 
©2004 Michael J. Babcock
<-- Prior Message New Search Next Message -->