Search results

  1. JoseKreif

    Answered random() seeded with a specific value on database connection

    Thanks for the advice. So I don't have to change the startup script for each of our many locations, I'll just keep my in-program solution. It works for what the program needs to accomplish, and won't change the way the database currently works.
  2. JoseKreif

    Answered random() seeded with a specific value on database connection

    Feel free to correct or improve, but some ingenuity seems to do the trick def var i as int no-undo. def var seed as int no-undo. do i = 1 to 10: seed = if time > etime then random(etime,time) else random(time,etime). display random(1,seed) mod 100 with no-box 10 down...
  3. JoseKreif

    Answered random() seeded with a specific value on database connection

    Progress OpenEdge 10.2B Platform: Redhat I'm noticing that the random() function seems to be seeded with a set value when you first connect to the database. For example, def var i as int no-undo. do i = 1 to 10: display random(1,100) with no-box 10 down. down. end. Produces...
  4. 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.
  5. 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:
  6. 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.
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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.
  14. 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...
  15. 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.
  16. 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.
  17. 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.
  18. 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...
  19. JoseKreif

    Piew - Free Progress Code Editor

    Nice work. Still using and love Piew.
  20. 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...
Top