You can easily check this yourself. Place the following code in a command file makings sure that vPOID has a valid value SET ERROR VAR hold SET VAR vchk = ReceiptStatus IN PODetail WHERE PO_ID = .vPOID AND ReceiptStatus = 'P' IF hold = 0 THEN Trace the code one line at the time looking at variables hold and vchk. Look at the value for vchk and hold after the code executes the second line. This should tell you how the ERROR VAR changes depending on whether you get a valid value for vchk or not. Javier, Javier Valencia, PE O: 913-829-0888 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, February 07, 2019 11:09 AM To: [email protected] Subject: Re: [RBASE-L] - SQL tutorial Group, Part of this didn't get answered, maybe obliquely. In the OLD code IF Hold = 0 Does that mean success or failure? Jan From: "jan johansen" <[email protected]> To: [email protected] Date: Tue, 05 Feb 2019 15:41:06 -0800 Subject: [RBASE-L] - SQL tutorial All, I think I need a SQL refresher. I need to update old code that looks like this. SET ERROR VAR hold SET VAR vchk = ReceiptStatus IN PODetail WHERE PO_ID = .vPOID AND ReceiptStatus = 'P' IF hold = 0 THEN So is IF hold = 0 the same as IF SQLCODE = 0? Sorry such a dumb question. Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
