Subject | Row ID |
---|---|
Author | bkirk_lrs |
Post date | 2007-03-12T18:32:01Z |
After lots of looking (perhaps in the wrong the places) I have to post a question that I could not find the answer to. Here is the background info and question: I have a legacy Firebird database that I need to post data from and I cannot manipulate the database in any way (i.e., I need to work the database "as is"). Since my limited database background does not include Interbase/Firebird, I have not been able to figure out how to pull rows by a rowid (aka - oid, uid, row id, etc.). There are only 5 items in the table schema (1 date stamp and 4 ints) and a constraint using an index (as the primary key) that uses the timestamp and lane number (app-specific int value) columns. I have read about generators, but that there was not one created for this table. Is there any way to use a rowid (or equivalent) to ensure I don't post the same data twice? Otherwise it seems I may need to keep all the data I post and search it every time I post something else! Regards, Ben