>>>>> "Steven" == Steven Schoch <schoch@stripped> writes:
Steven> Michael Widenius wrote:
>> Anyway, the real problem is that, even if one can with ODBC can use
>> sql servers with auto_increment_values, there isn't any established
>> protocol to find out the ID for the new row. (Wonder who designed
>> this protocol :).
>> Access uses the following query to find out the new inserted row:
>> SELECT .... FROM table WHERE auto_increment_column IS NULL
>> MySQL 3.23 tries to handle the above by converting the above query to:
>> SELECT .... FROM table WHERE auto_increment_column= LAST_INSERT_ID().
>> This solves some problems, but introduces another:
>> The problem is that, according to the logs, Access does the above
>> query 7 times for each inserted row ???
Steven> I'm using Access 2000 and have seen a different behavior. Here are some
> interesting lines
Steven> from myobdc.log:
I assume Access doesn't have any documentation of this behaveour ?
(I can't either understand from where Access gets those queries)
Anyway, any change you can test Access 2000 against MySQL 3.23.5 when
it comes out (it shouldn't take long for the build to Finnish..)
It would be nice to know if my last patches changes this.