Can we check sqlcode of a subquery..if yes how?
[ Post made via Android ]
Can we check sqlcode of a subquery..if yes how?
-
- New Member
- Posts: 8
- Joined: Sun May 04, 2014 12:25 pm
- Robert Sample
- Global Moderator
- Posts: 1895
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: Can we check sqlcode of a subquery..if yes how?
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.
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.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute