Board index » delphi » ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000

Production ids

Delphi Developer
Tue, 26 Apr 2005 17:30:01 GMT

ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000

How refresh data on a computer when we modified it on an other computer in
network.
We use Ado Table and Ado Query but it would not refresh automaticly, is it
normal ?

Thanks.

Calou

 
Gustavo Gianordol

Delphi Developer
Tue, 26 Apr 2005 18:56:42 GMT

Re:ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000


Try to close and open the TAdoQuery or call requery.

AdoQuery1.Close;
AdoQuery1.Open;
 or
AdoQuery1.Requery;

Look the Delphi's help file to see the difference between both of them.

Gustavo Gianordoli

"Production ids" <prod....@club-internet.fr> escreveu na mensagem
news:3dcb8422$1@newsgroups.borland.com...

Quote
> How refresh data on a computer when we modified it on an other computer in
> network.
> We use Ado Table and Ado Query but it would not refresh automaticly, is it
> normal ?

> Thanks.

> Calou

Brian Bushay Team

Delphi Developer
Wed, 27 Apr 2005 10:29:15 GMT

Re:ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000


Quote
>How refresh data on a computer when we modified it on an other computer in
>network.
>We use Ado Table and Ado Query but it would not refresh automaticly, is it
>normal ?

Yes that is normal.  Unless you are using a serverside dynamic cursor you are
getting snapshot of the data with your TadoQuery and TadoTable.

Use Requery for the fastest way to refetch the data
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Vassiliev V.V

Delphi Developer
Wed, 25 May 2005 03:47:50 GMT

Re:ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000


Any OLEDB provider including MS Jet (MS Access) and MS SQL Server (including
MSDE) does support server-side cursor. Client-side cursor itself on low
level uses server-side cursors. However its functionality is most times less
then on client-side cursor. But some functionality is available only on
server-side cursor, such as setting IndexName in MS Jet.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (LCPI provider, http://www.lcpi.lipetsk.ru) databases.

"Ana Ribeiro" <aribe...@e-pay.co.uk> ????/???? a ?a???? ????t??:
news:3df0ced7$1@newsgroups.borland.com...

Quote
> Hello
> I know Access doesn't allow server side cursors. Do you know if MSDE does?

> Thanks
> Ana

> "Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
> news:uqmosucu7n7bn6lb10mrce5f63h64i5r2d@4ax.com...
> > >How refresh data on a computer when we modified it on an other computer
> in
> > >network.
> > >We use Ado Table and Ado Query but it would not refresh automaticly, is
> it
> > >normal ?

> > Yes that is normal.  Unless you are using a serverside dynamic cursor
you
> are
> > getting snapshot of the data with your TadoQuery and TadoTable.

> > Use Requery for the fastest way to refetch the data
> > --
> > Brian Bushay (TeamB)
> > Bbus...@NMPLS.com

Brian Bushay Team

Delphi Developer
Wed, 25 May 2005 11:54:57 GMT

Re:ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000


Quote
>I know Access doesn't allow server side cursors. Do you know if MSDE does?

Access does allow serverside cursors and it is one of the few cases where they
make good sense to use because there is quite a bit of functionality you can
only get with serverside cursors and JET.

MSDE aslo supports serverside cursors
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Ana Ribeir

Delphi Developer
Fri, 27 May 2005 18:07:03 GMT

Re:ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000


I see. Thank you.
Ana

"Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
news:tlg2vusc0sk0egvdgme3qja1f06vmj3n84@4ax.com...

Quote

> >I know Access doesn't allow server side cursors. Do you know if MSDE
does?
> Access does allow serverside cursors and it is one of the few cases where
they
> make good sense to use because there is quite a bit of functionality you
can
> only get with serverside cursors and JET.

> MSDE aslo supports serverside cursors
> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

Other Threads

1. ?? ADO query or an ADO dataset ???

2. ADO and Parameterized ADO Query

3. Timeout Expired error with ADO Query component on large SQL Server table

4. Refreshing ADO DataSets over a network?

5. ADO Query Refresh

6. ADO queries not refreshing

7. ADO MS-SQL locks on TempDB from read-only SQL Queries via TADOQuery

8. I cannot refresh the ADO Table with Delphi5

9. Cursortype / CursorLocation / refresh Access Tables with ADO

10. ADO and Table.refresh