Вот еще вопросы ... прилада с MAV подвисает.
Виснет в разных местах по непонятной мне причине.
Транзакциями и другими блокироваками не пользуюсь.
Вот пара примеров лога:
Код: Выделить всё
7027872 Maximum read 1 rows for cursor
Binding field 1 "ProgramID" = 26
Binding field 2 "ObjectName" = Main
7019432 Parsing Cursor : SELECT "ProgramID","ObjectName","ObjectDesc","ObjectType","ObjectSystem","ObjectDisable","ID" FROM xa_objects WHERE "ProgramID"=? AND "ObjectName"=?
7019432 Parsing Cursor : SELECT "ProgramID","ObjectName","ObjectDesc","ObjectType","ObjectSystem","ObjectDisable","ID" FROM xa_objects WHERE "ProgramID"=? AND "ObjectName"=?
7019432 Close cursor
7019432 Close cursorBinding field 1 "ProgramID" = 26
Binding field 2 "UserLogin" = Admin
Binding field 3 "UserLogin" = Admin
7019432 Free cursor
7019432 Open cursor
7019432 Open cursor
ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ObjectType'. [42S22]
7019432 Maximum read 1 rows for cursor
7019432 Maximum read 1 rows for cursor
7027872 Close cursor
и этот
Код: Выделить всё
Binding field 1 "ProgramID" = 26
Binding field 2 "ObjectName" = Update_xa_test
7019432 Parsing Cursor : SELECT "ProgramID","ObjectName","ObjectDesc","ObjectType","ObjectSystem","ObjectDisable","ID" FROM xa_objects WHERE "ProgramID"=? AND "ObjectName"=?
7019432 Close cursor
7019432 Free cursor
7019432 Open cursor
7019432 Maximum read 1 rows for cursor
Binding field 1 "ProgramID" = 26
Binding field 2 "UserLogin" = Admin
7019432 Parsing Cursor : SELECT "ProgramID","UserStatus","FullAccess","UserDisable","UserName","UserLogin","UserPassword","UserCanChangePassword","UserCanBackup","UserOnline","UserMustShutdown","UserMustShutdownTime","UserPhone","UserComment","LoginDateTime","LogoutDateTime","OnlineDateTime","ID" FROM xa_users WHERE "ProgramID"=? AND "UserLogin"=?
7019432 Close cursor
7019432 Free cursor
7019432 Open cursor
Time Taken: 0.04 sec.
7019432 Read all rows for cursor
7019432 Read all rows for cursor
7027872 Open cursor
Почему в первой позиции отличаются коды ?
Рай совершает ошибки ничуть не реже чем ад. Просто у него хорошая пресса