is AppendChunk interactive or accumulative?

Hello All, Need to know if a RecordSet AppendChunk is interactive or does it accumulate the field's data until an Update is called? I'm finding that the Update fails if the total RecordSet size is greater than Max_Allowed_Packet. If the later is true .. I guess I'll need work around suggestions,

Retrieving Table Schema

Hello All, Suggestions Feedback Requested: I'm looking for a solution that will not lock a table, yet allow me to retrieve the: field name, field type as integer, field size, and other attributes of each column from a table. The Issue: When requesting the Table Schema from mySQ

Passing Connection Objects between DLLS

Hello All, When passing a connection object between DLL's it appears that myODBC driver is not able to create Editable RecordSets objects from it. However, I can create Static RecordSet objects. A work around that I have found is to have the 2nd DLL open a new connection object. Code samples f

SELECT COUNT

Hello All, I seem to be running into a very strange problem. In the mySQL command line interface I issue SELECT COUNT (*) FROM test; and get --> ERROR 1064: You have an error in your SQL syntax near '(*) from test' at line 1. Below is the test table: CREATE TABLE test ( ID INTEGER AUTO_INCR