Hmmm...how hard would it be allow one to bind the table name with prepare?




Michael D. Black

Senior Scientist

Advanced Analytics Directorate

Advanced GEOINT Solutions Operating Unit

Northrop Grumman Information Systems

________________________________
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Konrad J Hambrick [kon...@payplus.com]
Sent: Tuesday, November 01, 2011 8:44 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Indirect Referencing


Bertus --

The only way to reference a Variable Table Name would
be to create a Dynamic SQL Statement at runtime, prep
the Dynamic Statement then exec.

This would be true for all implementations of SQL that
I am aware of ...

-- kjh

Stander, Bertus (Pretoria) wrote, On 11/01/2011 05:25 AM:
> Good day to you all,
>
> I am very inexperienced with SQlite and any help will be appreciated.
>
> I want to know if I can use indirect referencing within the SQL language
> as per SQlite standards. I will give an example.
>
> If I create a  table as illustrated  below.
>
> CREATE TABLE Testing (
>
>    ID INTEGER PRIMARY KEY AUTOINCREMENT,
>
>    Tbl_Name  VARCHAR (45));
>
> The value of 'Tbl_Name' is set to 'My_Table'
>
> Will it be possible to read the values in table My_Table using the field
> 'Tbl_Name'?
>
> Select * from  Testing.Tbl_Name;
>
> The tests I have performed is not working.
>
> Any suggestions or  work around please?
>
>
>
>
> This email has been scanned for viruses and malware, and automatically 
> archived by Mimecast SA (Pty) Ltd, an innovator in Software as a Service 
> (SaaS) for business.  Mimecast Unified Email Management
> UEM) offers email continuity, security, archiving and compliance with all 
> current legislation. To find out more,contact Mimecast.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to