Re: [sqlite] SQLiteDataAdaptor Missing

Yes. It's running on 64bit but I compiled it for 32 bit. I've tried using the 64bit version however, when I reference the 64bit dll's the compiler generates warnings about the image even when I set it to debug 64bit, and when I try to run the 64bit version it crashes so I've opted to compile it

Re: [sqlite] SQLiteDataAdaptor Missing

SubKey: rootKey = "HKEY_LOCAL_MACHINE\Software\Microsoft\VisualStudio\8.0\DataProviders\ {0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", subKeyName = "SupportedObjects\DataConn ectionUIControl" Installer.exe: #104 @ 2012.02.21T20:49:45.0340377: RegistryHelper.CreateSubKey: rootKey = "HKE

Re: [sqlite] SQLiteDataAdaptor Missing

Rob Richardson wrote: > In another library, I had to specify "x86" processor because it wasn't > designed for 64-bit machines. Might you need to do that? > > RobR > > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto: > sqlite-users

Re: [sqlite] SQLiteDataAdaptor Missing

: Invalid core file image runtime version. On Mon, Feb 20, 2012 at 1:59 PM, Joe Mistachkin wrote: > > Electric Eddy wrote: > > > > Maybe not going as far as including updates in the installer for support > > for 2005 but at least a manual process for getting it working i

Re: [sqlite] SQLiteDataAdaptor Missing

ugh for me to build these commands programatically however, the designer was used extensively throughout the project so it would be very time consuming to remove the designer generated code and replace it with normal code. Patrick On Mon, Feb 20, 2012 at 12:58 PM, Joe Mistachkin wrote: > &g

Re: [sqlite] SQLiteDataAdaptor Missing

Mistachkin wrote: > > Electric Eddy wrote: > > > > That's a pity, my problem is for the type of development I do, spending a > > few grand on upgrading to 2008 for the sake of the SQLite designer > > capability would be hard to justify. > > > > Actually

Re: [sqlite] SQLiteDataAdaptor Missing

ck to 2005. I'll probably need to port to MS SQL to allow for future maintenance of the legacy application I'm maintaining. Patrick. On Sun, Feb 19, 2012 at 12:39 AM, Joe Mistachkin wrote: > > Electric Eddy wrote: > > > > The installer still only appears to detect that V

Re: [sqlite] SQLiteDataAdaptor Missing

e installer list VS 2005 as an option to configure during the installation or should VS 2005 be covered by the VS 2008 option? Regards Patrick On Sat, Feb 18, 2012 at 12:44 PM, Electric Eddy wrote: > Thanks, when I looked at the version of the SQLiteDataAdapter it was > 1.0.66 and listed in the GA

Re: [sqlite] SQLiteDataAdaptor Missing

ly it seems to ignore the 2005 SDK so I'll download the patch. Regards Patrick. On Sat, Feb 18, 2012 at 10:27 AM, Joe Mistachkin wrote: > > Electric Eddy wrote: > > > > e.g. DeleteCommand/CommandText it pops up an error stating: Data Provider > > identified by guid &#x

Re: [sqlite] SQLiteDataAdaptor Missing

I downloaded VS 2008 trial and associated SDK and reinstalled sqlite and the controls appear in the Toolbox under 2008. However, when I open the properties of an existing SQLiteDataAdaptor and press the "..." next to e.g. DeleteCommand/CommandText it pops up an error stating: Data Provider identif

[sqlite] SQLiteDataAdaptor Missing

I built a project originally using SQLite-1.0.66.0-setup.exe and when I upgraded to 1.0.79 the SQLiteDataAdaptor Toolbox control under Visual Studio 2005 Professional disappeared. The project still works after updating references from 1.0.66 to 1.0.79 however I cann

Re: [sqlite] Bash Scripting

from WXData where RecDateTime>='2011-12-07 21:22' and RecDateTime<='2011-12-07 21:27' and RecordType='R';" To state the obvious TomaCampo=$(sqlite3 .....) rather than TomaCampo=sqlite3 Eddy ___ sql

[sqlite] Column alignment in bash with utf8

any advice. In the meanwhile I'll have to stick to using iso-8859-1 with sqlite, quite a pity knowing that sqlite uses unicode internally. -- Eddy Message réalisé et envoyé sous GNU/Linux composé à 100 % d'électrons libres.

[sqlite] ANNOUNCE: SHSQL - SQL for LINUX/UNIX Shell scripts

