Bug #16726 Not All Record retreive

• Submitted: 23 Jan 2006 14:47
• Modified: 5 May 2006 9:03
• Reporter: Crasan Iulian Codrut
• Status: No Feedback
• Category: Connector / NET
• Severity: S1 (Critical)
• Version: 1.0.7
• OS: Windows (Windows XP)
• CPU Architecture: Any

[23 Jan 2006 14:47] Crasan Iulian Codrut

Description:
I have this Procedure :
    Public Sub IncarcareDateComboGrid(ByRef tmp_Tabela As Long)
        Dim tmp_datatable_combo As DataTable
        Dim tmp_dataadaptor_combo As MySqlDataAdapter
        Dim tmp_commandbuilder_combo As MySqlCommandBuilder
        Dim x As Long

        Try
            If Global_Connection_Gestiune.State = ConnectionState.Closed Then Global_Connection_Gestiune.Open()
            tmp_datatable_combo = New DataTable
            tmp_dataadaptor_combo = New MySqlDataAdapter(ParametriiComboGrid(tmp_Tabela).SQL, Global_Connection_Gestiune)
            tmp_commandbuilder_combo = New MySqlCommandBuilder(tmp_dataadaptor_combo)
            tmp_dataadaptor_combo.AcceptChangesDuringFill = True
            x = tmp_dataadaptor_combo.Fill(tmp_datatable_combo)
         Catch ex As OleDb.OleDbException
            MsgBox(ex.Message)
        End Try
    End Sub

Who have to retreive ID and Name from clients table. But not all the dates are retreive. Some missing. I check the tables and it is ok. I run the same SQL in  MySQL Manager and works fine. If I use My ODBC connector works fine.

How to repeat:
Try to have a table with more than 2000 records and fill a datatable.

[23 Jan 2006 14:54] Crasan Iulian Codrut

The Clients Table

Attachment: Clients Tables.ace (application/octet-stream, text), 64.52 KiB.

[17 Mar 2006 2:01] Tony Scharf

I have experienced the same thing.  Its a very critical issue.  If there is a work around, I would very much like to know.

[5 Apr 2006 9:03] Tonci Grgin

Hi. Thanks for your problem report. Can you please provide me with test case project and more info on server version, NETframework version, compiler version...

[5 May 2006 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".