Update Command of Command Builder

Question

hi,
i'm getting the following when working with update command of command builder
dynamic sql generation for update command is not supported against a select command that doesnt return any key colimn information
my database is mysql and my table has 2 primary keys
Please help me to solve this