Board index » delphi » newbie : replace active := false active := true

Wolfgang Lechner

Delphi Developer
Sun, 07 Aug 2005 00:09:25 GMT

newbie : replace active := false active := true

hi

I have two adotables with master/detail relation.
I change data in both, master and/or detail table
with append and post.
Then I display the data as a tree.
If I rebuild the tree i first have to set
set active := false and then active := true
to see the change.
If is do refresh for example nothing happens.

What can I use instead of setting active false/true?

thanks in advance
wolf

 
Brian Holliste

Delphi Developer
Sun, 07 Aug 2005 00:53:02 GMT

Re:newbie : replace active := false active := true


Check out the Requery method of TCustomADODataset. Or just select your
ADOTable, hit F1, then click the Methods link and read up on this method. It
points out that one method is better than the other. From that you should
decide which is better.

Quote
"Wolfgang Lechner" <thebigbadw...@gmx.at> wrote in message

news:3e525a0d$1@newsgroups.borland.com...
Quote
> hi

> I have two adotables with master/detail relation.
> I change data in both, master and/or detail table
> with append and post.
> Then I display the data as a tree.
> If I rebuild the tree i first have to set
> set active := false and then active := true
> to see the change.
> If is do refresh for example nothing happens.

> What can I use instead of setting active false/true?

> thanks in advance
> wolf

Wolfgang Lechne

Delphi Developer
Sun, 07 Aug 2005 01:42:54 GMT

Re:newbie : replace active := false active := true


I have a Table with 32000 Entries in a MySql Database
over a network.
If I deactive and activate my table it needs 5sec.
If I use requery 4,7sec.
both are not acceptable.

Should I use an other database another connection
RDS, is mysql - ado nonsense?

Im new to db over network, so every little
help is usefull for me
thanks in advance
wolf

"Brian Hollister" <bhollisterATfuturaintlDOTcom> schrieb im Newsbeitrag
news:3e52639e$1@newsgroups.borland.com...

Quote
> Check out the Requery method of TCustomADODataset. Or just select your
> ADOTable, hit F1, then click the Methods link and read up on this method.
It
> points out that one method is better than the other. From that you should
> decide which is better.

> "Wolfgang Lechner" <thebigbadw...@gmx.at> wrote in message
> news:3e525a0d$1@newsgroups.borland.com...
> > hi

> > I have two adotables with master/detail relation.
> > I change data in both, master and/or detail table
> > with append and post.
> > Then I display the data as a tree.
> > If I rebuild the tree i first have to set
> > set active := false and then active := true
> > to see the change.
> > If is do refresh for example nothing happens.

> > What can I use instead of setting active false/true?

> > thanks in advance
> > wolf

Brian Holliste

Delphi Developer
Sun, 07 Aug 2005 02:16:47 GMT

Re:newbie : replace active := false active := true


Wolfgang,

Sorry i cannot help anymore. I am new to this stuff as well. The best bit of
info i can give you is to just try other combinations. If you do the testing
please post the results and share with others.

sorry,

brian

Quote
"Wolfgang Lechner" <thebigbadw...@gmx.at> wrote in message

news:3e526ff6@newsgroups.borland.com...
Quote
> I have a Table with 32000 Entries in a MySql Database
> over a network.
> If I deactive and activate my table it needs 5sec.
> If I use requery 4,7sec.
> both are not acceptable.

> Should I use an other database another connection
> RDS, is mysql - ado nonsense?

> Im new to db over network, so every little
> help is usefull for me
> thanks in advance
> wolf

> "Brian Hollister" <bhollisterATfuturaintlDOTcom> schrieb im Newsbeitrag
> news:3e52639e$1@newsgroups.borland.com...
> > Check out the Requery method of TCustomADODataset. Or just select your
> > ADOTable, hit F1, then click the Methods link and read up on this
method.
> It
> > points out that one method is better than the other. From that you
should
> > decide which is better.

> > "Wolfgang Lechner" <thebigbadw...@gmx.at> wrote in message
> > news:3e525a0d$1@newsgroups.borland.com...
> > > hi

