Board index » off-topic » TSQLDataSet + TDataSetProvider + TClientDataSet
Jonnes
Delphi Developer |
TSQLDataSet + TDataSetProvider + TClientDataSet2005-09-17 04:06:20 AM off-topic3 My database: firebird 1.5.2 I have this select at the SQLDataSet: SELECT SP.NUM_SEQ FROM GET_NEXT_SEQ(1, 'NUM_NF') SP This select executes the stored procedure GET_NEXT_SEQ. In the stored procedure code I have a "FOR SELECT...", and in the for I raise a exception (in the stored procedure). DataSetProvider1.DataSet := SQLDataSet1; ClientDataSet1.ProviderName := 'DataSetProvider1'; ClientDataSet1.Open; ->this MUST raise the internal stored procedure excetion. Well, the exception that my application show me is "Error in request synchronization" and not the internal stored procedure exception. It will works correctly, if I use the code as: SQLDataSet1.Open; ->this RAISE the correct exception. My question: Who can I get the raised exception on a SQLDataSet, opening it by "ClientDataSet.Open"? Tks..... PS.: sorry my english is not so good, I'm brazilian :) |