Search results

Hi All, Our SQL customers complain about the Dead Lock situation when a massive update happens..... However, customers using Progress DB have no issues. If you have any KB Links for achieving better performance, precautions to be taken while writing the code etc...(with respect to the SQL...

Hi, I am trying to build a utility to compile programs in different environments. When the user selects an environment and Press compile button run the below code CONNECT database -H dbserver -S 29000. Compile c:\temp\program.p save into e:\cmp\ . DISCONNECT database. My doubt is How can I...

Hi, Below is one of the lines in a Client PF file for a Progress (Schema Holder) SQL connection -RO -db c:\db\data\sports2000_sh -1 -db Dev -ld sports -U xxxxxxx -P yyyyyy -1 -Dsrv skip_schema_chec from the above line, my understanding is Database connection is Read-Only & Connection is the...

Hi, Please clarify my doubt. In the below code When i = 3, Progress will release the lock and then leave OR, 3rd record will be in the Exclusive lock until we write the Release statement and then Leave? DEFINE VARIABLE i AS INTEGER NO-UNDO. FOR EACH Customer where customer.custnu < 5...

Hi, One of our clients is using Progress Schema Holder and maps to an MS SQL Server. Application is hanged for a long time. When we checked the asbroker log and found the below error. Can anyone help me sort out this issue? Is this raised due to the locking by SQL DB? Or shall we look into the...

Hi, I am using the below code to add new rows and copy-paste the contents to each row. I want to delete a particular row. Please help me in finding the exact code to DELETE one row which I created in the WORD document. DO cnt = 1 TO 3: ASSIGN W-CNT = W-CNT + 1. IF W-CNT = 1 THEN...

Hi, Customer reported that when they are using a RF screen some times it behaves wrongly after the user prints the label. I collected the 4GL trace from the client. After each print, it will go back to the parent screen. That is the proper behavior, however, sometimes it goes back to the main...

Hi, While I am testing a Delete method inside a class I am getting the below error. After seeing this error, I recreated the WAR files, re-started tomcat, UnDepoyed and deployed the services. Still the same error appearing. Can anyone throw light on the issue?

Hi, I have an assignment to print a report with item names as column-labels. If a store has 10 items then these ten item id appear as column labels. It can vary. How can I define a temp table with this dynamic extent? I know in a variable we can do the dynamic extent. Same way can we do it...

Hi, Can any one give a Licensing Overview of a Mobile App. We have developed a Mobile App in Sencha and Progress as backend (REST calls) . We build a Apk file and installing it in the devices. We want to make sure that number users suing the app should not exceed the number of license...

Hi Please have a look into below section of code . Can anyone tell us which one have a better performance. or both have same performance? -philip- /* With open query : */ CASE order_type: WHEN "SoNbr":U OR WHEN "AnyOrder":U THEN DO: OPEN QUERY iq_slshdr FOR EACH...

Hi, While we are trying to run a AppServer procedure multiple times through a webService call, we are getting below error in wsa1LogFile Monitor. Error in SOAP request execution: SessionPool : NoAvailableSessions[Request failure: Max client connections has been reached (7251)] (10926) Please...

Hi, REST adapter is available in OE11.3. Can any one help us to use it in OE 11.3 ? Any links or tutorials is more than enough. -Philip-

Hi If any body worked with Sencha frame work with Progress back end, kindly share any details/links/information or some architectural approach. -Philip-

Hi, While I was debug some issues with webservice , I found that once I changed the Name Server port as same as that of the appserver broker port (and started the appserver) then the wbeservice responses appears fine. Till that time I got any responses from the respective webservice. Is it...

Hi, I am getting an xml file from a 3rd Party software. I want that to pass that XML into a Web Service Program. How can I do that. LongChar as input we tried, however it is not accepting. Please give a solution. TIA -Philip-

Hi , Can you please suggest a Logic/Design to Export the data to another software in an incremental manner when a scheduler Runs. Ex:- In Item Master , if 2 records got changed after the last upload then next time only those 2 records to upload . 1.This is a new integration Project 2.We are...

Hi, I have to develop webservice to bring the Sales order data. 1.Customers can fetch the data. 2.Customer Admin can fetch data 3.Sales rep can fetch data Data will be same always however when customer logins he can see only his sales order data, if customer admin logins he can view all...

Hi, If any body integrated Drupal with any Progress Application ? If so share some technical info . -Philip-

Hi, I am trying to show some data in Kendo grid from Progress DB. Item NO Description Order Qty (Prev Month1 ) Order Qty (Prev Month2 ) Order Qty (PrevMonth3 ) ----------- ----------------- ------------------------------ -------------------------------...