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...
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.'
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...
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...
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.
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.
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...
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...
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 =...
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
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.