Subject | Re: Row ID |
---|---|
Author | bkirk_lrs |
Post date | 2007-03-12T22:06:30Z |
Unfortunately we need an id for a row that won't change over time,
so I can't use RDB$DB_KEY. As for the existing primary key, it is no
good either since the date stamp is not guaranteed to be unique
either... ex - the date is reset on the server, etc (and I can't
change the existing database schema). It seems that I'm stuck with
keeping a list of sent rows to compare against. Any other ideas?
Thanks,
Ben
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:
so I can't use RDB$DB_KEY. As for the existing primary key, it is no
good either since the date stamp is not guaranteed to be unique
either... ex - the date is reset on the server, etc (and I can't
change the existing database schema). It seems that I'm stuck with
keeping a list of sent rows to compare against. Any other ideas?
Thanks,
Ben
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:
>
> Ben,
>
> If you can't use the primary key, look here:
>
> http://www.cvalde.net/document/practical_use_of_the_rdb.htm
>
>
> Good Luck,
>
>
> Ann
>