Search results

  1. A

    Error Please Press Enter on User ID

    I am using Mfg-Pro eB2 SP7 . I am a system admin and I created a two new user id and this error is faced while logging in through those new ID's. As I understand it is not a program issue. I have attached the screeen-shot of the error message. Please help. Thanks in Advance.
  2. A

    Put Unformatted issue

    Progress Version : eB2.1 ERP: QAD-Mfg/Pro I want to know what does the following code does. PUT UNFORMATTED "^XA" SKIP "^XB" SKIP "^PRC" SKIP "^ADN,30,20^FO535,99^FD" CAPS(tag_loc) "^FS" SKIP "^AAN,18,10^FO535,75^FDLUGAR^FS" SKIP "^AAN,18,10^FO30,75^FDLOCAL^FS" SKIP "^ADN,30,20^FO30,99^FD"...
  3. A

    Importing from csv with changing order of columns

    Hey thanks, I took the footer sentence of the report xls as the end line. Works fine. Also I dont need to create CSV. Now my job is efficiently handled right in excel. Thanks again.
  4. A

    Importing from csv with changing order of columns

    My apologies since I could not find the e-mail in my inbox for my previous thread and so I lost track of it. I tried importing converting into Excel but the problem I face here is since my data is not sanitized my repeat loop exits when it comes across blank row. retrieve_data: repeat: /* if...
  5. A

    Importing from csv with changing order of columns

    tmpinv_InvNbr tag month tmpinv_SugDate(dd/mm/yyyy) xyz lmn pqr 123 inv-11 march 12/03/2012 -- --- --- 125 inv-11 may 15/05/2012 -- --- --- 156 inv-12 june 20/06/2012 I am importing data from a csv but order of the column (invoice suggested) is...
  6. A

    Import using CSV based on a header or the file.

    Hi, How do I import from a csv into my database fields dynamically? Since the order of the columns keep changing from the client how do I handle which column goes in which database field. I need to be able to decide based on the header of the columns which do not change. Can it be done? I am...
  7. A

    Significance of "~" symbol

    Problem solved!! I used PUT STREAM mail UNFORMATTED "(~"http://schemas.microsoft.com/cdo/configuration/sendpassword~") = " + "~"" + GetCodeMasterDesc("XX_EMAIL_ACK","mis@tspl.com") + "~"" SKIP. Thanks everyone for the prompt replies.
  8. A

    Significance of "~" symbol

    Thank you all for the replies. But I need to call a simple function in place of the string "abcdtestpassword". The function returns the string "abcdtestpassword" which it fetched from a database table. The problem has arise since the whole statement is within ~(tilde). I'm looking for...
  9. A

    Significance of "~" symbol

    Actually we are going through our codes for removal of hard-coded strings replacing them by our field variables. PUT STREAM mail UNFORMATTED "objMessage.Configuration.Fields.Item _ " skip. PUT STREAM mail UNFORMATTED "(~"http://schemas.microsoft.com/cdo/configuration/sendusername~") =...
  10. A

    how to store the all field labels in a temp-table

    Does it suggests that i have to write different loops for each of my fields? Coz' right now my live environment is working on similar code. Actually wanted to avoid it. And since there is redundancy in processing and the employee master table has huge records its taking a lot of processing time...
  11. A

    how to store the all field labels in a temp-table

    My apologies. I am on progress 91d and yes it is an inhouse application. My problem is: I want to create a dropdown of the employees who are either "Delivery owner","Invoice Owner","Account manager","Primary SalesPerson" of any project. Pls. note all the above are fields pj1_delivery_resp...
  12. A

    how to store the all field labels in a temp-table

    I have employee codes stored in fields a,b,c,d of table prcjt_table. Now i need what employees are stored in which fields of diffrent projects.
  13. A

    how to store the all field labels in a temp-table

    how do you store the all field labels of a table pj1_mstr in a temp-table ttable?
  14. A

    List of employees who are delivery mangers, invoice owners, etc..

    I am facing trouble recording and handling the field labels.
  15. A

    List of employees who are delivery mangers, invoice owners, etc..

    I want to create a dropdown of the employees who are either "Delivery owner","Invoice Owner","Account manager","Primary SalesPerson" of any project. Pls. note all the above are fields pj1_delivery_resp, pj1_invoice_resp, pj1_act_mgr, pj1_sp6 in projectMaster table i.e pj1_mstr which store...
  16. A

    How to copy a record in a temp-table to a table?

    Thanks a ton. I know it sounds dumb but I did not use Create statement. Thanks to both of you.
  17. A

    How to copy a record in a temp-table to a table?

    Can u please elaborate? or give a small example?
  18. A

    How to copy a record in a temp-table to a table?

    BUFFER_COPY as you suggested helps copy records in a table to a temp-table. But not vice-versa. I have tried following: /*================================*/ find first tt_pj1_mstr. if available tt_pj1_mstr then do: buffer-copy tt_pj1_mstr to pj1_mstr. end. /*================================*/...
  19. A

    How to copy a record in a temp-table to a table?

    I have a record in temp-table tt_pj1_mstr. I want to copy/append that record into the existing table pj1_mstr. Thanks in Advance.
  20. A

    How to copy all fields of a row in a table to a temp-table?

    HI, How do we copy all the data in each of the field of one particular row in a temp table. for eg. DEFINE TEMP-TABLE LIKE project_master. FIND FIRST WHERE project_id = "123" Now I want all the information in all the fields of the record in project_master whose project_id = "123" into my...
Top