On Mon, 24 Jan 2011 22:20:38 +0100 (CET), Michael Van Canneyt <[email protected]> wrote:
> >In general RecordCount cannot be trusted; >It can be updated as the TDataset fetches records. > >In each case: SQLDB relies on ODBC to connect to MS-SQL. > >>From testing with MS-Access and MySQL I know that ODBC works fine with other >databases, at least for SELECT Statements. > >1. Can you test a regular SELECT statement on the same SQL database ? > If that doesn't work either, we know the problem is in the ODBC connection > component. See previous reply, I sent it off too soon.... >2. Can you test the same EXEC statement in a Delphi app through ODBC ? > If this gives problems, it means the ODBC driver is well - weird. > (although this would surprise me) I will have to check how to use ODBC in Delphi7 first. I only ever used ADO in Delphi for database work. >3. If both previous attempts work, there is nothing left but to debug the ODBC >connection component. > That means stepping through your code with the debugger. > >Michael. This last point I tried to do but when I did "step into" after stopping at a breakpoint at the query.Open line the complete Open method executed and I got to the next line in the main procedure.... -- Bo Berglund Developer in Sweden -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
