Search results

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...

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...

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...

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...

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...

I have finally found a way in our ERP system to run windows programs on the client machines, but I have a small problem. What I have done is write a small .p {v:\vantage\vbp\vb.i} Define Variable RMARowid as Rowid no-undo. Define Variable strWRR1000 as char no-undo. set RMARowid =...

I have only written 4gl app that I run after using Data Dictionary to connect. I now need the app to connect and disconnect with any intervention form me. The CONNECT seems to be the right function, but what do I need to put in the .pf file to connect to a remote machine. Here is my...

I was wondering if there is a simple FOR or FIND statement that will search all tables and records in a progress database. I have never seen any function like this with other databases, but my boss swears he changed a bunch of part numbers in symex with only 4 lines of code. He said he didn't...

I have just written my first 4GL app and was very surprised when the compiler told me it couldn't compile because the version of Progress I have doesn't allow updates to the database. Well I went to get a quote on Provision. Now I used appbuilder in a training class and it wasn't bad, but...

Or software vendor has done something wierd with a logical field that pertains to Job Numbers in our database. They created a table called ComXref and put Job number amoung other information into ComXref.Key1 field. I am new to 4GL so can I join the Job table and ComXref even if there is no...