May 17, 2005 at 8:52 am
hi all,
I have a stored procedure that creates a record and generate a uniqueidentifier.
I call the procedure in Delphi, with ADOcommand.
Well, I just want the generated Uniqueidentifier to come back to me (in delphi).
How can I do?
May 17, 2005 at 9:01 am
create procedure dbo.yourprocname @param uniqueidentifier output
as
begin
...
select @param = columnname from table where x=z
end
and from Delphi use the Returned value of the output parameter
hth
* Noel
May 17, 2005 at 9:06 am
ok, thanks.
but when I call the procedure from delphi, I have to pass the parameter. It doesn't work with strings...
May 17, 2005 at 10:01 am
May be I don't know much about Delphi but I think you will need "TGUID" type for the value
* Noel
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply