ADO cursor probs

[martinm]

Hi, I'm modding a D7/SQL Server 2005 Express app. which uses ADOQueries.

When I try and post an edited record I get exception

'A cursor with the name 'MY Cursor' already exists'.

I've tried changing the 'recordset approach' to a straight SQL 'Update' statement, but get the same.

I've even closed and reopened the shared connection just before to ensure nothing else is open!!

Could this be another error with the wrong exception?

Ta,

Martin.

 

[martinm]

Solved it - for some reason the 2 triggers I had seemed to be called mutliple times. Put it all into 1 trigger now...