>There is a call to SQL stored procedure from VFP:
>

>lcDrv_CD = "1001"
>loRS = oData.oConn.Execute("usp_dsp_TooLate2AddInvoice '" + lcDrv_CD + "'")
>?loRS.Fields(0).Value
>

>
>Is there a way to pass variable directly? Something like:
>

>loRS = oData.oConn.Execute("usp_dsp_TooLate2AddInvoice ?lcDrv_CD")
>

>or similar?
>
>I've tried several ways but could not find correct one.
>
>Thanks.

Check Re: VFP/ADO/SQL stored procedure syntax Thread #1056781 Message #1057068

inParm.Value = "France"
rs1 = cmd.Execute

inParm.Value = "USA"
rs2 = cmd.Execute

Cetin