Finding a column name of a column you know the value of. [message #2679] |
Tue, 06 August 2002 07:58 |
Jason Reid
Messages: 2 Registered: August 2002
|
Junior Member |
|
|
Hi i'm writing a full text search app using Delphi 6 and the rubicon 2 set of components.The problem that I have run into is this:
I can retrieve all the information I need using the rubicon components exept the name of the field where the match occoured.Now i know i can retrieve all the column names with a query that goes something along the lines of:
SELECT COLUMN_NAME
FROM ALL_TAB_COLUMNS
WHERE OWNER = :OWNER AND TABLE_NAME = :TABLENAME
ORDER BY COLUMN_NAME
My question is , is there some way I can add to this query to specify that it must only return colunm names that have a certain value (ei my search value).
Perhaps something like:
SELECT COLUMN_NAME
FROM ALL_TAB_COLUMNS
WHERE OWNER = :OWNER AND TABLE_NAME = :TABLENAME
AND VALUE = :SEARCHVALUE
ORDER BY COLUMN_NAME
Thats just a guess but if anyone can help me out I would REALLY appreciate it...
Thanks in advance
Jason Reid
|
|
|
|
|
|