RocksLondon
Programmer
Help...
Hi there, just joined the forum so if I should be posting this in another area then please excuse me and do let me know where....
I have an issue concerning the ASE ODBC DriversV4.1 on a Sybase 11.9.2 / 12 dB.
When using the drivers through a connection object created in VB I am unable to obtain the RowsAffected on any tables that have Insert/Update triggers working on. I have tried setting the NOCUNT property but have realised that the Update/insert succeeds but the trigger itself does not seem to have fired for those update/inserts.
Has anybody come across this or know where I can look to resolve this... If anyone would like to look at the trigger then 'm happy to forward it on.
Any help/Advice would be very appreciated.
Kind regards,
Hi there, just joined the forum so if I should be posting this in another area then please excuse me and do let me know where....
I have an issue concerning the ASE ODBC DriversV4.1 on a Sybase 11.9.2 / 12 dB.
When using the drivers through a connection object created in VB I am unable to obtain the RowsAffected on any tables that have Insert/Update triggers working on. I have tried setting the NOCUNT property but have realised that the Update/insert succeeds but the trigger itself does not seem to have fired for those update/inserts.
Has anybody come across this or know where I can look to resolve this... If anyone would like to look at the trigger then 'm happy to forward it on.
Any help/Advice would be very appreciated.
Kind regards,