Hi there , i suppose it was a simple sintax error as i wrote Datasource instead Data Source, or at least i think it was it seen that now it works.
Now I have another problem, i can execute my stored procedure which writes on a table but..how can I retrieve the value it should give me back ?
I use this ASP instructions to execute the routine :
conn.ConnectionString="Provider=VFPOLEDB.1 ; Data Source=C:\vfp\test\MyDataname.dbc"
conn.Open
sql = "mystoredproc('param')"
set retid =conn.Execute(sql)
but i don't know how to get the value back from the routine i called.
I tried with
Response.write (retid)
but it gives me an error
Any suggestion ?
Thank u again
Alessio
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only