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

[Jim McKeever <JMcKeever@fastaff.com>]

There are no #IfDef commands anywhere in the program.  It's pretty
straightforward really.
Here's the code snippet:

!***********************************************************************
Begin-PROCEDURE Get-Date-Range     !This is the initial Select from the Run
Cntrl Panel
!***********************************************************************

Begin-SELECT
RC.FROMDATE
RC.THRUDATE
RC.OVERRIDE_IND

   If &RC.OVERRIDE_IND = 'Y'
     Do Truncate-Table
   End-If

FROM PS_RUN_CNTL_HR RC

WHERE RC.OPRID       = $Prcs_OprID
AND   RC.RUN_CNTL_ID = $Prcs_Run_Cntl_ID

End-SELECT

End-PROCEDURE

!***********************************************************************
Begin-PROCEDURE Truncate-Table  !This is where the TRUNCATE TABLE command
originally was
!***********************************************************************

Begin-SQL On-Error=SQL-Error

DELETE FROM  PS_USN_GIFT_AWARD

End-SQL

End-PROCEDURE

-----Original Message-----
From: Alexander, Steve [mailto:Steve.Alexander@ci.sj.ca.us]
Sent: Tuesday, July 15, 2003 3:54 PM
To: 'sqr-users@sqrug.org'
Subject: RE: [sqr-users] SQRs on UNIX vs. NT


Wait a minute - let's not close the book on this too quickly.  Could you
please show us the code that performed a truncate even though it was on an
unexecuted branch of an IF statement?

By the way, there are several reasons identical code could behave
differently in different environments.  First, different versions of the
include files.  Second, "#IFDEF UNIX" and "#IFDEF NT" preprocessor commands.
Third, different bugs in the SQR server on different platforms.  Fourth,
different environment variables.

-----Original Message-----
From: Jim McKeever [mailto:JMcKeever@fastaff.com]
Sent: Tuesday, July 15, 2003 2:03 PM
To: 'sqr-users@sqrug.org'
Subject: RE: [sqr-users] SQRs on UNIX vs. NT


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

_______________________________________________
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