RE: [U2] SELECT-READNEXT That's odd

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

RE: [U2] SELECT-READNEXT That's odd

Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee Sent: Friday, 14 November 2008 6:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] SELECT-READNEXT That's odd One of our programmers wrote this snippet: FOR YY=1 TO DCOUNT(WORK.ITEM.REC17,VM

Re: [U2] SELECT-READNEXT That's odd

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

RE: [U2] SELECT-READNEXT That's odd

, 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

RE: [U2] SELECT-READNEXT That's odd

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

Re: [U2] SELECT-READNEXT That's odd

: Friday, November 14, 2008 2:39 AM Subject: [U2] SELECT-READNEXT That's odd One of our programmers wrote this snippet: FOR YY=1 TO DCOUNT(WORK.ITEM.REC17,VM) LISTNUMBER='' SQLCOMMAND='' UNISTATEMENT='SELECT BPM.WORKITEMS WITH A1=':WORK.ITEM.REC1

RE: [U2] SELECT-READNEXT That's odd

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

RE: [U2] SELECT-READNEXT That's odd

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

Re: [U2] SELECT-READNEXT That's odd

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

[U2] SELECT-READNEXT That's odd

One of our programmers wrote this snippet: FOR YY=1 TO DCOUNT(WORK.ITEM.REC17,VM) LISTNUMBER='' SQLCOMMAND='' UNISTATEMENT='SELECT BPM.WORKITEMS WITH A1=':WORK.ITEM.REC1:' AND WITH A2=':WORK.ITEM.REC2:' AND WITH A17=':WORK.ITEM.REC17,YY:' AND WITH A24#C AND WITH