Is someone using Innodb with delphi7?

I have try with "Mydac" and "MySqlDac" component to lock a record ...but no luck

I have uses a Query with a select .....
"select * from test where id=1 for update;"

thank

roberto