Recent content by franklin1232

Well I fixed the propath problem, but the write.r in the database trigger is looking for a shared variable. Anything I can do about that.

I had a problem finding the trigger code in my application and I am pretty sure it's a propath problem. The path to the trigger in data dictionary is "db/trg/shiphead/write.p" The full path is "u:\mfgsys61\db\trg\shiphead\write.p" This is a snippet from the custom ini file our ERP vendor...

Since the database design is not mine and I am leary of making chages to it. What would be the safest way? Some addtional info: I opened the table with Data Dictionary and checked the trigger path on the ShipHead table. When I click on the trigger button I get an error stating that...

Can I use the DISABLE-TRIGGERS some how to keep this error from coming up. I notice in the data administrator the trigger is pointed to the .p file as well. How does the ERP application force it to run the .r

I am not a 4GL expert by any strech of the imagination, but I have written some simple procedures and I have one that no longer works. Our ERP vendor (epicor) has put a database trigger on the write of the shiphead table that wasn't there before. The trigger is stored in the database folder...

I see what you are doing and it makes sense now, but Vantage is not as consistant as MFG PRO. The fields do not all have the same naming convention. Plus I don't see how you are finding all the tables with the part number field. For instance if I create a job for part number 12345. Records...

I have been looking at your code and I am not sure I understand. Does you code pull all the tables and fields that I want to search from the database. Are you using the _field just as a place holder. My biggest problem is I don't know all the field names or table that I need to update and it...

He claimed it was possible because the company he worked for owned source code. I don't see how that would help. Plus if it can't be easily done now I would imagine 8 years ago it would have been very difficult.

We use a package from Epicor called Vantage which runs on the progress platform. But my question is about Symix because our controller used Symix in a previous life and swears that he wrote less than 10 lines of code in Symix that changed all of his unwanted part numbers and all of there...

Thanks Thanks much cecsno. I will be running this against test data many times before using any live info.

My accouting manager wants to modify a bunch of part numbers. Some he wants to change to a dummy part number others he wants to consolidate mutilple part numbers into one. Our ERP does not allow us to archive or change a part number after it has history. So what I want to do is a find and...

My progress 9.1c server has the ability to spawn 2 SQL brokers each allowing one connection. Problem is the the brokers use up large chunks of memory and never seem to release it. I have seen them use up to 800mb of memory. We do very little with ODBC so what can I do to keep the SQL brokers in...

The sales and marketing team is looking to do some data analysis and forecasting. For what they want OLAP is the ticket. We have about 5 years of historical data in our system and forecasting capabilites. I was hoping to use Crystal Reports to turn this in to something friendly to look at...

Overlay? I am not sure I know how overlay works, but I printed some sample code. I also tried a fixed font still not lining up though. Here is what I wrote: DO While Available(NonConf): Assign ChrWrkCenter = string(wrkcenter.WCcode,"x(10)"). Assign ChrJobNum =...

I have a combo-box that has three database fields filling each line. How can I format the columns to line? Is there a columns property. I tried something from an earlier post. cmbop:ADD-LAST(string(wrkcenter.WCcode,"x(15)") + string(NonConf.JobNum,"x(25)") + ChrOpNum). This didn't line...