12:05 PM
Subject: RE: [U2] SELECT-READNEXT That's odd
Hey, save the variable by looping backwards - if the code in the loop
allows it, of course...
FOR A = DCOUNT(WORK.THINGY,VM) TO 1 STEP -1
code
NEXT A
-Original Message-
Also for any newbies watching. Do not put DCOUNT
What UV account flavour?
What does SR.EXECUTESQL do exactly: EXECUTE or BCI SQLExecute ?
Why don't you clearselect 0, if you're not going to process the result
select list? Like READNEXT DEPENDANT.ID THEN CLEARSELECT 0 ELSE..it
seems pointless ? Or are am I missing something?
-Original
I would actually have expected that behaviour.
What is this piece of code actually try to achieve?
Is READNEXT only used to test if the SELECT statement returned any items?
In that case the CAPTURING clause with the EXECUTE statement would be a
better tool to test that.
Or you could execute
, and Innovative Solutions
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mecki
Foerthmann
Sent: Friday, November 14, 2008 3:23 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT-READNEXT That's odd
I would actually have expected that behaviour.
What
Solutions
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma
Sent: Friday, November 14, 2008 7:57 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] SELECT-READNEXT That's odd
The 'COUNT' command is also very good at establishing if and how many
I don't know all of the settings within U2 vs other MV platforms but one
thing that was tricky for me straddling both is the concept that items from
one active list remain despite a conclusion of the use of that list. Case in
point is a SSELECT statement feeding IDS to a Data/Basic report program
1) PICK
2) EXECUTE
3) Good idea
Jef
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S
Sent: Friday, 14 November 2008 5:08 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] SELECT-READNEXT That's odd
What UV account flavour?
What does
information we
seek.
Jef
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
Sent: Saturday, 15 November 2008 1:23 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT-READNEXT That's odd
I don't know all of the settings within U2 vs
Subject: RE: [U2] SELECT-READNEXT That's odd
Hey, save the variable by looping backwards - if the code in the loop
allows it, of course...
FOR A = DCOUNT(WORK.THINGY,VM) TO 1 STEP -1
code
NEXT A
-Original Message-
Also for any newbies watching. Do not put DCOUNT as the second value