Subject Re: TIBOQuery: Wierd stuff happening with simple queries
Author mitch_landor
--- In, "mitch_landor" <mlq97@...> wrote:
> 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?

OK, so I have done a clean install of Delphi and all components &
tools just to eliminate this as a factor.

Now when I edit in the TIBOquery grid, I am able to do so. But when I
move off a row the data still reverts to the previous content until I
refresh, and then the new content is shown. This seems to be different
behaviour than before, and very confusing. Is there a switch to adjust
this behaviour?