Recent content by sunilnair

  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 ... .....
Top