On Tue, Nov 01, 2011 at 02:01:30PM +, Black, Michael (IS) scratched on the
wall:
> Hmmm...how hard would it be allow one to bind the table name with prepare?
Generally, "very."
Or, rather, it would be fairly straight forward if you're willing
to skip the query optimization step and
...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Simon Slavin [slav...@bigfraud.org]
Sent: Tuesday, November 01, 2011 9:10 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Indirect Referencing
On 1 Nov 2011, at 2:01pm, Black, Michael (IS) wrote:
> Hmmm...how hard wo
[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
On 1 Nov 2011, at 2:01pm, Black, Michael (IS) wrote:
> Hmmm...how hard would it be allow one to bind the table name with prepare?
If you are in a position to bind the table name, does that not mean you could
just merge all the tables together ?
Simon.
[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
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:
Thanks Simon,
The response I am giving here is to assist others in deciding whether
they can use SQlite.
I understand Triggers reasonably well as I am using it continuously very
successfully.
The 1200 tables in the SQlite database has no impact on performance as
every transaction executed on a
On 1 Nov 2011, at 11:44am, Stander, Bertus (Pretoria) wrote:
> That is one aspect. I also want to use minimal triggers to identify
> certain abnormalities and perform certain processes. This I want to keep
> Central and not writing triggers for all 1200 tables. So key to a
> solution I was
Thanks for the response Simon.
I am working with field loggers where the field workers are capturing
different assets using a Trimble mobile device.
I have more than 1200 individual tables, each table holding the values
of a unique asset.
Living in South Africa where bandwidth is a myth in some
On 1 Nov 2011, at 10:25am, Stander, Bertus (Pretoria) wrote:
> If I create a table as illustrated below.
>
> CREATE TABLE Testing (
>
> ID INTEGER PRIMARY KEY AUTOINCREMENT,
>
> Tbl_Name VARCHAR (45));
In this example you have a TABLE called 'Testing' and a COLUMN called
'Tbl_Name'.
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
11 matches
Mail list logo