I have written a code as follows in a routine
CMD= "SELECT * FROM abcd"
Call DSExecute("UV", CMD, result, sysreturncode)
Ans= result
When i tested the routine i am getting answer as 'SQL'. Why is it. What should i do if i need to get the output of SQL as the output of routine.
When i run the SQL COMMAND in Admiistrator, first it showed SQL, THEN after clicking Respond, it showed the correct answer.
What is wrong in my routine code.How should i alter it to get correct answer.
Running SQL command in a Routine
Moderators: chulett, rschirm, roy
Running SQL command in a Routine
Aim high
Re: Running SQL command in a Routine
Your answer is not 'SQL', it has put up an additional SQL prompt because your statement is incomplete.nkln@you wrote:When i tested the routine i am getting answer as 'SQL'. Why is it.
Try adding a semi-colon to the end of your statement:
Code: Select all
CMD= "SELECT * FROM abcd;"
Can you explain what exactly it is you are trying to accomplish with this routine? Then people here can give you some guidance on the best way to accomplish that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers