[GENERAL] ODBC Layer and the now() function

Has anyone seen any strange behaviour as regards the now() function when accessing a db via odbc layer. The behaviour I have seen (which I have mentioned in pervious post) is as follows: I have a trigger set up on a db - when a row is added to a certain table (say Table A) in my db the trigger

[GENERAL] Anomalies with the now() function

I have a trigger set up on a db - when a row is added to a certain table (say Table A) in my db the trigger calls a function and then the function enters another line in a related table (say Table B). Here's the problem, the first addition to Table A may show the time of the addition as, for exa