Hi Jean Marc Thanks for the code. Any chance to have the cach� code corresponding to that code ? GETPREFS in BSC.ValideMPL ?
One more thanks Mer�i de l'info ;-) Thierry "BOUZARD Jean-Marc" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 > > > > > >
