Definitely an early morning error.....
Here was the problem statement:
DELETE FROM jobs WHERE nJobID in (select njobid FROM crap)
Here was the correct statement:
DELETE FROM jobs WHERE iID in (select njobid FROM crap)
It was the WHERE field...in the Jobs table, it's IID; everywhere else
it's nJobID.
DOH! Thanks Brian, Nancy, et al!
Yes, I'm using vfp8...
--
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 |
