RE: [RBASE-L] - SQL tutorial

2019-02-07 Thread javier.valencia
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

[RBASE-L] - Tip of the Day: New LASTMOD Function

2019-02-07 Thread A. Razzak Memon
Thursday, February 7, 2019 Tip of the Day: New LASTMOD Function Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) Build.: 10.5.1.30117 or higher Sections..: Functions Keywords..: Table, View, Structure, Timestamp, Modified Did you know you can capture the

Re: [RBASE-L] - SQL tutorial

2019-02-07 Thread jan johansen
Razzak, Thank you for that. Jan From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Thu, 07 Feb 2019 12:28:30 -0500 Subject: Re: [RBASE-L] - SQL tutorial Jan, FWIW ... At the R> Prompt: HELP 'ERROR VARIABLE' That should provide you with anything and everything you need to know

Re: [RBASE-L] - SQL tutorial

2019-02-07 Thread A. Razzak Memon
Jan, FWIW ... At the R> Prompt: HELP 'ERROR VARIABLE' That should provide you with anything and everything you need to know about defining and handling ERROR variables. Razzak At 12:08 PM 2/7/2019, jan johansen wrote: Group, Part of this didn't get answered, maybe obliquely. In the

Re: [RBASE-L] - SQL tutorial

2019-02-07 Thread jan johansen
Karen, Thank you. What I thought but great to confirm. Prequel to Sequel ;) Jan From: "'Karen Tellef' via RBASE-L" To: rbase-l@googlegroups.com Date: Thu, 7 Feb 2019 17:19:39 + (UTC) Subject: Re: [RBASE-L] - SQL tutorial Error variable = 0 always means"success" Karen -Original

Re: [RBASE-L] - SQL tutorial

2019-02-07 Thread 'Karen Tellef' via RBASE-L
Error variable = 0   always means "success" Karen -Original Message- From: jan johansen To: rbase-l 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

Re: [RBASE-L] - SQL tutorial

2019-02-07 Thread jan johansen
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" To: rbase-l@googlegroups.com Date: Tue, 05 Feb 2019 15:41:06 -0800 Subject: [RBASE-L] - SQL tutorial All, I think I need a SQL refresher. I