Re: Re: Can you determine table from ROWID?

Hi,

What about the case when the query involves a UNION? I don't know why but maybe the application needs to know which table the row was actually retrieved from.

Martyn Jones,
Compaq HQIM, Munich.

>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 Mon Nov 14 1994 - 16:17:38 CET