[EMAIL PROTECTED] wrote:
> A user complains in ticket #1689 that SQLite does not
> allow triggers in one database to refer to tables in
> a different database or to TEMP tables.
...
> Should I remove the tests from SQLite that prevent
> triggers in one database from referring to tables in
> a
Vishal Kashyap escreveu:
Why is this mail here.
Does this software support SQlite as backend ???
Yes. In fact is the default file format. See
http://kexi-project.org/wiki/wikiview/index.php?KexiFAQ#3._File_Formats
Luiz
On 3/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> As ssen at http://www.linuxdevices.com/news/NS3880195342.html
>
> The Acme Fox also supports PHP development, optionally
> with Oracle's open source SQLite database.
>
>
> Amusing, but not true.
Heh, Oracle's SQLite?
"Denis Sbragion" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> might be a bit off topic, but, is there any way to make donations to SQLite? I
> haven't been able to find informations on the SQLite web site.
>
There is no mechanism set up to "donate" to SQLite as there
is with other open-source
As ssen at http://www.linuxdevices.com/news/NS3880195342.html
The Acme Fox also supports PHP development, optionally
with Oracle's open source SQLite database.
Amusing, but not true.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Hello,
I am not sure if that is exactly the problem, but
it seems that sqlite3_prepare() deadlocks when called
to attach a in-memory database that is already attached.
The second ATTACH occurs on a separate thread with a
separate handle to a database that is already opened in
the process.
Is
Why is this mail here.
Does this software support SQlite as backend ???
On 2/28/06, Jarosław Staniek <[EMAIL PROTECTED]> wrote:
>
> For original announcement with links see
> http://kexi-project.org/wiki/wikiview/index.php?1.0Beta1Announcement
>
>
I'm using SQLite under Windows CE, and I cannot for the life of me get an
error code from sqlite3_step(), even when the SQL statement I compiled with
sqlite3_prepare() is clearly not valid (wrong # of columns, column type
mismatch, etc.)
It *never* returns anything other than SQLITE_DONE or
"Clay Dowling" <[EMAIL PROTECTED]> wrote:
>
> Can I get a reliable rowid from [sqlite3_last_insert_rowid()]
> while I'm in the middle of a transaction
>
Yes. Why would you think otherwise?
--
D. Richard Hipp <[EMAIL PROTECTED]>
I'm using SQLite in a performance-intensive data conversion process and
it's come about that it would be very useful to get the insert_rowid of
the last record inserted while I'm still in the middle of a transaction of
servert hundred inserts(the primary key will become a foreign key to a
child
I am not sure how this would work. in order for a trigger to "See"
another database, somebody (obviously not the trigger) must ATTACH the
database first. is there an automatic ATTACH capability that I am not
aware of ? if not, specifying triggers than span databases is looking
for trouble IMHO. as
On 2/28/06, Teg <[EMAIL PROTECTED]> wrote:
> Hello Niels,
>
> That problem goes away if you switch to using the
>
> sqlite3_prepare
>
> sqlite3_bind_...()
>
> Syntax for insertions. Then all escaping becomes unnecessary. Using
> this syntax has removed an entire escaping layer I'd implemented.
It
On 2/28/06, Luiz Americo Pereira Camara <[EMAIL PROTECTED]> wrote:
> The sqlite documentation states that when the stored value of an Integer
> field is NULL and is used sqlite3_column_int to retrieve the data, the
> returned value is 0.
> Currently to know if the value is zero or NULL i check the
Hello Niels,
That problem goes away if you switch to using the
sqlite3_prepare
sqlite3_bind_...()
Syntax for insertions. Then all escaping becomes unnecessary. Using
this syntax has removed an entire escaping layer I'd implemented.
C
Tuesday, February 28, 2006, 5:25:48 AM, you wrote:
NB>
Le 28 févr. 06 à 14:25, Niels Boldt a écrit :
Hi Guys
I'm having some problems dealing with the character '. Sqlite thinks
fair enough that it should terminate the string, which I would like it
to avoid. Are there any solutions to my problems.
Thanks, Niels
Replace the ' (one ' ) with
Should I remove the tests from SQLite that prevent
triggers in one database from referring to tables in
a different database?
Well, I have a couple of triggers in my SQL Server database that refer
to tables in another database, though they are on the same server.
Obviously, I can see some
I think that sqlite3_column_type suppose to tell you if it is NULL.
http://www.sqlite.org/capi3ref.html#sqlite3_column_type
It returns SQLITE_NULL in that case.
However I don't see how you can avoid calling two functions in a scenario
you suspect a NULL (so if sqlite3_column_int returns a zero,
On 2/28/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
>
>
> CREATE TRIGGER
> http://sqlite.org/lang_createtrigger.html
>
> Igor Tandetnik
>
Great! Thanks.
(I should have mentionded that this was a beginners question)
Eugen Stoianovici
<[EMAIL PROTECTED]> wrote:
Is there a way to track changes performed on a table?
What i need is a way of knowing when an insert/update has been issued
on a table so that i can read the new values.
CREATE TRIGGER
http://sqlite.org/lang_createtrigger.html
Igor Tandetnik
The sqlite documentation states that when the stored value of an Integer
field is NULL and is used sqlite3_column_int to retrieve the data, the
returned value is 0.
Currently to know if the value is zero or NULL i check the value of
sqlite3_column_text (that returns NULL in that case). The
For original announcement with links see
http://kexi-project.org/wiki/wikiview/index.php?1.0Beta1Announcement
---
Kexi Team Ships Beta Version of the First Major 1.0 Release to Free
Integrated Database Environment
Is there a way to track changes performed on a table?
What i need is a way of knowing when an insert/update has been issued on a
table so that i can read the new values.
Hi Niels,
You've just found the first problem with using TEXT columns. What you need to
do is put another ' in front of it i.e. ''. Depending on the language you are
using, you may find it includes a function that "escapes" special characters
like '. For example, PHP supply
> Hi Guys
>
> I'm having some problems dealing with the character '. Sqlite thinks
> fair enough that it should terminate the string, which I would like it
> to avoid. Are there any solutions to my problems.
>
> Thanks, Niels
Hello Niels
try:
sqlite> CREATE TABLE t (id INTEGER, bez TEXT);
Hi Guys
I'm having some problems dealing with the character '. Sqlite thinks
fair enough that it should terminate the string, which I would like it
to avoid. Are there any solutions to my problems.
Thanks, Niels
25 matches
Mail list logo