[sqlite] Execute SQLite statements within callback

Is this possible? I need to either delete the current row or update a field in the current row during the callback execution for that row. I am using the sqlite3 C API. Any suggestions would be greatly appreciated. -- View this message in context: http://www.nabble.com/Execute-SQLite-statement

[sqlite] RE: [RBL] Re: [sqlite] XML to SQLite upload

This is the right approach, when I worked in the SGML world with a component versioning system, we called it the "non-linear" design. By going down this road, your table schema is static and can cope with any type of DTD without change. However, you need to create a tool that will convert your XM

Re: [sqlite] Execute SQLite statements within callback

mtenuta wrote: Is this possible? I need to either delete the current row or update a field in the current row during the callback execution for that row. I am using the sqlite3 C API. You can't insert into, delete, or update rows in a table that you're currently reading from. One workaround

[sqlite] Displaying a SQLite databse in VB.Net

Hi, I am having some trouble displaying the data from a database in my VB.Net application, I am using the Finisar ADO.Net wrapper to connect to the SQLite database. I can display the data using messageboxes and textboxes so I know it's working, I just can't figure out how to display it in somethi

[sqlite] How to get the lastest version of SQLITE with PHP ???

Hi all ! I ve searched a long time, but I didn't found how to get the lastest sqlite version with php ! I only got the the 3.2.8 (if my memory is good), with the pdo_sqlite with php5. There is a way to get the lastest ??? I ve try to manual compil and install the lastest SQLite (all

Re: [sqlite] How to get the lastest version of SQLITE with PHP ???

> I only got the the 3.2.8 (if my memory is good), > with the pdo_sqlite with > php5. PECL PDO-SQLite uses (links to) whichever version of SQLite is installed on the machine where it's compiled. If you want a newer version, install sqlite and recompile the PHP extension. __

[sqlite] Réf. : Re: [sqlite] How to get the lastest version of SQL ITE with PHP ???

    Already tested but this not worked.   Because in fact pdo_sqlite look have is own sqlite library into Php_source_dir/ext/pdo_sqlite/sqlite   But maybe you are sure of what you said, and you can tell me more ??   Thanks

Re: [sqlite] R�f. : Re: [sqlite] How to get the lastest version of SQLITE with PHP ???

--- Night Media LTD <[EMAIL PROTECTED]> wrote: > > > Already tested but this not worked. > > Because in fact pdo_sqlite look have is own sqlite > library into > Php_source_dir/ext/pdo_sqlite/sqlite I was talking about the PECL PHP extension. Don't know about the bundled one. ___

Re: [sqlite] How to get the lastest version of SQLITE with PHP ???

Just looked the PECL pdo_sqlite extension, And un the release 1.0.1 changelog (last one) I got Changelog for PDO_SQLITE Release What has changed? 1.0.1 - Updated libsqlite in ext/pdo_sqlite to 3.2.8. (Ilia) - Upgraded to new package2 format - Fixed PECL Bug #5633; build issue

Re: [sqlite] How to get the lastest version of SQLITE with PHP ???

--- Night Media LTD <[EMAIL PROTECTED]> wrote: > > Release What has changed? > > 1.0.1 - Updated libsqlite in ext/pdo_sqlite to > 3.2.8. (Ilia) >From the source of config.m4 in ext/pdo_sqlite: --with-pdo-sqlite[=DIR] PDO: sqlite support. DIR is the sqlite base directory, the bundled sqlite

Re: [sqlite] XML to SQLite upload

* Steve O'Hara <[EMAIL PROTECTED]> [2006-05-07 11:20]: > This is the right approach, when I worked in the SGML world > with a component versioning system, we called it the > "non-linear" design. > > By going down this road, your table schema is static and can > cope with any type of DTD without ch

Re: [sqlite] XML to SQLite upload

We built a tool at one time for a specific application which would build B-tree indices onto an XML document, giving read-only access to what became many tables like a relational database. It tied together disparate legacy application systems. The addition of an SQL compiler and query engine

Re: [sqlite] How to get the lastest version of SQLITE with PHP ???

This one time, at band camp, Ivan Voras <[EMAIL PROTECTED]> wrote: > On my platform (FreeBSD) the bundled version is not > used by default so that's how I came to the wrong > conclusion. If you can rebuild it from scratch, maybe > you also can exclude the bundled library. Other than this, you cou

[sqlite] Low Level API for SQLite3

Any body know whether there are any low level C API's for sqlite3 ? ** The information contained in, or attached to, this e-mail, contains confidential information and is intended solely for the use of the individual or entity to whom t

Re: [sqlite] Low Level API for SQLite3

Anish Enos Mathew wrote: > Any body know whether there are any low level C API's for sqlite3 ? > Ummm - how about the native one ? -- Lindsay

Re: [sqlite] Low Level API for SQLite3

Anish Enos Mathew wrote: > Any body know whether there are any low level C API's for sqlite3 ? > > > ** > > The information contained in, or attached to, this e-mail, contains > confidential information and is intended solely for the use of

RE: [sqlite] Low Level API for SQLite3

Ya, I know about the API's given in sqlite.org. but that does not contribute much to my reqirements. I want low level API's so that we can reduce the parsing time taken by the sqlite parser. -Original Message- From: Lindsay [mailto:[EMAIL PROTECTED] Sent: Monday, May 08, 2006 10:25 AM To

Re: [sqlite] Low Level API for SQLite3

Anish Enos Mathew wrote: > Ya, I know about the API's given in sqlite.org. but that does not > contribute much to my reqirements. I want low level API's so that we can > reduce the parsing time taken by the sqlite parser. > Well if you explained what you actually want to do it would help peopl

Re: [sqlite] Low Level API for SQLite3

You can get the source code from sqlite.org. What more do you need if you are going to come up with a new version of Sqlite? You might look to caching compiled (prepared) SQL statements and using sqlite3_step as a very powerful method of not just reducing SQL parsing time but making it a firs

RE: [sqlite] Low Level API for SQLite3

Well, currently I am doing a mobile project and we are testing the performance of four databases depending on the time it takes to insert or delete or search a particular data from the database. I am using sqlite3 database. I am using sqlite_exec command for doing a particular process in the data

Re: [sqlite] Low Level API for SQLite3

Anish Enos Mathew wrote: > Well, currently I am doing a mobile project and we are testing the > performance of four databases depending on the time it takes to insert > or delete or search a particular data from the database. I am using > sqlite3 database. I am using sqlite_exec command for doing

Re: [sqlite] Low Level API for SQLite3

On Mon, May 08, 2006 at 04:06:33PM +1000, Bill KING wrote: > Anish Enos Mathew wrote: > > Well, currently I am doing a mobile project and we are testing the > > performance of four databases depending on the time it takes to insert > > or delete or search a particular data from the database. I am