Karen, Thank you. What I thought but great to confirm. Prequel to Sequel ;)
Jan From: "'Karen Tellef' via RBASE-L" <[email protected]> To: [email protected] Date: Thu, 7 Feb 2019 17:19:39 +0000 (UTC) Subject: Re: [RBASE-L] - SQL tutorial 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 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 [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] [mailto:[email protected]]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [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] [mailto:[email protected]]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [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] [mailto:[email protected]]. For more options, visit https://groups.google.com/d/optout [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.
