Just Upgraded - Problems...
in [DB2]
|
Prev: how to set idle time out
Next: db2updv8 problem
From: Ian Mackenzie on 29 Sep 2006 04:10 Hey Guys I have just upgraded from V8,2 to 9.1 Express C and have hit a couple of problems. Here we go: I have created an app in delphi, which connects with the following connection string: Provider=IBMDADB2.1;Password=****;Persist Security Info=True;User ID=USERNAME;Data Source=SMARTMUN;Location=SERVER;Mode=ReadWrite Connection works fine... I have an ADO dataset on one of my forms, but when I try increment an integer value, I get the error: "Insufficient base table information for updating or refreshing" My table has about 100 records, 2 columns(VarChar[Primary Key] and integer). SQL statement: select * from generator where listfield = 'Test' In delphi: dataset.edit; dataset.fieldbyname('integervalue').asInteger := dataset.fieldbyname('integervalue').asInteger + 1; dataset.post; **ERROR HERE*** - "Insufficient base table information for updating or refreshing" dataset has cursorLocation, client, CursorType = ctStatic Does anybody have any idea how to help. The weird thing is, it worked fine before we updated to V9,1????????? Thank You Ian Mackenzie
From: Ian Mackenzie on 29 Sep 2006 07:16 Update: I can run update and insert statements from SQL. If I leave a ; off the end of the SQL statement I get a "CLI0115E: Invalid cursor state error". If I put it on the end, I get "Insufficient base table information" which fires on the post command of my dataset... I can run these in V8.2 but not V9.1... Could it be an ADO problem or what. I am dumbstruck!!!! Thanks Ian Mackenzie wrote: > Hey Guys > > I have just upgraded from V8,2 to 9.1 Express C and have hit a couple > of problems. > > Here we go: > > I have created an app in delphi, which connects with the following > connection string: > Provider=IBMDADB2.1;Password=****;Persist Security Info=True;User > ID=USERNAME;Data Source=SMARTMUN;Location=SERVER;Mode=ReadWrite > > Connection works fine... > > I have an ADO dataset on one of my forms, but when I try increment an > integer value, I get the error: "Insufficient base table information > for updating or refreshing" > > My table has about 100 records, 2 columns(VarChar[Primary Key] and > integer). > > SQL statement: select * from generator where listfield = 'Test' > > In delphi: > dataset.edit; > dataset.fieldbyname('integervalue').asInteger := > dataset.fieldbyname('integervalue').asInteger + 1; > dataset.post; **ERROR HERE*** - "Insufficient base table information > for updating or refreshing" > > dataset has cursorLocation, client, CursorType = ctStatic > > Does anybody have any idea how to help. The weird thing is, it worked > fine before we updated to V9,1????????? > > Thank You > > Ian Mackenzie
From: Knut Stolze on 29 Sep 2006 10:10 Ian Mackenzie wrote: > Update: > I can run update and insert statements from SQL. > If I leave a ; off the end of the SQL statement I get a "CLI0115E: > Invalid cursor state error". Have you turned auto-commit off? Because if you don't your cursor may be closed after the OPEN statement. -- Knut Stolze DB2 Information Integration Development IBM Germany
From: Ian Mackenzie on 30 Sep 2006 11:28 Thanks for the reply... How would I do that, turn off auto-commit?? Thanks Ian Knut Stolze wrote: > Ian Mackenzie wrote: > > > Update: > > I can run update and insert statements from SQL. > > If I leave a ; off the end of the SQL statement I get a "CLI0115E: > > Invalid cursor state error". > > Have you turned auto-commit off? Because if you don't your cursor may be > closed after the OPEN statement. > > -- > Knut Stolze > DB2 Information Integration Development > IBM Germany
From: Knut Stolze on 2 Oct 2006 02:31
Ian Mackenzie wrote: > How would I do that, turn off auto-commit?? How do you communicate with DB2? JDBC, SQLJ, CLI, embedded SQL, or something else? -- Knut Stolze DB2 Information Integration Development IBM Germany |