ADOCommand - How to get a return value?

[Marco Napoli]

I have Delphi 6.0 and I am suing the ADOCommand, which runs bunch of SQL
Statement to a MS SQL Server. At the end of the code I have a statement of
RETURN nMyNewId.

I cant figure out how to get this nMyNewId back from the ADOCommand once
executed.

// Bund of SQL Statements....
// ....
nMyNewId:= cmdDuplicate.Execute;

The above does not compile....
Thank you.

Marco

[Brian Bushay TeamB]

> cant figure out how to get this nMyNewId back from the ADOCommand once
>executed.
>
>// Bund of SQL Statements....
>// ....
>nMyNewId:= cmdDuplicate.Execute;

cmdDuplicate.Execute;
nMyNewId := cmdDuplicate.paramaters.parambyName('@RETURN_VALUE').value;

--
Brian Bushay (TeamB)
Bbu...@NMPLS.com

[Jari Kettunen]

"Marco Napoli" <ma...@avantitec.com> wrote in message
news:3f12f434$1...@newsgroups.borland.com...

nMyNewId:= cmdDuplicate.Execute is dropped on D7 and C6 but following code
seems to work.

procedure TForm1.Button1Click(Sender: TObject);
begin
ADOCommand1.CommandText:='Select max(id) from abc';
edit1.Text:=IntToStr(ADOCommand1.Execute.Fields[0].Value);
end;

[Marco Napoli]

Thank you.

Marco

[guihgo1...@gmail.com]

Hi ! For XE3 i have to use it:
---------
[CODE]
Edit1->Text = ADOCmd_fabri->Execute()->Fields->Item[0]->Value;
[/CODE]
---------
i use> Execute()->Fields->Item[0]->Value;
not> Execute()->Fields[0]->Value;
---------
For Delphianers: put . stead ->
---------

it's working for me...