| View previous topic :: View next topic |
| Author |
Message |
Eric Verstrepen
Guest
|
 Posted: Fri Feb 18, 2005 6:48 pm Post subject: No update |
 |
|
I have Tadoconnection - TadoQuery - Tdatasource - Tdbgrid
I use Delphi7 with AccesTable.
When i insert,delete or whatever, the grid is never updated.
I tried Tadoquery.refresh or Resync but nothing works.
The only thing thats is working is when i reload the Query.
Acces Table has all the changes without any problem.
I hope someone can help me
Best Regards,
Eric Verstrepen
|
|
| Back to top |
|
 |
Bill Todd
Guest
|
| Posted: Fri Feb 18, 2005 7:29 pm Post subject: Re: No update |
|
|
How are you inserting or deleting rows? ary you using the grid or are you
using the TAdoQuery's Insert and Delete methods?
--
Bill Todd (TeamB)
TeamB cannot answer questions received via email
|
|
| Back to top |
|
|
Eric Verstrepen
Guest
|
| Posted: Fri Feb 18, 2005 7:49 pm Post subject: Re: No update |
|
|
I am using the methods from the TAdoQuery's
"Bill Todd" <no (AT) no (DOT) com> schreef in bericht
news:42164206$1 (AT) newsgroups (DOT) borland.com...
| Quote: | How are you inserting or deleting rows? ary you using the grid or are you
using the TAdoQuery's Insert and Delete methods?
--
Bill Todd (TeamB)
TeamB cannot answer questions received via email
|
|
|
| Back to top |
|
|
Bill Todd
Guest
|
| Posted: Fri Feb 18, 2005 8:14 pm Post subject: Re: No update |
|
|
If you are using the TAdoQuer.Insert and TAdoQuery.Delete methods of the
AdoQuery the grid is connected to then you should see the changes in the
grid.
If you use SQL INSERT and DELETE statements in another AdoQuery then you
will have to close and reopen the AdoQuery connected to the grid to see
the changes.
--
Bill Todd (TeamB)
TeamB cannot answer questions received via email
|
|
| Back to top |
|
|
Eric Verstrepen
Guest
|
| Posted: Fri Feb 18, 2005 8:16 pm Post subject: Re: No update |
|
|
Found it !
I was using the same TAdoQuery on another form and had Called
TAdoQuery.Disablecontrols but no matching TAdoQuery.Enablecontrols. So the
system was out of sequence.
"Eric Verstrepen" <eric.verstrepen (AT) pandora (DOT) be> schreef in bericht
news:42163874 (AT) newsgroups (DOT) borland.com...
| Quote: | I have Tadoconnection - TadoQuery - Tdatasource - Tdbgrid
I use Delphi7 with AccesTable.
When i insert,delete or whatever, the grid is never updated.
I tried Tadoquery.refresh or Resync but nothing works.
The only thing thats is working is when i reload the Query.
Acces Table has all the changes without any problem.
I hope someone can help me
Best Regards,
Eric Verstrepen
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
