Hi,

i'm experiencing some strange behavior with updateing data using myDac and Delphi7. I'm using MyCommand with a simple SQL statement like
update table set phone = NNNNN where id = IIIIII
and most of the time it works fine, but then suddenly updates phone with a "near miss", like NNNNN+2 for example. Is there a way to find out what exatcly (sql statement) went to the server (something like Profiler for MS SQL) other than setting trace on startup (which according to the manual is meant mainly for debugging server crashes)? I have no triggers set on the table nor on the phone column. Any help would be much appreciated.

Andrej

Problem was caused by updateing float field with integer value (), i'll just have to convert it into integer, but the question about "profiler like" tool is still open.

mytop is a linux tool that shows you what your MySQL server is currently doing. Not exactly profiler-like (and I'm not 100% sure you can log its output), but better than nothing.