Subject | TIBOQuery: Wierd stuff happening with simple queries |
---|---|
Author | mitch_landor |
Post date | 2006-12-11T04:31:21Z |
IBO 4.6.b
I'm getting the feeling that something bad is happening here.
I was getting odd behaviour in update queries so I checked everything
in my db structure and took the opportunity to rename some of the fk
columns in some of my tables and drop/rebuild the fk constraints as
necessary.
Most of my tables seem to be working ok, except for 1 or 2 critical
ones, but things seem to be running slow and now I cant even get a
simple joined query on the critical ones to be updateable. In
TIBOQuery the results show OK, but I have to work hard to get the cell
to accept focus for edit mode, then when I try to save it flips back
to pre-edit content.
I just created a new simple single table query with 3 columns and the
results show up OK but I have an extra (un-called for) column on the
right called DB Key. What is going on? Is this an IDE problem or a DB
problem?
(I have been getting some Delphi ide error messages lately)
FB2 passes a validation check.
Perhaps I should uninstall/reinstall delphi and restore from a backup?
I'm getting the feeling that something bad is happening here.
I was getting odd behaviour in update queries so I checked everything
in my db structure and took the opportunity to rename some of the fk
columns in some of my tables and drop/rebuild the fk constraints as
necessary.
Most of my tables seem to be working ok, except for 1 or 2 critical
ones, but things seem to be running slow and now I cant even get a
simple joined query on the critical ones to be updateable. In
TIBOQuery the results show OK, but I have to work hard to get the cell
to accept focus for edit mode, then when I try to save it flips back
to pre-edit content.
I just created a new simple single table query with 3 columns and the
results show up OK but I have an extra (un-called for) column on the
right called DB Key. What is going on? Is this an IDE problem or a DB
problem?
(I have been getting some Delphi ide error messages lately)
FB2 passes a validation check.
Perhaps I should uninstall/reinstall delphi and restore from a backup?