Subject | Re: [IBO] TIBOQUERY Single Row Refresh |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2001-08-08T23:52:36Z |
Hello Jason,
After resolving the TBookMark and TBookMarkStr puzzle, it worked,
however InvalidateBookmark() is only slightly faster than a plain
Refresh on a 200,000 element table with a single key. I kind of
expected to see a single select pop up on TIB_Monitor for the
Invalidated row :)
Tried options on TIBOQuery and TIBODataBase to force trimming of
ftString fields since it defaults to no trimming. I couldn't get
a clear picture from the docs what the dedault should be. However
slapping in a Fields[f].OnSetText on the string fields during
form creation of the TDM was a quick simple solution.
Still haven't resolved how to stop TIBOQuery from updating an entire
row when just a single field in the row was updated. TIB_Query
does this just wonderful correct.
Thank You,
Hans
=================================================================
Jason Wharton wrote:
After resolving the TBookMark and TBookMarkStr puzzle, it worked,
however InvalidateBookmark() is only slightly faster than a plain
Refresh on a 200,000 element table with a single key. I kind of
expected to see a single select pop up on TIB_Monitor for the
Invalidated row :)
Tried options on TIBOQuery and TIBODataBase to force trimming of
ftString fields since it defaults to no trimming. I couldn't get
a clear picture from the docs what the dedault should be. However
slapping in a Fields[f].OnSetText on the string fields during
form creation of the TDM was a quick simple solution.
Still haven't resolved how to stop TIBOQuery from updating an entire
row when just a single field in the row was updated. TIB_Query
does this just wonderful correct.
Thank You,
Hans
=================================================================
Jason Wharton wrote:
>
> I believe I surfaced the InvalidateBookmark() routine.
> Give it a look.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> ----- Original Message -----
> From: <hans@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Friday, August 03, 2001 12:42 PM
> Subject: [IBO] TIBOQUERY Single Row Refresh
>
> > To test IBO4, I'm converting over a rather complicated 4 year old
> > program written to use Pervasive SQL. In order not to rewrite
> > the entire program, I choose to stay with the native Delphi
> > controls and the TIBO... suit.
> >
> > Seen an answer to just a single grid row refresh to TIB_Query along
> > the lines of TIB_Query.InvalidateRow(...). Is there an equivalent
> > method for TIBOQuery ?
> >
> > Best Regards
> > Hans
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/