Hi I have just released SHSQL under the GPL, it is a method how SQL can be easily intergrated into shell scripts. The web site is at http://www.edlsystems.com/shsql and can be downloaded from ftp://ftp.edlsystems.com/shsql (Needless to say a SQLite3 version is included) Enjoy Eddy -- Edward

Re: [sqlite] Get a table's primary key?

rowid is alsways an alias for the primary key whether an "integer primary key" field was specified or not On Tue, 2004-10-05 at 18:57, Kirk Haines wrote: > Does the SQLite API (for either 2.x or 3.x versions of SQLite) offer > any way to determing which field, if any, in a table was created as an

Re: [sqlite] Schema of an attached database

Wow - that was fast! Any plans for a 3.0.8? Eddy On Tue, 2004-10-05 at 16:44, D. Richard Hipp wrote: > Eddy Macnaghten wrote: > > This does not seem to work for 3.0.7 > > > > > >>Marc Pitoniak wrote: > >> > >>>To get the schema of

Re: [sqlite] Schema of an attached database

This does not seem to work for 3.0.7 If you have a table named "t" in the main database, and you attach a database that has a table named t in it as attachdb, then pragma attachdb.table_info(t); still seems to give the info for the table t in the main database. Is this a bug or have I got it wr

Re: [sqlite] why remove sqlite_encode() ?

If you use BLOBs I do not think you need sqlite_encode_binary and sqlite_decode_binary On Tue, 2004-10-05 at 02:30, [EMAIL PROTECTED] wrote: > Hello, > > I am new to sqlite. So far I've been very impressed by it. We > are using it as the backend of an open-source MAPI message store. > Still str

RE: [sqlite] SQL help

On Tue, 2004-10-05 at 01:55, Eddy Macnaghten wrote: > > SELECT MAX(A) AS A, B, C > > FROM T > > GROUP BY B > > > > This is an invalid SQL statement (SQLite should generate an error here). > > The correct(tm) way to do this is with subqueries. > > ORA

RE: [sqlite] SQL help

m t group by b); which should give you what you want if you can. Eddy

Re: [sqlite] "library routine called out of space"

Are you sure you do not mean "out of memory" ? That means a malloc failed. What are you calling sqlite3_prepare with? Especially what is the third argument? On Fri, 2004-10-01 at 01:06, Cory Nelson wrote: > Anyone know why I'd get that from an sqlite3_prepare()? -- Edward A. Macnaghten http:/

[sqlite] Database enumeration

Hi Is there a way of either... (a) getting a list of databases attached (using attached command), or (b) Finding the database name used for any given table name name) For instance: If I have a statement "select * from fred", is there a way I can find out what database "fred" is on, or at least f

Re: [sqlite] OOo/SQLite, searching for a developer

Have you looked at http://www.ch-werner.de/sqliteodbc/dba-sqlite-sdbc.html Eddy On Tue, 2004-09-28 at 22:25, M. Fioretti wrote: > On Fri, Aug 20, 2004 11:40:16 AM +0100, Sophie Gautier > ([EMAIL PROTECTED]) wrote: > > Hi all, > > > > This is my first mail here,

Re: [sqlite] Begin transaction at RESERVED lock level?

I would suggest a dummy update or insert just after the BEGIN TRANSACTION that does not do anything meaningful, just creates the RESERVED lock. On Sat, 2004-09-25 at 00:30, b.bum wrote: > Is there a way to do a 'begin transaction' directly at the RESERVED > locking level? > > A typical usage pat

Re: [sqlite] Lock files....

On Fri, 2004-09-24 at 16:50, Ara.T.Howard wrote: > On Fri, 24 Sep 2004, Eddy Macnaghten wrote: > > > There is no way I can guarantee the "nfs" to be good. Also, a mixture of > > Linux and Windows clients need to be allowed for, I do not know how SAMBA > > suppor

Re: [sqlite] Lock files....

On Fri, 2004-09-24 at 14:51, Ara.T.Howard wrote: > On Fri, 24 Sep 2004, Eddy Macnaghten wrote: > > > However, reading the documentation it seems that SQLite is not hot on > > concurrent access through networks, or across platforms, due to the funnies > > of fcntl, or i

[sqlite] Lock files....

Hi there I am new to this list, so please excuse me if this has been covered before, or is not the right place for this. I am writing a development language/environment that has a SQL back end. I am (planning to) put in a number of SQL engine connectivities, and SQLite is ideal for the low end t