Search results

  1. JoseKreif

    Resolved Strange problem related to streams and break by totals.

    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.
  2. JoseKreif

    Resolved Strange problem related to streams and break by totals.

    Why though? If yesno is false, the display statement should never execute. Also, as I said before:
  3. JoseKreif

    Resolved Strange problem related to streams and break by totals.

    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.
  4. JoseKreif

    Resolved Strange problem related to streams and break by totals.

    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. create t-table. assign name = "Bob" age = 44. if yesno then output...
  5. JoseKreif

    Resolved Infinit Loop With For Each

    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...
  6. JoseKreif

    Resolved Infinit Loop With For Each

    Because it by dictionary definition, restarts. Imagine having 2 cords. 1: A, and 2: B. Displaying these in the loop would result in. [START] A B A B A B A B .... [NEVER ENDS. ETERNITY] when it should be [START] A B [END] I have managed to isolate the problem. It's related to the index on...
  7. JoseKreif

    Resolved Infinit Loop With For Each

    Here is a short example: <gather files > lslp: 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: create csvimport. import stream instr delimiter "," csvimport...
  8. JoseKreif

    Resolved Infinit Loop With For Each

    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...
  9. JoseKreif

    Resolved Infinit Loop With For Each

    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...
  10. JoseKreif

    Question DBA Users in Progress 10.2B

    Thanks for your well detailed response. As I start to understand this more and more, it's making a lot of sense.
  11. JoseKreif

    Question DBA Users in Progress 10.2B

    For clarity 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...
  12. JoseKreif

    What is field width? [Open Edge 10.2b)

    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.
  13. JoseKreif

    What is field width? [Open Edge 10.2b)

    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.
  14. JoseKreif

    Question Add "total By" To A Variable

    I think I found a solution. Something like this might work if last-of(state) THEN do: accumulate balance(total). someVar = (accum total balance) . end.
  15. JoseKreif

    Question Add "total By" To A Variable

    I'm would like to get the total and save it to a variable to use outside of the display command. For example For each customer where age = 21 break by state: display Customer state balance(total by state). end. FYI This is purely a fictional example In the example, I would list customers...
  16. JoseKreif

    Piew - Free Progress Code Editor

    Nice work. Still using and love Piew.
  17. JoseKreif

    Resolved Odd Outcome With "find"

    Oh yes, I understand the difference. However, the Find with the begins failed reguardless. Plus, there should never be more than 1 record with the same field, in which I'm looking for. Therefore, the "FIND" should work. To be clear. "FIND FIRST", "FIND LAST", and "FIND" all failed with the...
  18. JoseKreif

    Resolved Odd Outcome With "find"

    I think I've tried "find First", that also lead it into the else block everytime. It's strange. Getting rid of the field begins "FooBar" and replacing with field = "FooBar" , seemed to have caused the logical error to go away. Ancient, 10.2B on RHEL
  19. JoseKreif

    Resolved Odd Outcome With "find"

    That's not a mistake. I need that to prevent the program from crashing. Removing it will only display the message "No Record Available". Like I've said in the OP, however, that the statement works on it's own in the editor window. This seems to be an issue with the "Find Begins".
  20. JoseKreif

    Resolved Odd Outcome With "find"

    It should not be locked elsewhere. I don't normally use "begins", so this is a first for me experiencing the outcome of mixing it with a find. I'm just a little confused, based on what I am seeing in the knowledgebase, Progress is suppose to return a record when a "find begins" is used...
Top