HELP parsing select statement ? 
Author Message
 HELP parsing select statement ?

Does anyone have any code to determine what tables and fields are being
returned in a select statement.

Ie.  select field1, field2 from table1, table2.

Has anyone written anything that will read in the select statement
and spit out the fact that field1 is in table2 and field2 is in table1?

I know that the field name is stored in the sqlda structure, but I can't
find where the table name is stored.  I assume that the code would have
to check the syscolumns and systables tables.

Any help would be greatly appreciated.
        Scott Deifik



Fri, 26 Apr 1996 09:24:26 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. parse in select statement

2. parse in select statement 2

3. SQL SELECT statements - parsing and indexes

4. Help me convert a SELECT statement to an UPDATE statement

5. USING A FIELD FROM MAIN SELECT STATEMENT IN SUB SELECT STATEMENT

6. Parsing "contains" statements

7. Parsing a field in an SQL statement

8. insert statement using values from a select statement

9. IF STATEMENTS IN SELECT STATEMENTS

10. parse SQL statement

11. Can I Programmatically Parse a SQL Statement?

12. Running SELECT statement within EXECUTE statement


 
Powered by phpBB® Forum Software