Hi,
my colleague is on holiday, but I found something interesting he wrote to
call stored procs with D5 and ODBC Express:
function TFaccueil.AppelprocStockee(pnomproc, param1 : string) : String;
begin
with OEDataSet1 do begin
Close;
StoredProc := pnomproc;
Params[0].AsString := param1;
ExecSQL;
Result := Params[0].AsString;
Close;
end;
end;
we assume that OEDataSet1 is of type TOEDataSet, and below you can find what
is in the dfm file:
object OEDataSet1: TOEDataSet
hDbc = Hdbc1
hStmt.CursorType = 0
hStmt.SkipByPosition = True
hStmt.SkipByCursor = True
hStmt.Target.Target = (
'OE6.01'
''
''
''
'')
StoredProc = 'BSC.ValideMPL_GETPREFS'
Params = <
item
DataType = ftString
Name = 'prefs'
ParamType = ptInputOutput
end>
Cached = True
Left = 528
Top = 104
end
Hope this will help, regards,
JM
"DGS/DST/DTAD" <[EMAIL PROTECTED]> a �crit dans le message de news:
[EMAIL PROTECTED]
> Hello.
>
> I am using OdbcExpress with Delphi 5
>
> Does anybody has a sample on how to call a cach� stored procedure that
> return something ???
> Like SayHello("Hello") and return "World"
> How to declare the cach� mehod and parameters (byref, output,...) and how
to
> call it ?
> The most difficult part seams to be on the Delphi/OdbcExpress side
> Each time a try a new solution, I receive a Kernel exception, nothing or
an
> internal error 460
>
> Thanks in advance
>
> Thierry
>
>
