Search results

  1. S

    Error 5897 in OCX trigger

    have you tried running the window persistent so that control returns to the trigger after window in run. and a Dialog box is modal so I dont think it would be appropriate for your purposes - Sunil
  2. S

    send an email using progress code

    use smtpmail.p it does the job and is free , you can get it from http://www.freeframework.org/downloads/new/smtpmail/
  3. S

    Display Tooltip depending on IF statement

    I think doing it in the check box value changed trigger would work.
  4. S

    Appserver Stop command - remote code in tight loop

    You might wish to explore the Appserver "Shutdown" or "Disconnect" procedures, which you can get through the Explorer or through the ubroker.properties file and use them to send an error to your repeat loop. HTH Sunil.
  5. S

    Not able load d file in date format

    session:date-format = 'mdy'.
  6. S

    Using PRESELECT EACH

    FOR EACH starts an iterating block , in which for each iteration , the record is fetched from the database into the record buffer and processed as per the statements within the block. PRESELECT EACH , does not actually fetch the record, it creates a temporary index to all the db records which...
  7. S

    Detecting which field was changed in PostTransVal

    in update mode there are two records in rowObjMod , one with rowmod = 'U' and another with rowmod = ''. 1) the record rowObjMod.rowmod = 'U' contains the updated values 2) the record with rowmod = '' , contains the pre-update values ... A comparison of the two will tell you which field was...
  8. S

    Search

    start-search is an event on the browser , which occurs when you click the column-label. You will have to write code to do a filter (where clause) or a sort on the browser query within the start-search trigger. In my experience , START-SEARCH is best used for sorting the column / browser...
  9. S

    substring question

    substring('633598642076131250',length('633598642076131250') - 3 , 4). you can use this for any string variable where you need the last 4 characters . Cheers Sunil.
  10. S

    export delimited decimal fields

    PUT UNFORMATTED igr FORMAT "999.999" ";" txt FORMAT "X(20)" SKIP. but with this , it will become unmanageable if there are lots and lots of fields ..... I think the export with string as suggested by Balwinder above will be most beneficial ...
  11. S

    creating file to output to in Progress 8

    output stream str1 to value(filename) will work as well .... it will not work if you just "output to variable" , it will work only if you "output to Value(variable)" ....
  12. S

    Character Search, Mid String

    DEF VAR cValue AS CHAR. DEF VAR lii AS INTEGER NO-UNDO. cValue = "This is a test". DO lii = 1 to NUM-ENTRIES(cValue,' '): IF ENTRY(lii,cValue,' ') = 'test' THEN MESSAGE 'Test found ' VIEW-AS ALERT-BOX. END. the trick is to treat cValue as a space delimited list .... then you can...
  13. S

    Default value of Timezone in Progress 4gl

    Hi, for most mail sending programs the time used is the mail server time. ... from an earlier discussion I think you are using smtpmail.p , is there a parameter in that which lets you set mail sent time .... because without that I dont think this can be done .... Cheers, Sunil.
  14. S

    Column-searching

    Hi Yohn, On clicking the column-lable of a browser, the start-search event is triggered . So your code would something like the below on 'start-search' of <columnname> open query of browser by <fieldname>. end. Only an editable / updateable column of a browse can have the start search...
  15. S

    How to improve performance

    also , the transaction scope of the FOR block (if any) will include the called .p so you might take a hit on your bi file if the called program is big or has further transactions ... .....
  16. S

    press a button very fast

    What event of the button are you using ? It might also be that this is not a Progress issue and it is just a matter of the time lag between the touch screen response and you next press. Have you tried doing the same thing with a mouse and clicking on the button. Does that also give you a...
  17. S

    Clarification required. Reg: Temp-Table Definition

    I am sorry to anyone else too , if they felt that my post was unnecessary or too negative or irrelevant or intended to start a flame war (it wasnt ).
  18. S

    Clarification required. Reg: Temp-Table Definition

    Saravanakumar, I am sorry if I hurt you . Please dont let me stop you from posting here. Sunil.
  19. S

    Clarification required. Reg: Temp-Table Definition

    Hi, It would probably have been better if you had checked Progress / OE help or the documentation before firing off this question. But I guess you find it easier asking the question rather than looking things up. No offense intended , just something that came to mind .... Cheers Sunil.
  20. S

    Email Sending to multiple through progress

    use smtpmail.p it does the job and is free , you can get it from http://www.freeframework.org/downloads/new/smtpmail/
Top