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...
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.
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...
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.
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...
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.
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...
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...
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...
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.
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.