On Tue, Jun 26, 2012 at 02:52:43PM +0200, Ralf Junker scratched on the wall:
> On 26.06.2012 14:33, Vivien Malerba wrote:
>
> > The code is some SQL entered by the user, I have no control over it. There
> > is effectively the possibility to parse the SQL entered, detect the CREATE
> > table
On 26 June 2012 15:31, Black, Michael (IS) wrote:
> If you have sqlite3.c in your project you can just add your own hook.
>
>
>
> Take a look at sqlite3TwoPartName if you want to see if before it's
> created.
>
>
>
> Or look at sqlite3StartTable (end of the function) if
On 26 June 2012 15:00, kyan wrote:
> > Is there any possibility to be notified when a table is created (when a
> > "CREATE TABLE XXX" is executed)?
>
> You could try installing a profile callback using sqlite3_profile()
> (see http://www.sqlite.org/c3ref/profile.html). Of
On 26 June 2012 14:55, Simon Slavin wrote:
>
> On 26 Jun 2012, at 1:33pm, Vivien Malerba wrote:
>
> > The code is some SQL entered by the user, I have no control over it.
> There
> > is effectively the possibility to parse the SQL entered, detect the
>
: Tuesday, June 26, 2012 7:33 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Detecting when a table is created
On 26 June 2012 14:21, Igor Tandetnik <itandet...@mvps.org> wrote:
> Vivien Malerba <vmale...@gmail.com> wrote:
> > Is there any possibilit
> Is there any possibility to be notified when a table is created (when a
> "CREATE TABLE XXX" is executed)?
You could try installing a profile callback using sqlite3_profile()
(see http://www.sqlite.org/c3ref/profile.html). Of course this
callback will be called for any kind of SQL or DDL
On 26 Jun 2012, at 1:33pm, Vivien Malerba wrote:
> The code is some SQL entered by the user, I have no control over it. There
> is effectively the possibility to parse the SQL entered, detect the CREATE
> table statement and act accordingly, but I would like to see if SQLite
On 26.06.2012 14:33, Vivien Malerba wrote:
> The code is some SQL entered by the user, I have no control over it. There
> is effectively the possibility to parse the SQL entered, detect the CREATE
> table statement and act accordingly, but I would like to see if SQLite has
> some kind of builtin
On 26 June 2012 14:21, Igor Tandetnik wrote:
> Vivien Malerba wrote:
> > Is there any possibility to be notified when a table is created (when a
> > "CREATE TABLE XXX" is executed)?
>
> How is it executed? Isn't it your program that executes the
Vivien Malerba wrote:
> Is there any possibility to be notified when a table is created (when a
> "CREATE TABLE XXX" is executed)?
How is it executed? Isn't it your program that executes the statement? How come
you don't know when that happens?
--
Igor Tandetnik
Hi!
Is there any possibility to be notified when a table is created (when a
"CREATE TABLE XXX" is executed)?
The context here is that I have an SQLite connection with only virtual
tables and when the user manually creates a table, the table is created
either in memory or in the temporary file
11 matches
Mail list logo