Re: Can you determine table from ROWID?

From: Lawrence James <James.Lawrence_at_epamail.epa.gov>
Date: Thu, 10 Nov 1994 22:55:41 GMT
Message-ID: <James.Lawrence.7.0011EE28_at_epamail.epa.gov>


In article <CyMKxw.tC_at_trapac.com> karl_at_trapac.com (Karl Kraft) writes:
>From: karl_at_trapac.com (Karl Kraft)
>Subject: Can you determine table from ROWID?
>Keywords: ROWID
>Date: Wed, 2 Nov 1994 05:37:08 GMT
 

>I'm looking for a simple way to determine the table a record is
>in, given the ROWID of the record.
 

>If I can limit the search to a particular group of tables (say 3
>or four), is the ROWID only certain to appear in one table? If
>yes, then I could just select on each table looking for the ROWID.
>Is there a more general way to turn a ROWID into a table name?

I'll bite, how'd you get a row id without knowing what table you selected it from???

>--
>Karl Kraft
>Karl_Kraft_at_trapac.com
>Karl_Kraft_at_ensuing.com
>[My opinions are my own]
Received on Thu Nov 10 1994 - 23:55:41 CET

Original text of this message