Dan, Thank you. I actually had used this info as well. I think I was just tired last night. Somehow a result of zero meaning success was just seeming totally wrong.
Thx again, Jan From: Dan Goldberg <d...@lancecamper.com> To: "rbase-l@googlegroups.com" <rbase-l@googlegroups.com> Date: Wed, 6 Feb 2019 00:06:11 +0000 Subject: RE: [RBASE-L] - SQL tutorial This is from rbase help. Dan Goldberg From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Ofjan johansen Sent: Tuesday, February 5, 2019 3:41 PM To: rbase-l@googlegroups.com 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. <!--{cke_protected}{C}%3C!%2D%2D%0A%2F*%20Font%20Definitions%20*%2F%0A%40font-face%0A%09%7Bfont-family%3A%22Cambria%20Math%22%3B%0A%09panose-1%3A2%204%205%203%205%204%206%203%202%204%3B%7D%0A%40font-face%0A%09%7Bfont-family%3ACalibri%3B%0A%09panose-1%3A2%2015%205%202%202%202%204%203%202%204%3B%7D%0A%40font-face%0A%09%7Bfont-family%3ATahoma%3B%0A%09panose-1%3A2%2011%206%204%203%205%204%204%202%204%3B%7D%0A%2F*%20Style%20Definitions%20*%2F%0Ap.MsoNormal%2C%20li.MsoNormal%2C%20div.MsoNormal%0A%09%7Bmargin%3A0in%3B%0A%09margin-bottom%3A.0001pt%3B%0A%09font-size%3A11.0pt%3B%0A%09font-family%3A%22Calibri%22%2Csans-serif%3B%7D%0Aa%3Alink%2C%20span.MsoHyperlink%0A%09%7Bmso-style-priority%3A99%3B%0A%09color%3Ablue%3B%0A%09text-decoration%3Aunderline%3B%7D%0Aa%3Avisited%2C%20span.MsoHyperlinkFollowed%0A%09%7Bmso-style-priority%3A99%3B%0A%09color%3Apurple%3B%0A%09text-decoration%3Aunderline%3B%7D%0Ap.msonormal0%2C%20li.msonormal0%2C%20div.msonormal0%0A%09%7Bmso-style-name%3Amsonormal%3B%0A%09mso-margin-top-alt%3Aauto%3B%0A%09margin-right%3A0in%3B%0A%09mso-margin-bottom-alt%3Aauto%3B%0A%09margin-left%3A0in%3B%0A%09font-size%3A11.0pt%3B%0A%09font-family%3A%22Calibri%22%2Csans-serif%3B%7D%0Aspan.EmailStyle19%0A%09%7Bmso-style-type%3Apersonal-reply%3B%0A%09font-family%3A%22Calibri%22%2Csans-serif%3B%0A%09color%3Awindowtext%3B%7D%0A.MsoChpDefault%0A%09%7Bmso-style-type%3Aexport-only%3B%0A%09font-size%3A10.0pt%3B%7D%0A%40page%20WordSection1%0A%09%7Bsize%3A8.5in%2011.0in%3B%0A%09margin%3A1.0in%201.0in%201.0in%201.0in%3B%7D%0Adiv.WordSection1%0A%09%7Bpage%3AWordSection1%3B%7D%0A%2D%2D%3E--> -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
