Yes that function points into the right direction !
But I need something like that:
SELECT t0.x as col0, t1.x as col1 from table0 as t0, table1 as t1 where t0.y =
t1.y;
Now I want the following information about the colums:
1: column name = col0
original column name = x
table name = t0
original table name = table0
2: column name = col1
original column name = x
table name = t1
original table name = table1
--- "Plenert, Joerg" <[EMAIL PROTECTED]> wrote:
> Hi !
>
> I need a possibility to get the table name
> (actual and/or original) from a column.
>
> There is a function sqlite3_column_name that
> returns the name of the column.
> How about a function sqlite3_column_tablename
> that returns the tablename ?
>
> I need that function to check user rights on
> the data returned by sqlite.
>
> Regards
>
> Joerg Plenert
>
Not what you asked I know, but have you looked at this:
http://www.sqlite.org/capi3ref.html#sqlite3_set_authorizer
Might provide a more foolproof solution.
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail
