I want to know if I can insert or append the record with a return dataset's stored procedure? any ideas? For example,CREATE PROCEDURE [spHD_CostIts] @JobUID Uniqueidentifier ASSelect ID, JobUID, UID,ParentUID, Wbscode from J1_HD_CostItems where JobUID = @JobUID GOIf I can call it in Delphi and new insert records
Create Procedure GetName ( @Num int, @Tmp varchar(50) output ) As Begin declare @GetNum Int Select @GetNum=@Num+1 Select @Tmp=Convert(varchar(50),@GetNum) Endprocedure TForm1.Button1Click(Sender: TObject); Var Tmp:string; Num:Integer; sqlstr:string; begin Num:=10; sqlstr:=' Declare @Tmp Varchar(50)'+ ' Declare @Num Int'+ ' Select @Num='''+IntToStr(Num)+''''+ ' exec GetName @Num,@Tmp output'+ ' Select @Tmp'; With ADOQuery1 do begin Close; Sql.Clear; sql.Add(sqlstr); open; end; Edit1.Text:=ADOQuery1.Fields.Fields[0].AsString; end;
@JobUID Uniqueidentifier
ASSelect ID, JobUID, UID,ParentUID, Wbscode from J1_HD_CostItems
where JobUID = @JobUID
GOIf I can call it in Delphi and new insert records
(
@Num int,
@Tmp varchar(50) output
)
As
Begin
declare @GetNum Int
Select @GetNum=@Num+1
Select @Tmp=Convert(varchar(50),@GetNum)
Endprocedure TForm1.Button1Click(Sender: TObject);
Var
Tmp:string;
Num:Integer;
sqlstr:string;
begin
Num:=10;
sqlstr:=' Declare @Tmp Varchar(50)'+
' Declare @Num Int'+
' Select @Num='''+IntToStr(Num)+''''+
' exec GetName @Num,@Tmp output'+
' Select @Tmp';
With ADOQuery1 do
begin
Close;
Sql.Clear;
sql.Add(sqlstr);
open;
end;
Edit1.Text:=ADOQuery1.Fields.Fields[0].AsString;
end;