Board index » delphi » Cached Updates with MS SQL Server

Matt Peebles

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Cached Updates with MS SQL Server

I read on Inprise's web site about the cached updates problem with the
TQuery component.  It says this occurs with Paradox tables.  Is this a
problem with SQL servers like MS SQL Server?  I was hesitating to use cached
updates with the TQuery against SQL Server since I read that, but I thought
I would check here to see if it was safe.

Thanks!

 
Jim Jackso

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Cached Updates with MS SQL Server


Quote
Matt Peebles wrote:
> I read on Inprise's web site about the cached updates problem with the
> TQuery component.  It says this occurs with Paradox tables.  Is this a
> problem with SQL servers like MS SQL Server?  I was hesitating to use cached
> updates with the TQuery against SQL Server since I read that, but I thought
> I would check here to see if it was safe.

> Thanks!

 Matt,
I'm using cached updates with C++ Builder 3.0 and Sybase 11. They work as
advertised.
Jim

Other Threads

1. OnUpdateError - Cache updates / SQL Server 7

2. Delphi 4 + SQL Server 7 + Cached Updates + Tquery + TUpdateSQL

3. TTable, Cached Updates, Filter, SQL Server 6.5

4. Delphi4: Cached updates and SQL server - Lock file has grown too large

5. SQL Server 6.5, Transactions, Locking, Cached Updates

6. Cached updates & SQL server

7. SQL Server/Cached Updates/Problem with Memos!

8. BDE, SQL Server and cached updates

9. Schema Cache not Caching for SQL Server 6.5?

10. Cached Updates are dead - long live cached updates?