Autoincrement fields aren't updated when CacheUpdates=true

p...@my-deja.com

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Autoincrement fields aren't updated when CacheUpdates=true

I have a Paradox database with autoincrement key fields. Unfortunately
they aren't updated when Table.CacheUpdates is true. They do so if I
flush the cache with ApplyUpdates, but I want to them to be available
before using this method. Any suggestions?

Thanks in advance

Pawel Suski
p...@polbox.com

Sent via Deja.com http://www.deja.com/
Before you buy.

Carsten Schuett

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Autoincrement fields aren't updated when CacheUpdates=true

No chance.

--
Greetings,
Carsten Schtte

<p...@my-deja.com> schrieb im Newsbeitrag
news:8eh17s$vu9$1@nnrp1.deja.com...

Quote

> I have a Paradox database with autoincrement key fields. Unfortunately
> they aren't updated when Table.CacheUpdates is true. They do so if I
> flush the cache with ApplyUpdates, but I want to them to be available
> before using this method. Any suggestions?

> Thanks in advance

> Pawel Suski
> p...@polbox.com

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Bruce Robert

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Autoincrement fields aren't updated when CacheUpdates=true

Quote

<p...@my-deja.com> wrote in message news:8eh17s$vu9$1@nnrp1.deja.com...
> I have a Paradox database with autoincrement key fields. Unfortunately
> they aren't updated when Table.CacheUpdates is true. They do so if I
> flush the cache with ApplyUpdates, but I want to them to be available
> before using this method. Any suggestions?

Don't use AutoIncrement fields, code your own.

Quote

> Thanks in advance

> Pawel Suski
> p...@polbox.com

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Ellinor Jense

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Autoincrement fields aren't updated when CacheUpdates=true

Hello,

my approach on this, is to use a dedicated table with fields for all
autoincrement numbers. ID numbers, Ordernumbers and so on.
I call it IDMaster.
In Table1.OnNewRecord event I copy the current number from IDMaster table.
Then you can update IDMaster with a new number in the Table1.BeforePost
event.
This causes the number to increase only if Table1.Post, and not if
Table1.Cancel.

This also works fine regardless of CachedUpdates.

:)
Kai Inge

<p...@my-deja.com> skrev i meldingsnyheter:8eh17s$vu...@nnrp1.deja.com...

Quote

> I have a Paradox database with autoincrement key fields. Unfortunately
> they aren't updated when Table.CacheUpdates is true. They do so if I
> flush the cache with ApplyUpdates, but I want to them to be available
> before using this method. Any suggestions?

> Thanks in advance

> Pawel Suski
> p...@polbox.com

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Other Threads

1. Autoincrement fields: how are they updated?

2. Posting updates with CahedUpdate=True doesn't work

3. table - cashed updates & autoincrement fields

4. Cached updates and Autoincrement fields in Access

5. autoincrement field + cache update

6. Paradox AutoIncrement Field Problem With SQL Update Statement

7. Cannot update -- Access-autoincrement field

8. ttable.fielddefs.update doesn't update deleted fields

9. HELP: can't get field=TRUE test in SQL to work

10. HELP: can't get field=TRUE test is SQL to work