>I'm going to try using the 'BEGIN ... END' block syntax and just pad a linefeed character and see if this will work.
Wonder of wonders! I used the BEGIN block syntax and it worked! Here was how I called the stored procedure:
assuming gnConnection is a valid connection;
lcSPString = [BEGIN testspace.sp_test_call; END;]
lnErr = sqlexec(gnConnection,lcSPString) && this works!!!
Again, thanks for the feedbacks. These feedbacks help us keep going, when the going gets tough.
Ramil 7/11
ramil
~~ learning to stand still