Recent content by John

  1. J

    date difference

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

    date difference

    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
  3. J

    XML creation with incorrect tags

    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...
  4. J

    copy file from window server

    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]
  5. J

    copy file from window server

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

    copy file from window server

    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.
  7. J

    Unix Find command

    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
  8. J

    Product structure in XML format

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

    Error Problem in reading XML using dataset

    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...
  10. J

    Error Problem in reading XML using dataset

    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.
  11. J

    Error Problem in reading XML using dataset

    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
  12. J

    Error Problem in reading XML using dataset

    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...
  13. J

    Creating XML

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

    Creating XML

    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...
  15. J

    XML-Read issue

    Thanks for your reply. I would be able to test this in next few hours but could you please tell me the reason for this change? Regards
Top