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


I seem to have sorted it out. Not sure how, but the addition of key
links seems to have helped. keeping my fingers crossed.