No difference. Thanks for suggestion though. Seems to be the way the language handles the total function. Nothing directly related to the stream. I was hoping to get an answer as to why, but unless the Progress team responds, it will remain a mystery.
That's the point though. The code is executing when it shouldn't be. I didn't explicitly set yesno to false because it gets set to false by default, and since this is a small isolated example of the problem, I opted to save space by not being redundant.
Why is it that using a total will cause Progress to process code, even though it doesn't meet the condition?
def var yesno as log no-undo.
def stream s_file.
def temp-table t-table
field name as char
field age as int.
name = "Bob"
age = 44.
if yesno then
Thanks. Since I added a incremented number to each of my 99 imported records, and displayed this number in the loop, I was seeing it cycling from 1 to 99, and then hit back to 1, and repeat.
Since I was seeing the same 99 records repeat over and over in the same order (1 to 99), it appeared to...
Because it by dictionary definition, restarts. Imagine having 2 cords. 1: A, and 2: B. Displaying these in the loop would result in.
[NEVER ENDS. ETERNITY]
when it should be
I have managed to isolate the problem. It's related to the index on...
Here is a short example:
<gather files >
repeat on endkey undo, leave lslp:
<gather file from collected list>
<check if file is correct format>
repeat on endkey undo, leave on error undo, retry:
import stream instr delimiter "," csvimport...
Thanks for your response, however, it does seem irrelevant to what is happening in my case. I know it doesn't gather a "result set", and I am not trying to do so. I am sorry if I caused confusion.
I am processing records imported from a CSV. After importing CSV to a temp-table, I am running...
I have a for each loop with a temp-table that just won't end. Using an incremented number on each of the records, I can see that the for each loop is starting over after hitting the last record.
Q: What are some things that would cause this?
I'll note the for each is wrapped inside of a...
I'm using Progress 10.2B on a Linux OS.
I add users by going into: Tools > Data Dictionary > Admin > Security > Edit User List
We want to make sure that certain accounts connecting to the SQL are not granted DBA rights, and that 1 or 2 are..
There is no option to pick whether or...
Thanks for the feedback guy. I guess I don't have to worry too much since the database in question is never accessed through SQL, and the data is only displayed in a Linux environment. So format "x(##)" is all I need. This info will surely come to use sometime in the future though.
I feel dumb for not knowing this. What is field width?
I would assume it's the number of characters the field is allowed to retain; however; I can set a field width to 5, but I can store more than 5 characters in a given field.
I'm would like to get the total and save it to a variable to use outside of the display command.
For each customer where age = 21 break by state:
display Customer state balance(total by state).
FYI This is purely a fictional example
In the example, I would list customers...