Retrieving Output Value for a SQL Stored Procedure 1

[LeonelSanchezJr]

In my VFP 6 code, I am executing the following lines of code:

m.string = "EXEC proc_ins_CallNotes '" + alltrim(.edtnotes.value) + "',0"

lnresult = sqlexec(lhconnect, m.string)


This should basically create a record in my CALLNOTES table with a blank NOTES field and return the RECORD ID to the VFP calling program.

However, when I try to reference 0, I get 0. What am I doing wrong?

 

[jonscott8]

lcInVal=alltrim(.edtnotes.value)
lnRetVal=0

m.string = "EXEC proc_ins_CallNotes ?lcInVal,?@lnRetVal"

lnresult = sqlexec(lhconnect, m.string)

? lnRetVal Jon Hawkins