@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
jan johansen
Sent: Thursday, February 07, 2019 11:09 AM
To: rbase-l@googlegroups.com
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
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
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"
Ka
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 me
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 re
-3137
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
jan johansen
Sent: Wednesday, February 06, 2019 1:29 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - SQL tutorial
Javier,
I normally use the "SELECT Colname INTO...INDICATOR" as well.
W
all of us do that
when writing new code, but if you're converting OLD code you might have to
remember to add that in!
Karen
-Original Message-
From: jan johansen
To: rbase-l
Sent: Wed, Feb 6, 2019 1:28 pm
Subject: RE: [RBASE-L] - SQL tutorial
Javier, I normally use the "SELECT C
Javier,
I normally use the "SELECT Colname INTO...INDICATOR" as well.
Works great. The only time I have an issue is when it could return more than
one row.
Thanks,
Jan
From:
To:
Date: Wed, 6 Feb 2019 12:31:56 -0600
Subject: RE: [RBASE-L] - SQL tutorial
Jan,
A while back I sto
: 913-915-3137
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
jan johansen
Sent: Wednesday, February 06, 2019 12:06 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - SQL tutorial
Razzak,
Thank you. I was actually replacing the existence check
I use Razzak’s code, but with the addition of ‘AND LIMIT = 1’ causing the
search to stop when it finds the first row.
Albert
> On Feb 5, 2019, at 6:28 PM, A. Razzak Memon wrote:
>
> Jan,
>
> Here is one approach to validate the existence of a row ...
>
> SET VAR vRows INTEGER = 0
> SELECT
ot;
To: rbase-l@googlegroups.com, rbase-l@googlegroups.com
Date: Tue, 05 Feb 2019 20:28:00 -0500
Subject: 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 Re
: [RBASE-L] - SQL tutorial
This is from rbase help.
Dan Goldberg
From: 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
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 +
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 +
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
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
--
17 matches
Mail list logo