Recent content by John

Hello All, I am new in QAD EDI Ecommerce. Could you please help where and what to check for following issues? 1. ASN not received at QAD side. 2. outbound ASN fail Thanks

Thanks for the reply. We have to compare NOW with last update date variable[ data type is datetime].

Hello Team, There is a requirement to send email after 10 and 20 hours. Could you please suggest function to calculate time difference in hours? Thanks

Hello Team, I am writing code to generate XML file for a table record. It is generated with some incorrect tags so I have to use replace statement to get XML in expected format.Could some provide me better solution than using replace statement? Thanks in advance. PFA the files as follows [ I...

Thank You. Requirement is write a .p program which will do following, 1. get the file from WINDOWS server [D:\] 2. Copy this file to unix server [/home/us] 3. Delete the file from WINDOWS server [D:\] once it is copied to unix server [/home/us]

Thanks for your reply. We are using 10.2b. Could you please provide some sample code for both approaches you mentioned? Thanks in advance

Hello Team, I have a requirement to move file from a windows server to unix server. Can someone suggest how to include code for this in .p ? Thank You.

Hello Team, I need help on following requirement: I need to search a file "mydoc.pdf" in unix directory "/home/sk" by using Unix command "find". Please let me know how to use unix command for this in Progress code. Regards

Hi All, Can someone help to extract ps_mstr data in XML format? Thanks in advance.

Thanks to Cecil also for the response. - There was no record showing when i run above code but when I ran "for each" for ttCallOFF only then I was able to see the records in it.It means,in your code also ttPurchaseRequisitions table is not getting populated. I am not able to identify where is...

Thanks for this Tom. I am not able to figure out why Temp Table ttCustomer is somehow not getting populated. Could you please advise? Thank You.

Thanks for your reply Tom. A do not see where you have made the changes in my code. Could you please send updated & working snippet. There are only tow TT: 1) ttCustomer for <PurchaseRequisition> 2) ttOrder for <CallOFF> Regards

Hello Team, Somehow temp table "ttCustomer" is not getting populated while values for flag "lReturn" is coming true. Kindly suggest what I am doing incorrect. There can be multiple "<CallOFF>" tags under one "<PurchaseRequisition>" tag. PFB the progress code and XML file: Thank You. DEFINE...

Thanks Cecil. Let me check if this works for me and will get back to you. Thank You.

Hi Team, I am not getting XML output in desired format using below code. Could someone suggest in this? DEFINE VARIABLE cRequest AS LONGCHAR NO-UNDO. Define temp-table tt-Code no-undo Code as char AccountRangeFrom as char AccountRangeTo as char...