By using SQLExec function we can do the manipulation to the database. we can write insert,update,delete sql commands.But drawback while selecting the data using sqlexec, it will return only one at a time.another drawback, if the name of the records changed, then you have to make the changes in the code as the query will in the quotes inside sqlexec
Above answer was rated as good by the following members: shalini kumari
RE: whats the advantage and disadvantage of sqlexe in ...
By using SQLExec function we can do the manipulation to the database. we can write insert update delete sql commands.But drawback while selecting the data using sqlexec it will return only one at a time.another drawback if the name of the records changed then you have to make the changes in the code as the query will in the quotes inside sqlexec
RE: whats the advantage and disadvantage of sqlexe in ...
Also SQLEXEC function has one more disadvantage where it will not pick up related langauge data automatically. You have to explicitly fire two SQLEXEC's one for base langauage and one for related language by Checking Language_User
RE: Whats the advantage and disadvantage of Sqlexe in peoplecode?
Also SQLExec will open a new session on database so if anything has been updated in Comp Buffer will not be available in that session as COMMIT might not have happened. Also if we have selected some value in Comp Buffer and then change the same after with SQLExec we are creating a problem with data.
1 
0