Re: [sqlite] pragma vs select for introspection

Darren Duncan wrote: > Wols Lists wrote: >> Dunno how well that approach translates into a relational engine, >> because Pick has several very non-relational quirks (every "row" MUST >> have a primary key, the dictionary DEscribes, not PREscribes the FILE, >> etc etc). > > Can you say more about

Re: [sqlite] pragma vs select for introspection

Wols Lists wrote: > On 12/12/10 00:29, Darren Duncan wrote: >> Nonsense. An information schema is a *good* thing, and is generally the >> *best* >> tool for introspecting a database. It lets you use all the power features >> you >> have when querying data, anything a SELECT can do, and you

Re: [sqlite] R: R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

What does it mean? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] pragma vs select for introspection

On 12/12/10 00:29, Darren Duncan wrote: > Petite Abeille wrote: >> On Dec 11, 2010, at 3:48 PM, Simon Slavin wrote: >> >>> Section 21 of the (SQL92) standard. >> Yes, the notorious information schema: > Nonsense. An information schema is a *good* thing, and is generally the > *best* > tool for

[sqlite] R: R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

Hi, tried but unfortunately it doesn't runs. The window application running under Wine hasn't direct access to the absolute path. Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Per conto di Sylvain Pointeau Inviato: domenica 12

Re: [sqlite] R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

... and if you use the "unix-dotfile" as the VFS name in your open call. Does it work? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

>Argh. Any chance of trying it with something other than Vista ? I don't know it's definitely the problem, I'm just allergic to Vista. ;-)) I agree with you. I connected now the Mac to a Window XP 2002 sp3. The same lock problem remains. >One stage of that process is defeating the locking

Re: [sqlite] R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

On 12 Dec 2010, at 8:31pm, Marco Turco wrote: >> What OS (including version) is the host computer running ? > Windows Vista Business sp2 Argh. Any chance of trying it with something other than Vista ? I don't know it's definitely the problem, I'm just allergic to Vista. >> How is Wine

[sqlite] R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

>The situation you're having a problem with ... am I right in saying that the application with problems is a Windows application running inside the Wine layer ? Yes. >What OS (including version) is the host computer running ? Windows Vista Business sp2 >What OS (including version) is the client

Re: [sqlite] R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

On 12 Dec 2010, at 7:58pm, Marco Turco wrote: > this problem appear only in accessing the sqlite database from Mac OS X on a > Windows shared disk. The situation you're having a problem with ... am I right in saying that the application with problems is a Windows application running inside the

