Search results

  1. kasundha

    Question DB user-level password policy implementation OE 11.73

    I'm using _user table to manage user accounts in the system but I'm using application-level password policy to manage user's passwords. I need to implement a password policy in the database. scenarios as follows. for password complexity. password renewal timeframes. password history (cannot use...
  2. kasundha

    XIRR Function

    I need to use XIRR function with openedge 10.2B version.
  3. 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.'
  4. 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...
  5. 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...
  6. 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.
  7. 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.
  8. 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...
  9. 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...
  10. 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 =...
  11. 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
  12. kasundha

    How To Use Save As Command For Excel File

    hi all, im using excel sheet template in my program and i want to save it in different location with different name. this is my sample code. DEFINE VARIABLE chExcel AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chWorksheet AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chWorkbook AS COM-HANDLE NO-UNDO...
  13. kasundha

    im using openedge 10.2b

    please can you help me to find the errors of the following code. im using bakup.bat file color 0A echo off SET DLC=E:\Inbank2012\TEST_DB SET PATH=%DLC%;%DLC%\bin;%PATH% :SET DATABASE BACKUPLOCATION (ADD "\" AT END) SET BKPDIR=D:\InbankDBBackup\ :Goto Database Location cd...
  14. kasundha

    how to update indexes in "API oracle data server for progress "

    oracle - 8I progress - 9.1D i have connected oracle db with progress application using "API oracle data server for progress". i want to know how can i update indexes in progress side which created in oracle db.
  15. kasundha

    [JDBC Progress Driver]:Table/View/Synonym not found (7519)

    I tried to setup eMessenger program with progress DB using JDBC driver and error log views following error continually. [JDBC Progress Driver]:Table/View/Synonym not found (7519) java.sql.SQLException: [JDBC Progress Driver]:Table/View/Synonym not found (7519) at...
Top