Recent content by agriffin02

I found it... it is the PayrollDate that is the important column. This column is used for the date range in the Labor Edit Report.

I am integrating an application with Vantage ERP 6.10 software. I am running on Progress 9.1D. I am trying to add records for Labor tracking entered from other systems. I can get the LaborDtl and LaborHed records populated and things show up in the Labor Entry, however, nothing is showing up...

UPDATE [TABLE | INDEX | [ALL] COLUMN] STATISTICS [FOR table_name]

Also, where can I get my hands on a 9.1E Service Pack 4 download.

What is the SQL-92 syntax for running Update Statistics?

I have a c#.net windows application that I have developed that is accessing the Progress 9.1D Database using the Merant ODBC driver and running SQL92 statements. Performance seems pretty crummy. It appears that the performance on a particular query is faster after it runs the first time, but it...

I have a c#.net windows application that I have developed that is accessing the Progress 9.1D Database using the Merant ODBC driver and running SQL92 statements. Performance seems pretty crummy. It appears that the performance on a particular query is faster after it runs the first time, but...

I having some problems with the performance of retrieving and updating data in Progress. I want to try using indexes because it seems like every time I run a query, it is doing a table scan. Is that right if you aren't explicitly using an Index? I get a syntax with this statement: select *...

I am using the Merant ODBC driver to connect to Progress. Do I use the same assign statement? I have noticed that SQL insert statements do work to at least insert data into the database.

If I do find a sequence for the column that I want, what is the syntax for using a sequence in an insert statement?

I appologize here, I am a newbie with Progress. Can I setup a sequence without affecting any other processes that are going on? Or how do I find out if there already is a sequence set up for this table and column?

How would that syntax look if I am using table below: TestTable Id int Descr varchar insert into TestTable (Id, Descr) values (??, 'My Test')

Hmmm... I can't use a trigger, I would break the current software that is using the database. I am working on some external software that expands the capabilities of Epicor's Vantage which is using Progress 9.1D. When I insert into a particular table that has an sequential id on it, the id...

Does Progress have auto incrementing type fields? If not how can this be handled as to not duplicate keys in the system?