var pStoredProc : TStoredProc; begin try pStoredProc := TStoredProc.Create( Application ); pStoredProc.DatabaseName := orcl.DataBaseName; { -- call stored procedure } pStoredProc.StoredProcName := AnsiUpperCase( 'factory.an_p1.Sql_Standard_DeleteDay' ); pStoredProc.Prepare; pStoredProc.Params.ParamByName( 'pPeriod' ).AsString := _sPeriod; pStoredProc.ExecProc; finally pStoredProc.Free; end;
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Thursday, March 8, 2018
DELPHI - How to call (old) BDE stored procedure
Note: orcl is TDatabase with connection.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment