[sqlite] VBA Sqllite blob data

and error I was able to figure out which pieces of code I needed for my project. Thanks for all of the help. Preston Statement of Confidentiality: The contents of this message are confidential. Any unauthorized disclosure, reproduction, use or dissemination (either whole or in part

[sqlite] VBA Sqllite blob data

Thank you for all of your suggestions and tips. I have been able to use the code samples and extract the data that I needed from my database in a test scenario. I am now modifying it to work with the live database. Thanks again. Preston King, NHCPM NH Department of Information Technology

[sqlite] VBA Sqllite blob data

worksheet. SQLite Studio exports the record that I need into an Excel worksheet just fine. I then copy the record into the worksheet that I created and execute my routines to produce the reports that have been requested. I am trying to have as little user interaction as possible. Thanks, Preston

[sqlite] VBA Sqllite blob data

Discussion of SQLite Database Subject: Re: [sqlite] VBA Sqllite blob data What do you mean with: into Excel? Into a cell in the worksheet, into a VBA variable? What code did you try? I never use blobs, but I don't think it should be a problem. RBS On Fri, May 8, 2015 at 8:15 PM, Preston King

[sqlite] VBA Sqllite blob data

Does anyone have an example of how to read sqlite blob records, that are not pictures, into Excel? I have been trying to find some VBA code to do this but am not having much luck. Thanks

[sqlite] ODBC

Thank you, I will take a look at it. Preston King, NHCPM NH Department of Information Technology at NHDOT - TMC 110 Smokey Bear Blvd. Concord NH 03302 (603) 271-6862 www.nh.gov/doit Statement of Confidentiality: The contents of this message are confidential. Any unauthorized disclosure

[sqlite] ODBC

not been able to find anything newer. Has anyone written VBA code that can read records that longer than 255 characters? Thanks for your help. Preston King

[sqlite] example of import/copy for Windows?

I'm trying to import a .sql file into a db on Windows. I'm doing a migration. I was able to create the .sql file from the old sqlite3 db with the dump command. But I cannot figure out the syntax/format of the import command for Windows. The examples on the sqlite3 site are for *nix, and seem

[sqlite] transaction w/ large journal fails

else run into anything similar? Is there anything i need to do in linux that i don't have to do in windows? Any advise? thanks Preston - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] spanish chars

, Preston - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] PRAGMA user_version;

onto a revision of the database? --Preston

Re: [sqlite] Encryption

te.org the last one is 3.3.5. What is the diference ? , where i can download encryption ( that it's a need funcionality for sqlite ) Thanks !!! On 5/10/06, Preston & Chrystie <[EMAIL PROTECTED]> wrote: > I'm having trouble compiling the 3.4.5 version with encryption > extensions.. I

Re: [sqlite] Possible bug with non-standard characters in column names

fix it for you.. guess not, but at least you know of the potential error sooner rather than later...tried the column name in quotes too.. didn't help. --preston On 5/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Not sure- I've tried this through JDBC and the command line client, I'm n

[sqlite] sqlite error after upgrade to 3.3.5

PKAC ON ac(ac1, ac2); CREATE TABLE aci( acintNOT NULL, i intNOT NULL ); CREATE UNIQUE INDEX PKACI ON ACI(ac, i); Any help would be appreciated. --Preston

[sqlite] Encryption

of tclsqlite.c) gcc -DSQLITE_HAS_CODEC=1 *.c -o sqlite3.4.5.exe the exe is built, but i can't open an encrypted database and .rekey command gives me the following: 'unknown command or invalid arguments: "rekey". Enter ".help" for help' So what am i doing wrong? thanks, Preston

RE: [sqlite] Which VC6 options to use for fastest sqlite3?

since you have /MT i am assuming you will need /D "THREADSAFE". If you are used to MSVC and want to try another compiler i would suggest grabbing http://www.codeblocks.org, it is an IDE and you can import you MSVC project into it and compile with the MinGW/gcc compiler, which it will set up for

RE: [sqlite] How dangerous is PRAGMA Synchronous OFF?

. If these run OK then you are probably fine. Anybody have a better way to tell if a db is garbage? I hope i answered at least part of your question... --Preston From: "Dinsmore, Jeff" <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: <sqlite-users@sqlite.org>

RE: [sqlite] BEGIN TRANSACTION name

You are exactly right on all points. In fact, as I understand it, this is actually what MS SQL Server does internally. IMHO knowing that there isn't any real benefit to nested transactions then a developer should normally be able to design code that doesn't use nested transactions. --Preston

RE: [sqlite] Request for comment: Proposed SQLite API changes

rade to it without re-writing queries? (I can hope can't I?) Thanks Preston As currently implemented, when an error occurs during sqlite3_step(), the function returns SQLITE_ERROR. Then you have to call either sqlite3_reset() or sqlite3_finalize() to find the actual error code. Suppose this w

RE: [sqlite] CHECK constraints

MS SQL 2000 wil alsol insert (5, NULL) From: "Marcus Welz" <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: Subject: RE: [sqlite] CHECK constraints Date: Wed, 2 Nov 2005 19:24:09 -0500 PostgreSQL 8.0 will happily insert (5, NULL). -Original

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

love to see a strict affinity mode db with the inclusion of a dynamically typed column that can still be used. BTW: a dynamically typed column is actually included in MSSQL 2005. ALso is there a "roadmap" type document that talks about the future of sqlite? --Preston

RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

quot; if stored in a "real" column, otherwise it should act as it currently does. Thanks for asking for opinions before making the change Preston From: [EMAIL PROTECTED] Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2 Dat

RE: [sqlite] On VACUUM I get "constraint failed"

his helps --preston From: John Duprey <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: [sqlite] On VACUUM I get "constraint failed" Date: Thu, 20 Oct 2005 14:01:10 -0400 We have an SQLite database with a table that has about a m

Re: [sqlite] drop statement returns SQLITE_ERROR

You right... i had even been following a similar thread and didn't realize that it was my problem too.. thanks a ton! --preston - Original Message - From: "Robert Simpson" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, October 14, 2005 2:55 P

Re: [sqlite] Infinite loop on sqlite3_close()

From: Jens Miltner <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: Re: [sqlite] Infinite loop on sqlite3_close() Date: Fri, 14 Oct 2005 17:38:04 +0200 Am 10.10.2005 um 16:53 schrieb Preston Zaugg: While running some performance tests

Re: [sqlite] drop statement returns SQLITE_ERROR

"Preston Zaugg" <[EMAIL PROTECTED]> wrote: > I have some updates to the schema of my sqlite database that i am trying to > apply. When i run these statements from the command line util they run fine. > when i run them from the API I get a SQLITE_ERROR on the state

[sqlite] Infinite loop on sqlite3_close()

While running some performance tests i ran into a condition where sqlite3_close got caught in an infinite loop. The loop it gets caught in is on line main.c 194: while( pPrev && pPrev->pNext!=db ){ pPrev = pPrev->pNext; } This did not happen until i upgraded to 3.2.7, not the only

Re: [sqlite] SQL logic error when running vacuum;

Incase anybody runs into this in the future... I found the cause of this problem... I had a view that was pointing to a column of the table that no longer exsists. As soon as i dropped the view i was able to vacuum the database without error. --Preston - Original Message - From

RE: [sqlite] SQL logic error when running vacuum;

interface that much. I suspect it has nothing to do with the engine itself, rather with the command-line tool. > -Original Message- > From: Preston Zaugg [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 04, 2005 6:35 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQL logic

[sqlite] SQL logic error when running vacuum;

ed running into this problem. Upgraded to 3.2.7 with the same results. I'm on Windows 2003 and using a local database. Any suggestions? --Preston

[sqlite] column name inconsistency...

; The work-around for this is of course to explicitly alias your columns to the names you were expecting, but it is probably worth changeing if only to make it more intuitive and consistent. thanks --preston

Re: [sqlite] SQLite Browser (Mac OS 10.3)

I understand the difference between the two and use them both often, for their intended purposes. Yes, it was Console that I had open each time I was launching SQLite Browser and attempting to monitor for errors... and each time Console showed nothing. I have tried this on multiple computers

Re: [sqlite] SQLite Browser (Mac OS 10.3)

Yes... in OS X, everything that happens is written on in an app called Console. I write the author a while back too and he asked that I attempt to launch it again with Console running and then send him whatever errors/messages appear, but... strangely... I am still getting nothing in the

[sqlite] sqlite command-line utility (was: manual? documentation?)

Jon, you're awesome. Thank you! Wade, although your question isn't phrased like this, it seems to be "Where can I find good documentation on using SQL?" Whether you use the command-line, or are connecting to SQLite through PHP is irrelevant. The syntax for adding, deleting, modifying and

Re: [sqlite] manual? documentation?

Are there any manuals or further documentation for SQLite than what is found on sqlite.org? I assume that most the database interaction stuff is pretty straight forward for individuals with database administration experience, but SQLite is my first database. Most of the documentation is for

Re: [sqlite] SQLite Browser (Mac OS 10.3)

Has anyone successfully run SQLite Browser... http://sqlitebrowser.sourceforge.net ...on Mac OS 10.3? What error you get? None. That's what's strange about it. It won't even launch. It starts in the dock but dies one second (literally) later.

[sqlite] web-based admin utilities

Is anyone aware of a web-based admin utility for SQLite similar to phpMyAdmin? I found one... .http://sqlitemanager.sourceforge.net/ ...but it is not in English and doesn't look very impressive. wade - To unsubscribe,

[sqlite] SQLite Browser (Mac OS 10.3)

Has anyone successfully run SQLite Browser... http://sqlitebrowser.sourceforge.net ...on Mac OS 10.3? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]