Re: [sqlite] Oracle connection

Simon Hax wrote: > I don't know what JET is. > I testet ADO. That works. > But it'is slow and you have to write some (to much) code. > > Much more better would be a solution like a direct LINK (like an Oracle > Database Link). > > as shown in my first email: > > insert into sqlitetable_columA

Re: [sqlite] WAL in SQLite

Richard Hipp wrote: > On Sat, May 29, 2010 at 5:42 PM, Darren Duncan wrote: >> "3. Transactions that involve changes against multiple ATTACHed >> databases are atomic for each individual database, but are not atomic across >> all >> databases as a set." >> >> I

Re: [sqlite] rescueing data after accidental DROP

After the DROP, a CREATE TABLE command is executed to create a table with the same name as structure. As for the second question, I am not sure as I ask this question for a colleague instead of myself. If the payment is not too large, I think he might be willing to (still, not for sure). Regards

Re: [sqlite] rescueing data after accidental DROP

On 4 Jun 2010, at 2:44am, Wincent wrote: > Dear all, I am interested in the same issue as well. > Is it possible to recover data after the drop command is executed? > > I saw from the homepage it is not > (http://www.sqlite.org/lang_droptable.html), but I really hope it is > possible. Any

Re: [sqlite] rescueing data after accidental DROP

Dear all, I am interested in the same issue as well. Is it possible to recover data after the drop command is executed? I saw from the homepage it is not (http://www.sqlite.org/lang_droptable.html), but I really hope it is possible. Any hints? Thank you Best On Mon, Aug 18, 2008 at 11:31 PM,

Re: [sqlite] on delete no action

On Jun 1, 2010, at 11:09 PM, Dan Kennedy wrote: > > On Jun 2, 2010, at 11:41 AM, Scott Frankel wrote: > >> >> Hi all, >> >> I've been lurking for a few days while I explore SQLite and find >> myself now with a question. >> >> What's the correct usage for the "ON DELETE NO ACTION" statement? >>

Re: [sqlite] Oracle connection

http://tinyurl.com/29sk9pr On Thu, Jun 3, 2010 at 12:09 PM, Simon Hax wrote: > I don't know what JET is. > I testet ADO. That works. > > ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Oracle connection

I don't know what JET is. I testet ADO. That works. But it'is slow and you have to write some (to much) code. Much more better would be a solution like a direct LINK (like an Oracle Database Link). as shown in my first email: insert into sqlitetable_columA select ColX from ta...@oracledb If

Re: [sqlite] Oracle connection

On 3 Jun 2010, at 4:25pm, Simon Hax wrote: > Is something possible like > > insert into sqlite_table.ColumnA select x from ta...@oracledb > > ? > (Without copying into local memory (firstly do a select from Oracle ) > and then insert into a Sqlite database (via e.g. ADO ). ) > > S. Which set

Re: [sqlite] Oracle connection

MSFT JET supports heterogeneous data sources. Assuming you have a JET MDB with a data-connection to Oracle and another data-connection to SQLite, and have attached the relevant tables from each, you could move data from one back-end data source to the other. This approach brings the data from

Re: [sqlite] Oracle connection

On 3 Jun 2010, at 4:25pm, Simon Hax wrote: > Is something possible like > > insert into sqlite_table.ColumnA select x from ta...@oracledb > > ? > (Without copying into local memory (firstly do a select from Oracle ) > and then insert into a Sqlite database (via e.g. ADO ). ) Which set of

[sqlite] Oracle connection

Is something possible like insert into sqlite_table.ColumnA select x from ta...@oracledb ? (Without copying into local memory (firstly do a select from Oracle ) and then insert into a Sqlite database (via e.g. ADO ). ) S. ___ GRATIS für

Re: [sqlite] WAL in SQLite

On Sat, May 29, 2010 at 5:42 PM, Darren Duncan wrote: > > 4. Quoth the raven: > > "3. Transactions that involve changes against multiple ATTACHed > databases > are atomic for each individual database, but are not atomic across all > databases > as a set." > > I

[sqlite] ANN: SQLite Maestro 10.5 released

Hi! SQL Maestro Group announces the release of SQLite Maestro 10.5, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ New features = 1. This release has been

Re: [sqlite] Problem with sqlite3

First off I assume you two know the difference between a DLL .LIB and a static .LIB -- they are different. I used Microsoft Visual C++ Studio 2010 Express and 2008 Express and downloaded the windows sqlite3 DLL from the website http://www.sqlite.org/sqlitedll-3_6_23_1.zip #1 Open a Visual

Re: [sqlite] Problem with sqlite3

On 6/2/2010 9:56 AM, lukasz aaa wrote: > Hello. Sorry for my English. > I have a problem with the SQLite library reloaded correctly (use in > project). I'm using VC++ 2010 and Dev. > I add to project sqlite3.h, copy to folder with source sqlite3.dll and > sqlite3.lib. I add sqlite3.lib to linker -