RE: [GENERAL] using Oids to retrieve a row

[Michael Davis]

I use the following technique:
add sequence to the primary key of the table
look up the sequence the primary key
insert a record using (including) the primary key
re-query the newly inserted record using the primary key

Thanks, Michael

        -----Original Message-----
        From:   David O'Farrell [SMTP:[EMAIL PROTECTED]]
        Sent:   Friday, March 26, 1999 5:39 AM
        To:     [EMAIL PROTECTED]
        Subject:        [GENERAL] using Oids to retrieve a row


        anyone know if it is possible to INSERT a row , "save" the oid for
this
        row and subsequently select it based only on the oid ?

        -- 
        
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~
          David O'Farrell                              AerSoft Limited

          mailto:[EMAIL PROTECTED]              2 Northumberland
Avenue,
                                                       Dun Laoghaire,Co.
Dublin
                Direct Phone 353-1-2145950
                       Phone: 01-2301166   Fax: 01-2301167
        
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~