Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!


>When I tried using the parameter.refresh as you had suggested so that I
>didn't have to createparameters, just assign values.. all seemed well until
>I call 'open' and I got an exception on sqloledb.dll... any suggestions
>there?

It works for me.

Try it like this. This example uses the Northwind sample database with SQL
server
with ADODataSet1 do begin
close;
CommandText := 'Sales by Year';
Parameters.refresh;
Parameters.ParamByName('@Beginning_Date').Value := strToDateTime('01/01/1996');
Parameters.ParamByName('@ending_date').Value := strToDateTime('01/01/2004');
open;
end;
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages