That construct should work in VFP8. In 6 I guess the scan loop ...
Michael J. Babcock wrote:
> It's early (6am!) and I'm trying this without much success:
>
> DELETE FROM eiwdb!jobs WHERE nJobID in (select njobid FROM crap)
>
> Obviously you can see I've got a list of jobs that I don't want to
> keep in my cursor CRAP. What's the easiest way (other than me
> writing a SCAN loop) to delete these buggers?
>
> I'm not fully awake yet but the only thing I can think of at the
> moment is a SCAN loop doing a SEEK and DELETE.
>
> TIA!
============
Brian Abbott
ACA Systems
============
©2004 Brian Abbott |
