problem using tsqlstoredproc

[csbrmg]

I have a problem executing a stored procedure when using tsqlstoredproc when using the code


tem.StoredProcName :='insertnew';

with tem.Params do
begin
CreateParam(ftInteger, '@Tempid', ptInput);
ParamByName('@Tempid').AsInteger := TID;
CreateParam(ftdatetime, '@dtcreated', ptInput);
ParamByName('@dtcreated').AsDate:= Date;
CreateParam(ftinteger, '@sess', ptInput);
ParamByName('@sess').Asinteger:= sesid;

end;


tem.Open;

i get the error list index out of bounds

 

[LucieLastic]

hi

I think you need a Prepare and ExecProc rather than an Open:
eg

spEmptyDB.Params[1].asstring := TableName;
spEmptyDB.Prepare;
spEmptyDB.ExecProc;

What does your storedproc sql look like?

lou