Search results

Yes, I have tried that. I think the problem is that the information is coming from two separate tables. I believe this requires a nested statement but I have not been able to get the right syntax down. The two tables are PUB.Part and PUB.JobHead. I am hoping that somebody will have the right...

Hi everybody, I am hoping somebody will have an answer for me. I have been getting the following error when trying to copy the contents of one field to the contents of another field. Both fields are in different tables. ************************************************* Error: Syntax error...

Hi everybody, I am hoping somebody will have an answer for me. I have been getting the following error when trying to copy the contents of one field to the contents of another field. Both fields are in different tables. ************************************************* Error: Syntax error...

Hello, I am wondering if it is possible to dump our database into an open source ERP such as Compiere MFG+SCM. We are currently running Progress91D and Vantage 6.1 and upgrading is out of the question. We have found that Vantage 6.1 does not have some scheduling capabilities which we need. When...

What is OE replication plus? The idea my boss has is to have two databases, one for live use and one for forecasting purposes. He also likes the idea to have a working version of our database for fallback in case of failure of our live database. What I am hoping for is a way to do this via...

Hi, We are running Progress91D with Vantage 6.5. Lately users have become "locked" into our system (mostly by ignoring errors and repeatedly hitting the enter key). I think it is because our database is approaching the 2GB barrier. Any thoughts? Thank you, Steve Kuchta

Hi, We are running Progress91D with Vantage 6.5. We currently have our "live" database and one we intend to use for manpower/machine forecasting. What I want to do is dump our "live" database into the forecasting database and run reports to see if we have enough capacity to take on various...

What do you mean by "reorganize" the database? Thank you.

Database migration Hi everybody. I never have solved the last problem I posted - but still working on it. I am wearing a different hat today. We run Progress 91D with Vantage 6.1. We have purchased a new server. We plan to have the old server up and running while the installation of the new...

I tried the line of code below to disable the triggers - it seems to work. I will enter some value, hit enter, it hangs for awhile, and then it prompts me in the status bar area that the procedure completed and to hit the space bar to continue. I then open the database and the value has not been...

I would also like to know how the Belgian beer was.

Unfortunately, I seem to be wearing a lot of hats these days. I am the network administrator and the database administrator and the development team and... But that's OK. There is not an already corrected csv file, that would be great but I have not had time to try that one. What I have been...

I've had a fair amount of programming experience. The language I've seen in Progress is very similar to C. But it has been a long time since my programming days. They do know how the data was entered incorrectly - it wasn't me - but I have been tasked to figure out a fast and accurate way to fix...

Hello, my name is Steve Kuchta. I live in South Dakota and am putting up with a generous dosage of snow we've had over the past few days. I am fresh out of school with a degree in Networking. I am currently getting a self-taught crash course in Progress and Vantage. I have all of two weeks...