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.
-----Original Message-----
From: Michael J. Babcock [mailto:vfpmcp .at. mbsoftwaresolutions .D.O.T com]
Sent: 28 February 2004 11:14
To: profox@leafe.com
Subject: DELETE FROM with subselect
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!
--
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."
_______________________________________________
Post Messages to: ProFox .at. leafe .D.O.T com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list:
http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of
the author, and do not constitute legal or medical advice. This
statement is added to the messages for those lawyers who are too stupid
to see the obvious.
Pegasus Software Limited is a member of the Systems Union Group plc
Registered Office: Systems Union House, 1 Lakeside Road, Aerospace Centre, Farnborough, Hampshire GU14 6XP Registered No: 1601542
This E-mail is from Pegasus Software Limited. The E-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. If you have received this E-mail in error you must not copy, distribute or take any action in reliance on it. Please notify the sender by E-mail or telephone.
Pegasus Software Limited utilise an anti-virus system and therefore any files sent via E-mail will have been checked for known viruses. You are however advised to run your own virus check before opening any attachments received as Pegasus Software Limited will not in any event accept any liability whatsoever once an E-mail and/or any attachment is received.
©2004 Rob Anderson |
