Hi Glenn;

If your component is TIBOQuery and you use the RecordCount
repeatedly, tries to put the RecordCountAcurate property = False.
This does that each you see that counts makes a SQL to the server if
he is true. I had a similar case with a TIBOQuery component and a
TAction component.

Greetings
Fico

--- In IBObjects@yahoogroups.com, Glenn De Tollenaere
<glenn.detollenaere@...> wrote:

>
> Hi Jason,
>
> I use one IB_Connection, that is connected to a IB_Session-

component.

> All queries and datasets are set to this IB_Connection at creation

(in inherited FormCreate).

>
> My code is as follows:
>
> Try
> frm_basecomp.IBDB.BeginBusy(False);
> If Not LoadMyPreferences
> Then
> Begin
> frm_basecomp.IBDB.EndBusy;
> Exit;
> End;
> Finally
> frm_basecomp.IBDB.EndBusy;
> End;
>
> where IBDB is the IB_Connection (residing on a general form

frm_basecomp).

> I debugged the application, LoadMyPreferences happens inside

BeginBusy and EndBusy, still flickers however.

>
> I suspect setting the connection of queries and datasets at runtime

is ok ?

>
> regards
> Glenn
>
> ----- Original Message ----
> From: Jason Wharton <supportlist@...>
> To: IBObjects@yahoogroups.com
> Sent: Saturday, October 27, 2007 10:25:55 AM
> Subject: RE: [IBO] SQL-cursor (icon)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Glenn,
>
>
>
> > I tried this, but the cursor (icon) keeps flickering ?
>
> > I must say, the code is at this stage a mix of IBO and BDE
>
> > (the application is being transformed gradually), there are
>
> > several queries and datasets being opened at startup. Next to
>
> > that: some forms are created and also settings are being read
>
> > from within the database.
>
> >
>
> > Any ideas ?
>
>
>
> It can only be one of two things.
>
>
>
> 1) You somehow have multiple session objects in your application.
>
> 2) You are not getting the code inside the Begin/End Busy protected

block.

>
>
>
> Jason
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> <!--
>
> #ygrp-mkp{
> border:1px solid #d8d8d8;font-family:Arial;margin:14px

0px;padding:0px 14px;}

> #ygrp-mkp hr{
> border:1px solid #d8d8d8;}
> #ygrp-mkp #hd{
> color:#628c2a;font-size:85%;font-weight:bold;line-

height:122%;margin:10px 0px;}

> #ygrp-mkp #ads{
> margin-bottom:10px;}
> #ygrp-mkp .ad{
> padding:0 0;}
> #ygrp-mkp .ad a{
> color:#0000ff;text-decoration:none;}
> -->
>
>
>
> <!--
>
> #ygrp-sponsor #ygrp-lc{
> font-family:Arial;}
> #ygrp-sponsor #ygrp-lc #hd{
> margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
> #ygrp-sponsor #ygrp-lc .ad{
> margin-bottom:10px;padding:0 0;}
> -->
>
>
>
> <!--
>
> #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean,

sans-serif;}

> #ygrp-mlmsg table {font-size:inherit;font:100%;}
> #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica,

clean, sans-serif;}

> #ygrp-mlmsg pre, code {font:115% monospace;}
> #ygrp-mlmsg * {line-height:1.22em;}
> #ygrp-text{
> font-family:Georgia;
> }
> #ygrp-text p{
> margin:0 0 1em 0;}
> #ygrp-tpmsgs{
> font-family:Arial;
> clear:both;}
> #ygrp-vitnav{
> padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
> #ygrp-vitnav a{
> padding:0 1px;}
> #ygrp-actbar{
> clear:both;margin:25px 0;white-space:nowrap;color:#666;text-

align:right;}

> #ygrp-actbar .left{
> float:left;white-space:nowrap;}
> .bld{font-weight:bold;}
> #ygrp-grft{
> font-family:Verdana;font-size:77%;padding:15px 0;}
> #ygrp-ft{
> font-family:verdana;font-size:77%;border-top:1px solid #666;
> padding:5px 0;
> }
> #ygrp-mlmsg #logo{
> padding-bottom:10px;}
>
> #ygrp-vital{
> background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
> #ygrp-vital #vithd{
> font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-

transform:uppercase;}

> #ygrp-vital ul{
> padding:0;margin:2px 0;}
> #ygrp-vital ul li{
> list-style-type:none;clear:both;border:1px solid #e0ecee;
> }
> #ygrp-vital ul li .ct{
> font-weight:bold;color:#ff7900;float:right;width:2em;text-

align:right;padding-right:.5em;}

> #ygrp-vital ul li .cat{
> font-weight:bold;}
> #ygrp-vital a{
> text-decoration:none;}
>
> #ygrp-vital a:hover{
> text-decoration:underline;}
>
> #ygrp-sponsor #hd{
> color:#999;font-size:77%;}
> #ygrp-sponsor #ov{
> padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
> #ygrp-sponsor #ov ul{
> padding:0 0 0 8px;margin:0;}
> #ygrp-sponsor #ov li{
> list-style-type:square;padding:6px 0;font-size:77%;}
> #ygrp-sponsor #ov li a{
> text-decoration:none;font-size:130%;}
> #ygrp-sponsor #nc{
> background-color:#eee;margin-bottom:20px;padding:0 8px;}
> #ygrp-sponsor .ad{
> padding:8px 0;}
> #ygrp-sponsor .ad #hd1{
> font-family:Arial;font-weight:bold;color:#628c2a;font-

size:100%;line-height:122%;}

> #ygrp-sponsor .ad a{
> text-decoration:none;}
> #ygrp-sponsor ..ad a:hover{
> text-decoration:underline;}
> #ygrp-sponsor .ad p{
> margin:0;}
> o{font-size:0;}
> .MsoNormal{
> margin:0 0 0 0;}
> #ygrp-text tt{
> font-size:120%;}
> blockquote{margin:0 0 0 4px;}
> .replbq{margin:4;}
> -->
>
>
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> [Non-text portions of this message have been removed]
>