CODEWITHSUNDEEP
postgresqlodbc
berkeleybross
berkeleybross

Reputation: 1386

Warning message on Insert or update

I keep getting a message whenever I insert or update any record in any table in my database:

[34931.406] SQL_Statement           1  4  -1 999999999 01S02 -5      -- cursor updatability changed

I was wondering exactly what this message means and why I am getting it. Is it safe to ignore? Am I supposed to react to it / do something different?

Thanks for reading

Just in case its necessary - I'm running PostgreSQL 9.1.2 on Ubuntu LTE I'm using 32bit ODBC psqlodbc_09_01_0100 on Windows 7 x64

I'm also using a third party odbc library "SQLTools" by PerfectSync - but I don't think thats making the message because I also use it with MySQL with no problems

Upvotes: 1

Views: 674

Answers (1)

Nicola
Nicola

Reputation: 21

Are u updating cursor's elements directly?

in this case warning message is informing u that u are changin' cursor's elements while it's open.

Something similar happens, in java language when tryng to change list's elements number (adding or removing elements) while iterating it.

Upvotes: 1

Related Questions