Board index » delphi » IBX query components at design time

Dan Palley

Delphi Developer
Tue, 18 Nov 2003 01:31:19 GMT

IBX query components at design time

Jeff:

I've noticed in the IBX 4.52 update that if I make changes to a query
component (IBSQL, IBDataset), such as changing the SQL text, that the screen
freezes for 5-10 seconds after I click either OK or Cancel.  This only
happens when I don't have my IBDatabase active, which I usually don't at
design time.

I'm in the process of moving all of my existing BDE and FIB components over
to IBX and this issue is making it a very tedious process.  Is this
something you can look into for the next IBX update?  Is it something I can
change in the source myself easily enough?

Thanks,

Dan Palley
TRAMS, Inc.

 
Sergio Samayo

Delphi Developer
Tue, 18 Nov 2003 01:46:51 GMT

Re:IBX query components at design time


Since you aren't connect to database, each time the SelectSQL editor starts
must connect to database and fetch table names from it. You can avoid such
efect making your database connected at design time but set
AllowStreamConnected to false. Then, when the database component is loaded
from stream it doesn't connect until you do it explicit by code.

--
Sergio Samayoa
Lgica Software
http://www.geocities.com/logicasw/

Dan Palle

Delphi Developer
Tue, 18 Nov 2003 02:24:31 GMT

Re:IBX query components at design time


I'm getting the delay -after- I close the SelectSQL editor, not when it
opens.  I'm just typing text directly into the SQL box and am nowt browsing
tables or fields.  Also, the TIBSQL component does not use the SelectSQL
editor and I still get the delay.

Dan

Quote
"Sergio Samayoa" <serg...@terra.com.gt> wrote in message

news:3b1682a2_2@dnews...
Quote
> Since you aren't connect to database, each time the SelectSQL editor
starts
> must connect to database and fetch table names from it. You can avoid such
> efect making your database connected at design time but set
> AllowStreamConnected to false. Then, when the database component is loaded
> from stream it doesn't connect until you do it explicit by code.

> --
> Sergio Samayoa
> Lgica Software
> http://www.geocities.com/logicasw/

Team

Delphi Developer
Tue, 18 Nov 2003 02:32:52 GMT

Re:IBX query components at design time


I don't see this either with remote or local connections on the current version
I'm working on.  I can't think of anything that would have changed to do this
either though.

Quote
Dan Palley wrote:

> I'm getting the delay -after- I close the SelectSQL editor, not when it
> opens.  I'm just typing text directly into the SQL box and am nowt browsing
> tables or fields.  Also, the TIBSQL component does not use the SelectSQL
> editor and I still get the delay.

> Dan

--
Jeff Overcash (TeamB)
      (Please do not email me directly unless  asked. Thank You)
Anyone who cannot cope with mathematics is not fully human.
At best he is a tolerable subhuman who has learned to wear
shoes, bathe and not make messes in the house.   (Heinlein)
Dan Palle

Delphi Developer
Tue, 18 Nov 2003 03:14:49 GMT

Re:IBX query components at design time


Jeff:

Sorry to bother you.  It appears to be an issue with my shared BDE/IBX
TDatabase component.  I retested the same form with a plain TIBDatabase
component as the Database source and the problem went away.

How are you coming with the 4.6 IBX update for Delphi 5?

Thanks,

Dan

"Jeff Overcash (TeamB)" <overc...@onramp.net> wrote in message
news:3B168E54.7E5A1F7A@onramp.net...

Quote
> I don't see this either with remote or local connections on the current
version
> I'm working on.  I can't think of anything that would have changed to do
this
> either though.

> Dan Palley wrote:

> > I'm getting the delay -after- I close the SelectSQL editor, not when it
> > opens.  I'm just typing text directly into the SQL box and am nowt
browsing
> > tables or fields.  Also, the TIBSQL component does not use the SelectSQL
> > editor and I still get the delay.

> > Dan

> --
> Jeff Overcash (TeamB)
>       (Please do not email me directly unless  asked. Thank You)
> Anyone who cannot cope with mathematics is not fully human.
> At best he is a tolerable subhuman who has learned to wear
> shoes, bathe and not make messes in the house.   (Heinlein)

Team

Delphi Developer
Tue, 18 Nov 2003 03:59:51 GMT

Re:IBX query components at design time


Quote
Dan Palley wrote:

> Jeff:

> Sorry to bother you.  It appears to be an issue with my shared BDE/IBX
> TDatabase component.  I retested the same form with a plain TIBDatabase
> component as the Database source and the problem went away.

> How are you coming with the 4.6 IBX update for Delphi 5?

There is a fix freeze except for the BCB static link problem.  That is the only
fix I plan on adding to 4.6 between now and the release.  I plan on having it
ready right around when D6 ships as they will be functionally pretty much the
same (with the same fixes from 4.52).  I just need to get a bit of time to work
on the BCB bug.

Quote

> Thanks,

> Dan

--
Jeff Overcash (TeamB)
      (Please do not email me directly unless  asked. Thank You)
Anyone who cannot cope with mathematics is not fully human.
At best he is a tolerable subhuman who has learned to wear
shoes, bathe and not make messes in the house.   (Heinlein)
William Buchana

Delphi Developer
Sat, 22 Nov 2003 16:03:36 GMT

Re:IBX query components at design time


Hi Dan
I am getting the same problem!
It doesn't happen all the time but one day it seemed to happen every time I
opened the SQL editor. Very annoying and worrying. I have also experienced
long delays 15 - 20 secs.

Will

Quote
"Dan Palley" <d...@trams.com> wrote in message news:3b168cea_1@dnews...
> I'm getting the delay -after- I close the SelectSQL editor, not when it
> opens.  I'm just typing text directly into the SQL box and am nowt
browsing
> tables or fields.  Also, the TIBSQL component does not use the SelectSQL
> editor and I still get the delay.

> Dan

> "Sergio Samayoa" <serg...@terra.com.gt> wrote in message
> news:3b1682a2_2@dnews...
> > Since you aren't connect to database, each time the SelectSQL editor
> starts
> > must connect to database and fetch table names from it. You can avoid
such
> > efect making your database connected at design time but set
> > AllowStreamConnected to false. Then, when the database component is
loaded
> > from stream it doesn't connect until you do it explicit by code.

> > --
> > Sergio Samayoa
> > Lgica Software
> > http://www.geocities.com/logicasw/

Other Threads

1. IBX components lose references in design time

2. query runs at design time but not run time

3. Component - Design Time Great...Run-Time Not...Help

4. Design-time vs Run-time components in BCB3

5. ibx for kylix very unstable in design time.

6. How to build IBX Design time packages.

7. Design-Time Manipulation Of Custom Component NOT In Component Palette

8. Parametrized query at design time cannot be active?

9. property editors and creating components at design time in them

10. DELPHI: Debugging design-time components