Re: [RBASE-L] - SQL tutorial

Jan, Here is one approach to validate the existence of a row ... SET VAR vRows INTEGER = 0 SELECT COUNT(*) INTO vRows INDICATOR iv1 FROM PODetail WHERE PO_ID = .vPOID AND ReceiptStatus = 'P' IF vRows = 0 THEN CLS PAUSE 2 USING 'No record found!' CAPTION 'Receipt Status' ICON WARNING +

Re: [RBASE-L] - SQL tutorial

Jan, Here is one approach to validate the existence of a row ... SET VAR vRows INTEGER = 0 SELECT COUNT(*) INTO vRows INDICATOR iv1 FROM PODetail WHERE PO_ID = .vPOID AND ReceiptStatus = 'P' IF vRows = 0 THEN CLS PAUSE 2 USING 'No record found!' CAPTION 'Receipt Status' ICON WARNING +

RE: [RBASE-L] - SQL tutorial

This is from rbase help. [cid:image001.png@01D4BD6C.B5022000] Dan Goldberg From: rbase-l@googlegroups.com On Behalf Of jan 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

[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

RE: [RBASE-L] - Tip of the Day: Multi-View Command File Support in R:BASE Editor

Razzak, The Dream Team frightens me. You need to get out of my head and quite implementing ideas before I express them. I will use this right away. Thank you all, -Original Message- From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: February 05, 2019 11:03 AM To: rbase-

Re: [RBASE-L] - Watch variables panel gone

Doug:  I'm sure this wasn't your problem, but Howard and I werebumping into each other all the time and making this happen.  If one ofus was dialed in and had a huge resolution (him) compared to the otherperson (me), and he resized the watch window -- the other person withthe smaller resolution