Recent content by Mady

Requesting inputs here. Please suggest. Thanks.

Hi All, Requesting your help here. We have a tool, where we use Progress SQL to make reports. I am getting an invalid date string error, when I try to execute below-shown query. The surprising element is that the moment I add another clause in the outer WHERE condition i.e. "*wh_num = 50" - I...

Can you please suggest any example of how to do this. I am trying below and getting error "Could not locate method 'Put' with matching signature in class 'OpenEdge.Net.HTTP.RequestBuilder' (14457)". Some direction about exact signature and syntax would be really helpful. oRequest =...

Hi All, Requesting inputs/starting instructions on pushing file, generated through progress code, to S3 Bucket. We are simply exporting a CSV and sending it to our email address at present. Instead of this, we want to push the file to S3 bucket and from there push it to another shared folder on...

Thank you very much Cringer. I put in some time for the temp table approach and yes I was able to achieve the result and also no need to increase the client session parameter. Thank you very much Stefan.

Hi All, Request your advise on my above June 10 reply ?

I have been trying to find the right place where I can increase the -TOK -INP parameter. Meanwhile, just giving some more information to know if I am missing out on some other important concept. The query string, which I have given in this post is passed to a program file, which is on the server...

To me a bit more clear - It happens like below. 1. Query gets prepared through below logic IF NUM-ENTRIES(searchstring) > 0 THEN DO i = 1 TO NUM-ENTRIES(searchstring): cOrd = ENTRY(i,searchstring). IF i = 1 THEN DO: IF...

Hi All, Can you please advise how to execute the attached query ? It is getting executed dynamically in the code and I was getting No data found in the end. When I execute this query in editor, I get this error ** More than 1024 items in a single statement. Use the -tok parameter. (136)

Sure, I will try defining input streams and will see how it goes. Thanks for responding.

:) .. Thank you very very much Rob .. I also took your comments seriously and went to improve the formatting first and then tried to understand the issue. I could not find the reason, but it is something to do with the update statement. I just thought of trying this with Temp-Table - Created a...

Hi All, Seeking some conceptual advice here. Somehow UPDATE statement is not showing up when I run the attached query. Initially, I was using ASSIGN statement and it was working fine. But as I wanted to see the data on screen and then update it, I used UPDATE statement (Line#115) instead but...

Thanks Tom

I can use SET email with FRAME a. But, is there any other good coding standard technique ?

Below query works fine with PROMPT-FOR DISPLAY "Input" WITH FRAME a. PROMPT-FOR ITEM.co_num ITEM.wh_num WITH FRAME a. for first ITEM WHERE using co_num and wh_num: disp abs_num. I have to take email address also from the user through screen and that email I will use to send an email with...