Can we check sqlcode of a subquery..if yes how?
Posted: Thu Apr 19, 2018 11:47 am
Can we check sqlcode of a subquery..if yes how?
[ Post made via Android ]
[ Post made via Android ]
Pull the subquery out and run it as a query.
The sqlcode is set when the SQL statement completes. When the subquery executes, it is part of the SQL statement and hence the subquery will not get an sqlcode since the SQL statement is not yet complete.