Running SQL command in a Routine
Posted: Mon Dec 13, 2004 5:54 am
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.
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.