RE: What is the difference between SQl Object and SQl ...
SQL Object is a peopletool definition which can be created using app designer as well as using peoplecode command CREATESQL( ) it is mainly used for reuseablility of the sql statements. so whenever this statement is required no need to hard code just create an sql object of the same and use where ever it is required.
sqlexec is a peoplesoft delivered function used to retrive only one row and u can update multiple rows of data. It directly interacts with the database.
RE: What is the difference between SQl Object and SQl ...
SQL object is used for reusability in the sense once instantiated the data retrieved out of it can be used for further caculations logically. Physically at a database level it takes a trip to the database server only once. SQL Exec takes a trip to the database server evertime its used.