Re: [sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk

On Sun, 12 Dec 2010 20:09:49 +0100, "Marco Turco" wrote: >Hi all, > >I am having a problem running my Window Sqlite app on Mac OS X with Wine >emulator. > >It runs well in local but when I try to access to a network disk hosted on >Windows XP then a lock error appears.

[sqlite] R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

Hi, this problem appear only in accessing the sqlite database from Mac OS X on a Windows shared disk. On full Windows networks and also on Mac OS X in local all runs fine. I tried with the oplock enable and disable on the Window server but the Sqlite db always remains locked from the Mac. I have

Re: [sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk

On 12 Dec 2010, at 7:09pm, Marco Turco wrote: > I am having a problem running my Window Sqlite app on Mac OS X with Wine > emulator. > > It runs well in local but when I try to access to a network disk hosted on > Windows XP The Wine emulator is an excellent emulator but it doesn't correctly

Re: [sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk

Le 12. 12. 10 20:09, Marco Turco a écrit : > Hi all, > > I am having a problem running my Window Sqlite app on Mac OS X with Wine > emulator. > > It runs well in local but when I try to access to a network disk hosted on > Windows XP > > then a lock error appears. > > I checked on internet

[sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk

Hi all, I am having a problem running my Window Sqlite app on Mac OS X with Wine emulator. It runs well in local but when I try to access to a network disk hosted on Windows XP then a lock error appears. I checked on internet about this and as I know Sqlite at this moment doesn't

Re: [sqlite] Inserting data using a compound SELECT

On 12 Dec 2010, at 5:39pm, George Roberge wrote: > And the "why" of this particular query: I don't know any better...LOL. > I'm tooling around with the database as I read my SQL books, and try > experiments on the fly. Eventually I'll try to piece together a nice > functioning GUI or a

Re: [sqlite] Inserting data using a compound SELECT

YES, that was it, thank you! It was a simple issue of the word "values" and the addition of the extra parentheses. I can see it now: the two SELECTS in parentheses are the equivalent of the "values" that would be entered. Looks simple after seeing it. Maybe I should have taken a step back

Re: [sqlite] Inserting data using a compound SELECT

Ah, yes, I'm sorry: I mistyped. I have "titleID" and "artistID" in that table. Puneet Kishor wrote: > > > George Roberge wrote: >> Greetings, all. >> >> I'm having trouble getting an insert statement to function properly, and >> am not sure if it is me, or this isn't supposed to be done. >>

Re: [sqlite] Inserting data using a compound SELECT

Quoth Igor Tandetnik , on 2010-12-12 10:30:24 -0500: > Make it > > INSERT INTO "cast" (titleID, castID) > VALUES > ((SELECT titleID FROM titles WHERE title = 'Alien'), > (SELECT artistID FROM artists WHERE lastname = 'Weaver')); > > Note the added VALUES

Re: [sqlite] Inserting data using a compound SELECT

Drake Wilson wrote: > INSERT INTO "cast" (titleID, castID) >((SELECT titleID FROM titles WHERE title = 'Alien'), > (SELECT artistID FROM artists WHERE lastname = 'Weaver')); Make it INSERT INTO "cast" (titleID, castID) VALUES ((SELECT titleID FROM titles

Re: [sqlite] Inserting data using a compound SELECT

Quoth George Roberge , on 2010-12-12 09:49:13 -0500: > I get into trouble when I attempt to add the extra field: insert into > cast (titleID, castID) select titleID from titles where title='Alien' > select artistID from artists where lastname='Weaver'; There's two INSERT

Re: [sqlite] new user

> I couldn't understand, development environment is 32-bit version. However, > production environment is 64-bit version. > I think that's the problem. As I read somewhere on the mailing list you need to set flags in sqlite for 64bit system. But I can be wrong. I also think there were a similar

Re: [sqlite] Inserting data using a compound SELECT

George Roberge wrote: > Greetings, all. > > I'm having trouble getting an insert statement to function properly, and > am not sure if it is me, or this isn't supposed to be done. > > This is not the complete database, but to keep this issue simple: > > I have three tables: > > artists (artistID

[sqlite] new user

Dear sir or madam: I am new user of sqlite. I developed application in asp.net 3.5 and it works perfect in development environment. However, After i deploy my project in windows server 2008 IIS 7.0, It throws an error message. A message contain "Unable to load DLL 'sqlite3': The specified

[sqlite] Inserting data using a compound SELECT

Greetings, all. I'm having trouble getting an insert statement to function properly, and am not sure if it is me, or this isn't supposed to be done. This is not the complete database, but to keep this issue simple: I have three tables: artists (artistID integer, lastname text) contains 1,

Re: [sqlite] WAL index in memory - multiple connections

Hi, since in memory index file is already implemented (WAL_HEAPMEMORY_MODE), I think that adding locks when needed will add the support for single process multithreaded programs. Am I wrong? Yoni. On 10/12/2010 5:32 PM, Pavel Ivanov wrote: >> Perhaps using async VFS mode would better suit

Re: [sqlite] WAL index in memory - multiple connections

Hi, > Such application needs custom VFS designed specifically for its needs I Believe that a good library should be as robust as possible, and SQLite is very good at being robust. This is the reason you can find SQLite almost anywhere, from mobile devices, desktop applications and web sites.

Re: [sqlite] SQLite crashes due to invalid pointer

On Sun, Dec 12, 2010 at 3:28 AM, Wanadoo Hartwig < hartwig.wiesm...@wanadoo.nl> wrote: > Hi, > > sorry, but I thought that there would have been an automatic conversion to > a float. The comparison is not 1 but a floating point literal like 1.0. > I'm thinking you are making other assumptions as

Re: [sqlite] pragma vs select for introspection

On 12 Dec 2010, at 10:38am, Petite Abeille wrote: > All in all, I'm all for a pragmatic implementation of Section 21 in SQLite. I see what you did there. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] pragma vs select for introspection

On Dec 12, 2010, at 1:29 AM, Darren Duncan wrote: >> On Dec 11, 2010, at 3:48 PM, Simon Slavin wrote: >> >>> Section 21 of the (SQL92) standard. >> >> Yes, the notorious information schema: > > Nonsense. An information schema is a *good* thing, and is generally the > *best* > tool for

Re: [sqlite] SQLite crashes due to invalid pointer

Hi, sorry, but I thought that there would have been an automatic conversion to a float. The comparison is not 1 but a floating point literal like 1.0. Am 12.12.2010 um 03:49 schrieb Richard Hipp: > On Sat, Dec 11, 2010 at 7:07 PM, Wanadoo Hartwig < > hartwig.wiesm...@wanadoo.nl> wrote: > >>