Board index » delphi » Using CachedUpdates in TTable component
Roy Rutten
![]() Delphi Developer |
Sun, 01 Dec 2002 03:00:00 GMT
|
Roy Rutten
![]() Delphi Developer |
Sun, 01 Dec 2002 03:00:00 GMT
Using CachedUpdates in TTable component
Hello !
In an application I have to do some complicated processing on several So I thought, why not use the cached updates functionality of a table. It Any suggestions ? Thanks, Roy |
M.H. Avegaar
![]() Delphi Developer |
Sun, 01 Dec 2002 03:00:00 GMT
Re:Using CachedUpdates in TTable componentUse transactions instead of cached updates (look for StartTransaction/Commit/Rollback in the Delphi help). "Roy Rutten" <remove.no.junkmail.roy.rut...@xarmac.nl> schreef in bericht Quote> Hello ! |
Roy Rutte
![]() Delphi Developer |
Sun, 01 Dec 2002 03:00:00 GMT
Re:Using CachedUpdates in TTable componentThanks for the help ! Roy M.H. Avegaart <avega...@NOSPAMmccomm.nl> schreef in berichtnieuws Quote> Use transactions instead of cached updates (look for |
Roy Rutte
![]() Delphi Developer |
Sun, 01 Dec 2002 03:00:00 GMT
Re:Using CachedUpdates in TTable componentI've tried using a TDataBase component. All works fine, until the number of records to be added/deleted/modified exceeds 255. Can this boundary be adjusted in some way? Thanks, Roy M.H. Avegaart <avega...@NOSPAMmccomm.nl> schreef in berichtnieuws Quote> Use transactions instead of cached updates (look for |
M.H. Avegaar
![]() Delphi Developer |
Sun, 01 Dec 2002 03:00:00 GMT
Re:Using CachedUpdates in TTable componentThat depends on the type of database you are using... "Roy Rutten" <remove.no.junkmail.roy.rut...@xarmac.nl> schreef in bericht Quote> I've tried using a TDataBase component. All works fine, until the number |
Don
![]() Delphi Developer |
Sun, 01 Dec 2002 03:00:00 GMT
Re:Using CachedUpdates in TTable componentThis might help. I needed a table to be posted to the disk right away. I wrote some In the AfterPost event of each table I used the following code. procedure TDataModule.Table1AfterPost(DataSet: TDataSet); As I understand it this dumps the data right to hard drive. I also Hope this helps a bit. Cheers On Wed, 14 Jun 2000 12:00:52 +0200, "Roy Rutten" Quote<remove.no.junkmail.roy.rut...@xarmac.nl> wrote: |
Roy Rutte
![]() Delphi Developer |
Mon, 02 Dec 2002 03:00:00 GMT
Re:Using CachedUpdates in TTable componentThanks for the help. Might need this in the future. However, I need something which doesn't write changes to disk, as long as I Roy Don <donwa...@thezone.net> schreef in berichtnieuws Quote> This might help. |
Roy Rutte
![]() Delphi Developer |
Mon, 02 Dec 2002 03:00:00 GMT
Re:Using CachedUpdates in TTable componentI'm using Paradox databases. Do other types support a bigger record cache ? Thanks, Roy M.H. Avegaart <avega...@NOSPAMmccomm.nl> schreef in berichtnieuws Quote> That depends on the type of database you are using... |
1. TDatabase's Transaction VS TTable's CachedUpdates
2. DELPHI ERRORS - TTable Filter, CachedUpdate and RecordCount.
3. Filtering on a TTable with CachedUpdate
4. Persistant Database connection when using TTable components in a DLL
5. Using MainForm Ttable component from dialogs How????
6. using TTable component in SQLBased databases
7. Using TTable from ActiveServerPage Component
8. TQuery vs TTable while using data-aware components