Board index » delphi » ADO & MSSQL Stored proc problem
Tolik Tentser
Delphi Developer |
Fri, 05 Apr 2002 03:00:00 GMT
ADO & MSSQL Stored proc problem
Hi !
At first time sorry for my English - this is not my native language as I have a problem with TADOStoredProc & MSSQL7 with OLE DB Provider for MS If I use optimiser hints in stored procedure then MSSQL generate a message In TCustomADODataSet.OpenCursor I see: === cut === Recordset.Open(Source, ActiveConnection, === cut === and generated by server message bring ADO to DatabaseError :-) at second attempt procedure is prepared and cursor opened. IMHO this is not good behavior. May be better implementation of OpenCursor === cut === var [skip] Recordset.Open(Source, ActiveConnection, === cut === This implementation also solves same problem with PRINT and RAISERROR with BTW - is anyone know how to extract message text from recordser with State = -- |