How to view records ??

[kevin_w]

Hi,


I have an inventory program that is running on a progress db (version8.3B) now i wanna know how to look up a record directly in the database.
So for example:

- I start-up the inventory program
- I make an new part example: Cola bottle
- How can i look and modify this record directly in progress 8.3B

I have to delete some records but the program itself doesn't allowed it, so it must be direct in progress.

Thanks

 

[vinod_home]

Hi,

I think you need to pull up the documents from the progress site and go thru them.. Or better even hire a consultant.

http://www.progress.com/products/documentation/index.ssp

Lookup : Progress 4GL Handbook Sample Procedures

hope that helps,

 

[jongpau]

When you say that the program does not allow you to delete the records, does that mean it never allows you to delete records or does itsometimes allow it and sometimes not?

If your answer is the last of the two, there will be a very good reason for you not being allowed to delete the records. There may be records in other tables that depend on the information in the record you want to delete. Going in and deleting that record can then seriously damage the integrity of your database.

I will explain using your example of the cola bottle. There may for instance be orders placed in the past for that cola bottle. If you have a good application, the order line will then have a reference to the unique code of the cola bottle stored. When required, the application can then use that relation to pull up the information about the cola bottle (that is where the R in RDBMS comes from). This means that the application does not have to copy every bit of information about your cola bottle across to the order line, which will save you a lot of disc space, give much better performance and does not require all orderlines to be changed when something changes in the product.

So, if you don't exactly know what your application does AND how it all works on the inside, I would advise you not to just jump in and start messing with the information in the database. As suggested in the previous post, it would probably be better idea to hire yourself a consultant (preferably someone that specialises in your application, but at the least someone who knows how Progress works). It may cost some $$ now, but in the end it could save you a lot more $$ (not to mention time and headaches).