Recent content by cgdev

  1. C

    Qxtend Query WebService.

    Hello Progressers, I am stuck on configuring/implementing Query WebService through QXtend so that we could query MFG/PRO data from third party applications using XML. I have followed all the steps given in the "fundamentals of QXtend Training Guide". But, while executing the request...
  2. C

    Customization in MFG/PRO.

    We are implementing QAD EB2.1 at one of our locations. And, During the process mapping we are planning to develop a customized program for scheduling the work orders(This would display the wo data in a browser type of format). While browsing the data we would like to allow the users to update...
  3. C

    Enable Audit Trial in custom developed programs.

    Thanks a lot MAX. The information provided by you was informative as knowledge point of view. Eventhough I had access to menus but It looks like we do not have licences for Enhanced controls module. I found an work around to create the aud_det records as currently MFG/PRO does for most of...
  4. C

    Enable Audit Trial in custom developed programs.

    Hi Progress Talkers, I am currently working on MFG/PRO eB2.1. I am trying to delete the user groups assigned to a user when a user gets resigned/terminated in order to disable to the privliges in MFG/PRO. While doing so I wanted keep an audit trial for the same. I am unsuccess tried...
  5. C

    Migrating from v7 to V9

    Hi, You can still develop new modules in Windows by keeping your DB on SCO. You can connect to DB by providing -H and -S startup parameters. I feel unix servers would be more stable than Windows most of the times. Please correct me If I am wrong.
  6. C

    Delete an item in a comma separated list

    Hi, As far as my knowledge there are no methods to delete entries from a comma separated list. I think you are talking about the delete method on widgets like combo-box, selection-list etc. I think replace might be an easy way to delete the entry from a comma separated list if you know...
  7. C

    Migrating from v7 to V9

    Hi, As you are saying this application is developed in v7.3C the business logic might not have separated from User Interface. If your business logic is separed from User Interface then it will be easier to convert the UI. It will be a massive task to convert the application to any UI...
  8. C

    Object Code Compare

    Hi Ajay, The following links may help you. http://www.fast4gl.com/frame.html?http://www.fast4gl.com/downloads.html http://www.peg.com/lists/peg/history/200412/msg00882.html
  9. C

    HELP -> making a new empty db

    A simple thought. You can delete the data from the tables as you are saying the data inside the database is demo data. You can try doing the following steps. 1) Take a copy of the existing database. 2) write a simple code to archive and delete the data using meta schema details. 3)...
  10. C

    Buffer-replace

    You can find the record using the unique index on the table using find-first method on the buffer handle of the table. And, use the buffer-copy method to copy the data from temp-table to database table. I hope this might be a new suggestion..:) Thanks & Regards, Gurudev
  11. C

    Pass value from fill-in to Varaible Help

    When you modify any data in frame it changes only screen-buffer and not the actual value of the variable. You can resolve this by two ways: 1) Assign the screen-buffer value to txtStartDt on leave event of txtStartDt. 2) If you don't want to change the initial value in txtStartDt then...
  12. C

    Using Dynamic Queries on Dynamic Temp-tables

    Hi Paul, Thanks a lot for the code snippet. It works great for static temp-tables or database tables. This code fails when I tried to use this code with dynamic temp-tables. I am still getting the error 7328. PROGRESS could not able to understand when I use the field name of the...
  13. C

    Using Dynamic Queries on Dynamic Temp-tables

    Hi ProgressTalkers, I am trying to develop a common program to compare two delimited flat files and generate a delta. I have opted to use the dynamic objects to develop this program. This following is the glance of the design: 1) Check both the files have same format (First row is...
  14. C

    foreign keys

    As far as my knowledge, PROGRESS does not support the foreign key concept. But, you can enforce the foreign concept by DB triggers. Assume the following Example Dept Table : Dept No, Dept Name. Emp Table : Emp No, Emp Name, Dept No Etc.. In this case Dept No in Emp is a foreign key...
Top