Board index » delphi » changes in ttable do not appear in tquery with paradox

Fernando

Delphi Developer
Mon, 21 Nov 2005 10:17:23 GMT

changes in ttable do not appear in tquery with paradox

Why the new records or update ones do not appear in other net computer with
dbQuery component close and open?

I use Paradox and after post use dbisavechanges(table.handle);

--
Fernando H Lusardo
www.odrasul.com.br
meu icq = 29843787

 
heiko Luettg

Delphi Developer
Mon, 21 Nov 2005 17:47:11 GMT

Re:changes in ttable do not appear in tquery with paradox


You have to use Query.Close, Query.Open to refresh the changes of the Table
(with TTable you have to use Table.Refresh).

I know no other way.

Heiko

Wayne Niddery [TeamB

Delphi Developer
Tue, 22 Nov 2005 02:03:17 GMT

Re:changes in ttable do not appear in tquery with paradox


Quote
Fernando wrote:
> Why the new records or update ones do not appear in other net
> computer with dbQuery component close and open?

> I use Paradox and after post use dbisavechanges(table.handle);

Read this article and see if it helps.
http://community.borland.com/article/0,1410,15247,00.html

--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
Powered by Delphi and IB: http://www.logicfundamentals.com/RadBooks.html
"Democracy, without that guarantee of liberty, is merely a method of
selecting tyrants." - Alan Nitikman

Fernand

Delphi Developer
Tue, 22 Nov 2005 03:27:58 GMT

Re:changes in ttable do not appear in tquery with paradox


Everything is like the article, and more... when use TTable and use refresh
its ok!
When I use TQuery and mount a sql of the table updated, those modifications
do not appear in the TQuery!
I use Delphi 5
Please help!!

"Wayne Niddery [TeamB]" <wnidd...@chaff.aci.on.ca> escreveu na mensagem
news:3edf8647$1@newsgroups.borland.com...

Quote
> Fernando wrote:
> > Why the new records or update ones do not appear in other net
> > computer with dbQuery component close and open?

> > I use Paradox and after post use dbisavechanges(table.handle);

> Read this article and see if it helps.
> http://community.borland.com/article/0,1410,15247,00.html

> --
> Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
> Powered by Delphi and IB: http://www.logicfundamentals.com/RadBooks.html
> "Democracy, without that guarantee of liberty, is merely a method of
> selecting tyrants." - Alan Nitikman

Wayne Niddery [TeamB

Delphi Developer
Wed, 23 Nov 2005 04:57:43 GMT

Re:changes in ttable do not appear in tquery with paradox


Quote
Fernando wrote:
> Everything is like the article, and more... when use TTable and use
> refresh its ok!
> When I use TQuery and mount a sql of the table updated, those
> modifications do not appear in the TQuery!

With TQuery, you must close and reopen the TQuery to refresh the data.

--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
Powered by Delphi and IB: http://www.logicfundamentals.com/RadBooks.html
"Democracy, without that guarantee of liberty, is merely a method of
selecting tyrants." - Alan Nitikman

Fernand

Delphi Developer
Wed, 23 Nov 2005 08:25:08 GMT

Re:changes in ttable do not appear in tquery with paradox


like I say in my first question,  I close and reopen the tquery, but do not
show the modifications in the net!

"Wayne Niddery [TeamB]" <wnidd...@chaff.aci.on.ca> escreveu na mensagem
news:3ee100aa$1@newsgroups.borland.com...

Quote
> Fernando wrote:
> > Everything is like the article, and more... when use TTable and use
> > refresh its ok!
> > When I use TQuery and mount a sql of the table updated, those
> > modifications do not appear in the TQuery!

> With TQuery, you must close and reopen the TQuery to refresh the data.

> --
> Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
> Powered by Delphi and IB: http://www.logicfundamentals.com/RadBooks.html
> "Democracy, without that guarantee of liberty, is merely a method of
> selecting tyrants." - Alan Nitikman

Other Threads

1. updating Tquery - params dont appear to change

2. HELP : "Invalid Paramater", when doing Tquery.Open, seems to not release resources

3. Text changes not appearing in TMemo

4. Changing TTable and TQuery components to IB components

5. Responding to changes in underlying database with a TTable/TQuery

6. Update TQuery after changes in TTable

7. TTable Vs TQuery With Paradox on LAN

8. D2 and Paradox 7 : TQuery vs TTable and speed

9. Has anyone done a TQuery within a TQuery?

10. TTable vs TQuery - Paradox