Error variable = 0 always means "success" Karen -----Original Message----- From: jan johansen <[email protected]> To: rbase-l <[email protected]> Sent: Thu, Feb 7, 2019 11:09 am Subject: Re: [RBASE-L] - SQL tutorial
Group, Part of this didn't get answered, maybe obliquely. In the OLD codeIF Hold = 0Does 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 isIF hold = 0 the same asIF 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.
