Search results

Hi All : We had a wrapper written on Item Planning Maintenance program to restrict users not belonging to a certain group (User Group) not to update Supplier field (ptp_vend). The program works fine when the user not belonging to that User group try to enter / modify the data, but if he does...

Dear All : I am getting the following error when one of the date field is blank in my data. I tried to select only those records where that field is not blank : WHERE xxkbh_plan_deliv <> ? but still I am getting the following error when we are calculating the elapsed days ...

Hi All : I had created 2 temp-tables, one with items to be deleted and their components. The other table excluding the items to be deleted. I wanted to do a find on the 2nd table by picking the 1st component on the 1st table and if that item is not used in any other parts then mark the...

Hi : We had customized "soivrpa10.p" and taking the output to a file and sending across to a 3rd party to print the invoices on pre-printed stationery. We wanted to customize it now to drop printing zero invoices. How do I achieve this ? Any help in this regard is greatly appreciated...

Hi : We had customized "soivrpa10.p" and taking the output to a file and sending across to a 3rd party to print the invoices on pre-printed stationery. We wanted to customize it now to drop printing zero invoices. How do I achieve this ? Any help in this regard is greatly appreciated...

Hi All : Could anyone tell me what is the file number shown with DBTOOL utility. I tried to query _file (_File-Number). For example : Current max fieldLen for tr_hist (696) : Fld# SQLWidth Max Width ERROR NAME ---- --------- --------- ------ ------ 2: 30...

Hi : I wanted to adjust SQL Field width using OE 10 on my PC. How do it achieve this ? i.e. connect to the database residing on Unix and modify the SQL field widith. Any help in this regard will be greatly apprecited. Thanks, Ramamurthy Dasari

Hi All : We are planning to upgrade from Progress Ver 9.x to 10.x with QAD 2007 and wanted to find out how much time it has take for the transistion. We are having problem with the upgrade which is almost taking around 6days and wanted to find out if we are doing something wrong..... Any...

Hi : I am trying to use ih_hist and idh_hist and trying to get the total sales orders (idh_nbr) but the total is not correct. Could you please go through the below code and let me know what's wrong : for each ih_hist where ih_ord_date >= dt and ih_ord_date <= dt1 and ih_userid >= fusr...

Hi : I wanted to upload this data (in clnrloc.in) : "08490-0002" - - - "20" - - - - - - - - - - - - - - - - - - . "08490-0007" - - - "20" - - - - - - - - - - - - - - - - - - . "08490-0009" - - - "20" - - - - - - - - - - - - - - - - - - by using the following program : input from...

I wanted to upload this data : "08490-0002" - - - "20" - - - - - - - - - - - - - - - - - - . "08490-0007" - - - "20" - - - - - - - - - - - - - - - - - - . "08490-0009" - - - "20" - - - - - - - - - - - - - - - - - - using the following program : input from "clnrloc.in" no-echo. repeat...

Hi : Wanted to find out if there is a way in QAD to find-out what patches were applied. Thanks, Ramamurthy Dasari

Dear All, I have around 9 years experience as a Progess DBA/Systems Analyst. My experience include programming , network and unix administration also. Currently based in Toronto and willing to relocate. Will provide more information and resume upon request and available on site within 3...

Dear All, I have 7 years of experience as a Progress DBA. My responsibilities include Progress Database administration, Unix / Novell administration, enhancements to local programs, Project implementation, trouble shooting, debugging and writing new programs for the manufacturing site...