> > > I have two adotables with master/detail relation.
> > > I change data in both, master and/or detail table
> > > with append and post.
> > > Then I display the data as a tree.
> > > If I rebuild the tree i first have to set
> > > set active := false and then active := true
> > > to see the change.
> > > If is do refresh for example nothing happens.

> > > What can I use instead of setting active false/true?

> > > thanks in advance
> > > wolf

Brian Bushay Team

Delphi Developer
Sun, 07 Aug 2005 10:38:53 GMT

Re:newbie : replace active := false active := true


Quote
>I have a Table with 32000 Entries in a MySql Database
>over a network.
>If I deactive and activate my table it needs 5sec.
>If I use requery 4,7sec.
>both are not acceptable.

Try disableControls on the dataset before you Requery and enablecontrols after
Requery.  

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Wolfgang Lechne

Delphi Developer
Sun, 07 Aug 2005 16:26:10 GMT

Re:newbie : replace active := false active := true


Quote
> Still bussy with VirtualtreeView ... <G>

Yes, now I try it myself (not using VTdbEx)
was easier than I thought.

Quote
> If you know what records (prim.Key?) are change you could try to
> requery only the change records?

Thats exactly what (I think) I need. How can I do this?

I post a new entries with append - fieldbyname -... - post.
If I then rebuild my (VT)-tree the adotable is not updated.
How can I requery this inserted record?

wolf

Wolfgang Lechne

Delphi Developer
Sun, 07 Aug 2005 19:57:35 GMT

Re:newbie : replace active := false active := true


thanks, but....
I changed to a direct access library today,
and all my problems are gone :-)

"Wolfgang Lechner" <thebigbadw...@gmx.at> schrieb im Newsbeitrag
news:3e533efa@newsgroups.borland.com...

Quote
> > Still bussy with VirtualtreeView ... <G>
> Yes, now I try it myself (not using VTdbEx)
> was easier than I thought.

> > If you know what records (prim.Key?) are change you could try to
> > requery only the change records?
> Thats exactly what (I think) I need. How can I do this?

> I post a new entries with append - fieldbyname -... - post.
> If I then rebuild my (VT)-tree the adotable is not updated.
> How can I requery this inserted record?

> wolf

Frits

Delphi Developer
Mon, 08 Aug 2005 02:19:24 GMT

Re:newbie : replace active := false active := true


Quote
Wolfgang Lechner wrote:
> I changed to a direct access library today,

Just curious, but what library are you using?
--
Greetings,  Frits.

posted with XanaNews 1.13.2.6

Wolfgang Lechne

Delphi Developer
Mon, 08 Aug 2005 02:29:04 GMT

Re:newbie : replace active := false active := true


zeos with mysql-direct-library (Christian Nicloa)
really really great stuff

"Frits." <VirtualDataT...@gmx.net> schrieb im Newsbeitrag
news:3e53caac$1@newsgroups.borland.com...

Quote
> Wolfgang Lechner wrote:

> > I changed to a direct access library today,

> Just curious, but what library are you using?
> --
> Greetings,  Frits.

> posted with XanaNews 1.13.2.6

Wolfgang Lechne

Delphi Developer
Mon, 08 Aug 2005 02:30:12 GMT

Re:newbie : replace active := false active := true


Quote
> zeos with mysql-direct-library (Christian Nicloa)

Christian Nicola of course
Frits

Delphi Developer
Mon, 08 Aug 2005 02:54:47 GMT

Re:newbie : replace active := false active := true


Quote
> zeos with mysql-direct-library (Christian Nicola)

I will look into that,
thx

--
Greetings,  Frits.

posted with XanaNews 1.13.2.6

Other Threads

1. IsServiceRunning must return False when Active=False

2. SQL.Query.Active:=False ???

3. Difference between Close and Active=False

4. TCPServer Active := false

5. idTCPServer active := False

6. Socket.Active not made false after closing socket

7. TidTCPServer Active := false exception

8. TidTCPServer.Active := false (closing connections)

9. Indy Bug : IdUDPServer.Active:=false ?

10. AV with TIdTCPServer.Active := False ?