quote:

---

Originally posted by iswan


I want to execute procedure 2 with in the Procedure 1.

Procedure 1:
CREATE PROCEDURE scspInsTmplField AS

declare @RdCount int;
declare @LpCount int;
declare @FldNam varchar(100);
declare @FldType varchar(100);
declare @FldLen int;

set @LpCount=1;


select @RdCount=count( *) from scTabTmplField
scspCreateFormField;
--PRINT @RdCount;

while(@LpCount<=@RdCount)
begin

select @FldNam=FieldName,@FldType=FieldType,@FldLen=FieldLen from scTabTmplField where Id=@LpCount

print @FldNam+' '+@FldType
--exec scspCreateFormField(@FldNam,@FldType,@FldLen)
EXEC scspCreateFormField @FldNam, @FldType, @FldLen
set @LpCount=@LpCount+1;

end
GO
Procedure 2:
CREATE PROCEDURE scspCreateFormField @Dname varchar(50) , @Dtype varchar(50), @Length int, @Errorid int=null output as

...
Go

Regards
Iswan

---