>Is it possible to do the 3 following lines in only one sqlexec()?
>If so, how to do that? Thank you!
>
>declare @FichsousId as varchar(40)
>set @FichsousId= (select id from fichsous where numcon = 11113)
>exec sp_deletesoumission @FichsousId, @UserName = 'mlevesque'
Yes:
TEXT TO lcSQL NOSHOW
declare @FichsousId as varchar(40)
select @FichsousId = id from fichsous where numcon = 11113
exec sp_deletesoumission @FichsousId, @UserName = 'mlevesque'
ENDTEXT
IF SQLEXEC(lnSQLH, lcSQL) < 0
AERROR(laError)
MessageBox(laError[1,2])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.