Hi,
I was wondering if there are any know issues between VB6 apps, connecting to a Sybase 11 db using an rdoConnection. In short I have a flexigrid which is populated by a simple query which retrieves records from a sybase table. A sql query is built up and this is passed using an rdoConnection. I then open up a rdoResultset and loop through this, and for each record returned the flexigrid increments by one row. The problem is that sometimes, it doesn't display all the records that should be returned, even though when i do a count of the records returned it is correct. It can sometimes take 3 requeries of the database to retrieve/display the full set. There seems to be no general pattern as to why this occurs and I have tried various drivers from old Sybase 11 drivers to new Merant 3.5 but no go.
any help would be appreciated.
I was wondering if there are any know issues between VB6 apps, connecting to a Sybase 11 db using an rdoConnection. In short I have a flexigrid which is populated by a simple query which retrieves records from a sybase table. A sql query is built up and this is passed using an rdoConnection. I then open up a rdoResultset and loop through this, and for each record returned the flexigrid increments by one row. The problem is that sometimes, it doesn't display all the records that should be returned, even though when i do a count of the records returned it is correct. It can sometimes take 3 requeries of the database to retrieve/display the full set. There seems to be no general pattern as to why this occurs and I have tried various drivers from old Sybase 11 drivers to new Merant 3.5 but no go.
any help would be appreciated.
