OmegaDevX
asked on
Using SQLCA, Which Database & Tables Are Being Used
I'm a beginner in PowerBuilder 6.5 and I'm trying to find which database and tables are being used in this application. The app has PFC and I don't know what search criteria to look for in all of these PBLs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Don't forget checking datastores also.
You should also check for "inline" SQL statements. ( Yes, I thought we had grown far enough as a race of Powerbuilder developers to eradicate this ugly fungus but alas, it still does exist! ) Inline SQL describes SQL statements that are called directly from Powerbuilder scripts (and not through datawindows or datastores...) BTW, inline SQL is generally viewed as bad practice. But to find them, in your library painter you can search through objects. Search the objects for words such as SELECT, UPDATE, DELETE, etc.
If you just want to see what's happening on the backed without regard to where the stuff happens in the Powerbuilder code, you can always trace the database to see the transactions (ok, I know that's not what you really want...)
You should also check for "inline" SQL statements. ( Yes, I thought we had grown far enough as a race of Powerbuilder developers to eradicate this ugly fungus but alas, it still does exist! ) Inline SQL describes SQL statements that are called directly from Powerbuilder scripts (and not through datawindows or datastores...) BTW, inline SQL is generally viewed as bad practice. But to find them, in your library painter you can search through objects. Search the objects for words such as SELECT, UPDATE, DELETE, etc.
If you just want to see what's happening on the backed without regard to where the stuff happens in the Powerbuilder code, you can always trace the database to see the transactions (ok, I know that's not what you really want...)
ASKER
The answer was clear and the steps were easy to follow. Thank you Bhatti ! I hope you stay online.
You can reach me at tnorton@greyhound.com
Tracy
You can reach me at tnorton@greyhound.com
Tracy
Did you find the tables and database?
Bhatti