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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement