RE: [U2] Strange happening... (Mystery Solved)

2009-03-02 Thread George Gallen
Of Jacques G. Sent: Friday, February 27, 2009 12:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Strange happening... In the example of code you have, the loop will exit if your key (variable ID) is equal to an empty string or a string that can be evaluated to zero for example values like

RE: [U2] Strange happening...

2009-03-02 Thread Eric Armstrong
-users@listserver.u2ug.org Subject: Re: [U2] Strange happening... As for the loop structure, I tend to like this: SELECT FILENAME LOOP WHILE READNEXT ID CODE CODE CODE with GOSUB CODE CODE REPEAT It's clean, it's concise, it's easy to read... And I wish I could remember who taught me

RE: [U2] Strange happening...

2009-03-02 Thread George Gallen
[mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Eric Armstrong Sent: Monday, March 02, 2009 11:28 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Strange happening... Allen, Regarding your loop structure below. What happens if the ID is empty string? Won't it bail out before

Re: [U2] Strange happening...

2009-03-02 Thread David Beaty
: George Gallen ggal...@wyanokegroup.com Sent: Monday, March 02, 2009 6:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Strange happening... It shouldn't, at least not to a empty ID because the condition test is on the READNEXT, not the ID. However, it will pass an empty ID to the coding

Re: [U2] Strange happening...

2009-03-02 Thread Allen Egerton
Eric Armstrong wrote: Allen, Regarding your loop structure below. What happens if the ID is empty string? Won't it bail out before all the ids are read! Eric Armstrong Lobel Financial IT Dept Nope. It's running off of an active select list, it'll process the record. Since I'm selecting

RE: [U2] Strange happening...

2009-03-02 Thread Charles_Shaffer
I never thought about a ID. Is this something you would do deliberately for some reason or is it something that would happen accidently? Can you write a record with a null ID? What would it hash to? Regarding your loop structure below. What happens if the ID is empty string? Won't it bail

RE: [U2] Strange happening...

2009-03-02 Thread Eric Armstrong
: RE: [U2] Strange happening... I never thought about a ID. Is this something you would do deliberately for some reason or is it something that would happen accidently? Can you write a record with a null ID? What would it hash to? LOBEL FINANCIAL PRIVACY NOTICE: This communication may

Re: [U2] Strange happening...

2009-03-02 Thread Charles_Shaffer
I use LOOP READNEXT ID ELSE ID = '' UNTIL ID = '' Do Stuff REPEAT I thought this was a safe way to check for the end of the list. I just used the ID as a flag and I wasn't sure what the value would be at the end of a list. I guess I was assuming that a SELECT list would not

RE: [U2] Strange happening...

2009-03-02 Thread George Gallen
Subject: RE: [U2] Strange happening... I never thought about a ID. Is this something you would do deliberately for some reason or is it something that would happen accidently? Can you write a record with a null ID? What would it hash to? Regarding your loop structure below. What happens

Re: [U2] Strange happening...

2009-03-02 Thread Mecki Foerthmann
to bail out of the loop of you want to by setting EOF David -- From: George Gallen ggal...@wyanokegroup.com Sent: Monday, March 02, 2009 6:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Strange happening... It shouldn't, at least

RE: [U2] Strange happening...

2009-03-02 Thread Eric Armstrong
I have had to abandon that as well. Eric Armstrong Lobel Financial IT Dept -Original Message- From: charles_shaf...@ntn-bower.com [mailto:charles_shaf...@ntn-bower.com] Sent: Monday, March 02, 2009 11:18 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Strange happening... I use

RE: [U2] Strange happening...

2009-03-02 Thread Norman Morgan
We have found out the hard way that an unintentional empty string record ID can also produce some VERY strange record lock situations. It seems like everyone who tries to access the file winds up queued for a record lock on the bad ID. (UD/SB+/Prelude)

Re: [U2] Strange happening...

2009-03-02 Thread Jacques G.
Snyder tsnyd...@us.ibm.com To: u2-users@listserver.u2ug.org Sent: Monday, March 2, 2009 2:38:33 PM Subject: Re: [U2] Strange happening... If, as stated in another response to this thread, the poster doesn't want the record that has a null-id to be processed, then I'd probably do something like

RE: [U2] Strange happening...

2009-02-27 Thread Edward Brown
If the ID equates to false it will exit - i.e. a record with ID 00 Edward -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 27 February 2009 14:26 To: Ardent Subject: [U2] Strange happening...

RE: [U2] Strange happening...

2009-02-27 Thread George Gallen
of the loop the id variable was never modified. Strange. George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Friday, February 27, 2009 9:39 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2

RE: [U2] Strange happening...

2009-02-27 Thread David A. Green
-users@listserver.u2ug.org Subject: RE: [U2] Strange happening... that wasn't the case. The id was combination of 13 letters and numbers. The strange part was where the while/do seemed to kick in. The item was read from the file without a problem 3-4 lines of code execute as expected

RE: [U2] Strange happening...

2009-02-27 Thread George Gallen
To: u2-users@listserver.u2ug.org Subject: RE: [U2] Strange happening... It looks like it's already been followed within the debugger to get the information given by George below. One possibility is that the gosub'd code is doing a CLEARSELECT under some circumstances, or something else

RE: [U2] Strange happening...

2009-02-27 Thread Edward Brown
- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of David A. Green Sent: 27 February 2009 15:33 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Strange happening... I would follow it line-by-line with the debugger. Thanks, David A. Green

Re: [U2] Strange happening...

2009-02-27 Thread Allen Egerton
George Gallen wrote: ok...I found this code snipit (REALITY FLAVOR) SELECT FILENAME LOOP READNEXT ID ELSE EXIT WHILE ID DO CODE CODE with GOSUB CODE CODE REPEAT What was happening was the loop was exiting early, but it was exiting after the CODE with GOSUB line

Re: [U2] Strange happening...

2009-02-27 Thread Dave Taylor
Brown ebr...@civica.co.uk To: u2-users@listserver.u2ug.org Sent: Friday, February 27, 2009 7:52 AM Subject: RE: [U2] Strange happening... It looks like it's already been followed within the debugger to get the information given by George below. One possibility is that the gosub'd code is doing

RE: [U2] Strange happening...

2009-02-27 Thread George Gallen
-Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Friday, February 27, 2009 11:37 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Strange happening... While the code itself is less than

Re: [U2] Strange happening...

2009-02-27 Thread Jacques G.
@listserver.u2ug.org Sent: Friday, February 27, 2009 10:21:19 AM Subject: RE: [U2] Strange happening... that wasn't the case. The id was combination of 13 letters and numbers. The strange part was where the while/do seemed to kick in. The item was read from the file without a problem 3-4 lines of code

RE: [U2] Strange happening...

2009-02-27 Thread Lettau, Jeff
polkaudio -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Friday, February 27, 2009 12:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Strange happening... In the example of code you have, the loop