I have a stored procedure in interbase that returns a value, thus: CREATE PROCEDURE GET_GENERATOR( GEN VARCHAR(10), INCREMENT INTEGER ) RETURNS ( VAL INTEGER ) AS BEGIN Val = -1; If (:Gen = 'TODO') then Val = GEN_ID(GEN_ID_TODO, :Increment); END Using a TStoredProcedure I could simply access the return value as a parameter. If I use an TADOStoredProcedure component to access this it can detect the input parameters but not the return value. Ideas anyone? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
