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
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
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
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
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
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
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
7 matches
Mail list logo