Recent content by J V

  1. J

    How to make focus

    HI All, I have some validated fields in a form. When User inputs and hits go <F2>, if there is wrong input in 2nd input box, I want the cursor goes back to that particular fill-in box, but in my case it always goes to the first fill-in box. Please, suggest, how do I focus on particular...
  2. J

    Left Outer join

    Can any one tell me please, whether we can use left outer join in for each statement. I tried to use it, and it gave me error message saying: "Join may be used only in open query". Thanks a lot.
  3. J

    Screens Hangs .

    Hi, I have a simple user interface in 4GL to call a report designed in Report Builder. When I run this from Progress environment ( runing directly from procedure editor) it works fine. But, when I compile and try to call this screen from MFGPro, the screen appears within the MFGPro window...
  4. J

    SQL Vie does not appear in Report Builder

    I would like to use my sql view that I created in Report builder. But, I can not see my views in report builder which exist in database. How can I see and use that view in report builder. Thank a lot.
  5. J

    How to convert data type

    I am writing sql statement and need to convert char field which contains numeric value into decimal. I tried to use both: CAST(expression AS data_type) and CONVERT (data_type[(length)], expression [, style]). but looks like progress does not support both of these functions. When I use one...
  6. J

    What is the appropriate table(s) to use

    HI All, I have to make an inventory related report (Material Balance), where I should show "Begining Inventory Balance", "Receipts", "Adjustments", "Shipments", "End Balance" etc for the given range of date. Which is the appropriate tables(s), I should use for this purpose. Thanks a lot.
  7. J

    How this relationship works?

    Thanks Thanks, dermie It helps.
  8. J

    How to Create SQL View in Progress?

    I created a *.d file with this content: CREATE VIEW sales_add (code, name, address1,address2, city, state, zip, country) AS SELECT SP_MSTR.SP_ADDR, SP_MSTR.SP_SORT, AD_MSTR.AD_LINE1, AD_MSTR.AD_LINE2, AD_MSTR.AD_CITY, AD_MSTR.AD_STATE, AD_MSTR.AD_ZIP...
  9. J

    How this relationship works?

    How the relationship between ih_hist and sp_mstr , works? Do I have to make 4 different joins like these, if there is a array of fields like ih_slspsn[4]: ih_slspsn[1] = sp_addr ih_slspsn[2]=sp_addr ih_slspsn[3]=sp_addr ih_slspsn[4]=sp_addr or is it sufficient to make just one...
  10. J

    Reports Deployement Problem

    HI All, I am having problem in the report deployement. Please answer me, if it is an appropriate place to put this question and anybody had similar problem and solved it. I am using Report Builder with progress 8.3D to build reports. I have some of them already built, but right now I am having...
  11. J

    Which program file I should customize for customize checque print

    Thank you Thanks Dermie I'll let you know, how far I go successfully.
  12. J

    Which program file I should customize for customize checque print

    HI All, We need to customize the cheque printing screen in MFG/Pro, can some body pls tell me which file I should change/modify to customize the checque printing screen. Thanks.
  13. J

    How to use Query Analyzer in Progress

    HI all, somebody, please tell me, how to use interactive Query Analyzer (SQL) tool in progress? I was using MS SQL Query Analyzer before, but could not find anything similar in Progress. Thanks.
  14. J

    Crystal Report with MFG Pro and Progress

    HI All, I'd like to integrate Crystall Report for reporting with MFG Pro. I wonder, have any one done this before? What is the procedure, and where I can find the reference materials about this. Many thanks.
Top