请教关于VFP执行SQL SERVER有参数的存储过程
SQLSERVER的存储过程语句如下:程序代码:
CREATE PROCEDURE sb_query @c_sb_bm NVARCHAR(30), @c_lb1 NVARCHAR(30) AS BEGIN SELECT * FROM shebei WHERE sb_bm=@c_sb_bm and zl_id in (select id from shebei_zl where lb1=@c_lb1) END
vfp执行过程语句如下:
cs_sb_bm="zhijiang" cs_lb1="mijiu" str_shebei=SQLEXEC(con,"EXEC sb_query @c_sb_bm=?cs_sb_bm,@c_lb1=?cs_lb1","shebei")
SQLSERVER的存储过程没有问题,但是VFP执行有问题,不能通过,但是我也不知道怎么写,恳请师傅们帮忙指正下