RE: [sqr-users] SQRs on UNIX vs. NT

[Jim McKeever <JMcKeever@fastaff.com>]

OK, I figured it out.  In case anyone else doesn't know this...apparently
even though I was using TRUNCATE TABLE only in an If statement, the SQR
performed this even when the if statement was not executed.  When I changed
it to DELETE FROM, it performed properly.  Still don't see why it would only
do it on UNIX, but I guess as long as it's working, that's the important
thing!

Thanks to everyone for your assistance!

-----Original Message-----
From: the dragon [mailto:ceprn@hotmail.com]
Sent: Tuesday, July 15, 2003 2:49 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] SQRs on UNIX vs. NT


Daniel,

Good call.  That should show exactly what is happening.

clark



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your

services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)


----Original Message Follows----

What about the -S option for SQR that shows the status of all the SQL
Cursors?  I know it's -S for NT.  Not sure for UNIX.  But it might show
something.

Daniel Brinkley
Techneglas, inc.

 >>> JMcKeever@fastaff.com 07/15/2003 4:16:15 PM >>>
I have verified that the code is exactly the same.  That is why I'm so
baffled...

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users