#you can check more info in the help manual on Execsql

Local Char REQUEST(255)(2)
Local Char BASE(1)
BASE = '5' #for sql server
REQUEST(0) = "DECLARE @stofcydeb NVARCHAR(5)" #any parameters that you have
REQUEST(1) = "EXEC sp_Upd_ABC_CLASS @stofcydeb='”+ [M] VALEUR1(0) +”'"
Execsql From BASE Sql REQUEST

Infbox "DONE"
Endif
End

#you can check more info in the help manual on Execsql

Local Char REQUEST(255)(2)
Local Char BASE(1)
BASE = '5' #for sql server
REQUEST(0) = "DECLARE @stofcydeb NVARCHAR(5)" #any parameters that you have
REQUEST(1) = "EXEC sp_Upd_ABC_CLASS @stofcydeb='”+ [M] VALEUR1(0) +”'"
Execsql From BASE Sql REQUEST

Infbox "DONE"
Endif
End

I did look at the help file but the example wasn't clear on passing parms. I will give this a try. Thanks!

Try sql instead of execsql

For (Char ITMREF,Char ITMDSC,Char ITMDSC2) From "5" Sql REQUEST(0..1) As [YITMS]
   Infbox num$([YSITES]ITMREF)
   Break
Next

It works with regular sql query store procedure. I haven't made it work with dynamic sql.