Search results

  1. kasundha

    XIRR Function

    I need to use XIRR function with openedge 10.2B version.
  2. kasundha

    Remove unwanted large spaces in string value

    I need to remove large spaces from a given string value before updating the db. eg: - 'PTPPromise to Pay :- 07/05/2019 , 13500.00 , Walk In , , RelativesMet customer wife . T.p.0702462817.'
  3. kasundha

    Disconnect DB is not working

    we have limited user licence and that is why i'm suffering about this issue. these days our network is a little bit slower than other days, is it effects to occur this issue.?
  4. kasundha

    Disconnect DB is not working

    This is the code. DEFINE NEW GLOBAL SHARED VARIABLE mBNAME AS CHAR. DEFINE NEW GLOBAL SHARED VARIABLE mSYSDATE AS DATE. DEFINE NEW GLOBAL SHARED VARIABLE loginname AS CHAR. DEFINE VARIABLE vConFlag AS LOGICAL NO-UNDO. SESSION:MULTITASKING-INTERVAL = 100. DO WHILE NOT (CONNECTED ("gl")...
  5. kasundha

    Disconnect DB is not working

    The session is still shown as an active session in PROMON.
  6. kasundha

    Disconnect DB is not working

    Hi all, I have scheduled an automated process to generate a system report. after the process completed it needs to disconnect the DB connection and close the program. the problem is, the program(Screen) is closing properly but the session in the DB server is still in the active mode and I have...
  7. kasundha

    Speedup For Each Code

    Hi, I have a openedge code and it gets more than 10 hours to run. first table has 40K + records and other tables have about 5 records per each record of first table. can you give me any suggestion to improve the efficiency of this code. -------------------- FOR EACH corpdata.ArrearsRpt...
  8. kasundha

    Openedger 10.2B colour scheme not appearing

    thanks a lot... issue is fixed.
  9. kasundha

    Openedger 10.2B colour scheme not appearing

    operating system: - windows 10 openedge version :- 10.2B I installed openedge 10.2B newly to my pc and it is not showing the colour pallet. I tried two times by reinstalling. here i attached the screen shot. please let me know how to fix this error.
  10. kasundha

    call multiple screens in one procedure sequentially

    I wrote a code (.P file) to run two different screens(.W files) sequentially. after closing the first screen, program quit the execution without running the second program. do you have any experience regarding this...? RUN MIS6I.w. RUN MIS2-MARKETING.w.
  11. kasundha

    best way to handle table locks

    What is the best way to handle table locks in openedge codes. sample code ============================ FOR EACH TT-TVS-DETAILS WHERE TT-TVS-DETAILS.T-RCPTNO = '' AND TT-TVS-DETAILS.T-FACNO <> '': FIND FIRST TEMP1 WHERE TEMP1.FACNO = TT-TVS-DETAILS.T-FACNO AND (TEMP1.SETAMT > 0 OR...
  12. kasundha

    save as not working with excel + openedge 10.2b

    got it. my mistake. thanks a lot
  13. kasundha

    save as not working with excel + openedge 10.2b

    got it. my mistake. thanks a lot
  14. kasundha

    save as not working with excel + openedge 10.2b

    Thank you very much. your code is working for newly opened work books only. hear im using excel file as a template. /**** example code****/ /*------------------------------------------------------------------------------ Purpose: Parameters: <none> Notes...
  15. kasundha

    save as not working with excel + openedge 10.2b

    i used an excel files to view reports(DASHBOARD) data to system users. 11 excel files are generating by this report. currently i have to save each report separately in everyday. i just want to automate the report and send these reports to relevant user. so i want to save those files in...
  16. kasundha

    Question Smtp Mail Setup With Office 365

    I have setup an email send program using officer 365 mail and it is not working properly. hear i attached the error log. 11/10/17 17:36:13 ************** ****** New Group ******* ************ Socket email started Input Parameters EmailFrom = kasun@abansfinance.lk EmailReplyTo =...
  17. kasundha

    Smtp Mail Setup

    does it work with windows 10 64bit?
  18. kasundha

    Smtp Mail Setup

    Thank you coop for your reply. currently im using the version you have mentioned. previously mentioned error has fixed after removing the SMTP port number. now it gives a new error. first i mentioned the error message, secondly i mentioned the error log. --------------------------- Information...
  19. kasundha

    Smtp Mail Setup

    im trying to setup a program to send emails through smtpmail.p. I had an error in error log. if smtpmail.p program is outof date, please suggest me a new method. thank you
Back
Top