hi

i'm using subsonic 2.1

 config:

<SubSonicService defaultProvider="DBPxxx">
    <providers>
      <clear/>
      <add name="DBPxxx" type="SubSonic.MySqlDataProvider, SubSonic" connectionStringName="xxx" generatedNamespace="Dal" setPropertyDefaultsFromDatabase="true" useExtendedProperties="true"/>
    </providers>

  </SubSonicService>

  <connectionStrings>
    <add name="xxx" connectionString="Server='xxx.net';Database='xxx'; Uid='xxx'; Pwd='xxx'"  providerName="MySqlClient"/>
  </connectionStrings>

<section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" requirePermission="false" allowDefinition ="MachineToApplication"  restartOnExternalChanges ="true"/> 

code generation working smooth, insert and delete record works fine.

when trying to update existing record - recieving an error:

MySqlException

Number: 1064

Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `ID` = 5; SELECT 5 AS id' at line 1 

Server: MySQL 5.0.37

Table schema:

ID, Integer, auto inc

CatName, VARCHAR(50), not null

Description, VARCHAR(400) 

My machine running Vista Ultimate 64bit

Could Vista be the problem?

any other ideas? can i somehow change the update query before its execution? 

I couldnt find a way to get the syntax of the executed update query, is it possible?

I've tried to work with different table - same results. 

Any help will be highly appreciated