Recent content by emtgdkr

Thanks , This is something simliar that I suggest to BB. I will discuss it with him. thanks

The problem I am faced with is that ; The vendor does not want us to create new indexes on the production datbase. This is bad for new releases and such. So we want to have our reports db separate with indexes that will not be in production. thanks

We are trying both ways. If we copy the datbase I was looking for a way to re-create indexes. the crerate index does not because the database was not created that way by the vendor. in the dump and load. We were trying to figure out how to clear out the datbase then load it. We were...

We are using progress 9.0b patch 44. We are replicating our production database over and crerating a reporting version. I would like to add indexes to certain tables in the reporting database to improve report speed. What is the best way to create these index tags each night? thanks :o

I am using Progress 9.0b patch 44 with merant 3.50 odbc and crystal reports 8.0. I install the fix on crystals web site for left outer joins and it only works if I use 2 tables. If I try to add a third table or more, the SQL statement built inserts Parenthesis and give me the ODBC Error...

Thanks it work great!!!! :)

In your example I still have a couple of questions. When your sending the errors/warning messages to the ouput to (errormsg.txt) for example do you need to define this txt file first in the procedure? Second, would I need to have this output to statement in the export-data procedure that...

We tried this but , It sent the error messages to the data file we are creating the output stream to command.

We have several character file exports programs ( Procedures) (*.P's) that have been compiled (*.r's). We are calling these from a batch file and they were running fine until a few days ago's. At the end of the program we have a quit in there so that we exit progress completely. Now we are...