Re: [sqlite] Help Installing SQLite on a Windows 8.1 PC

On 6 Jul 2016, at 8:29pm, Krista M Whipple wrote: > I have downloaded the two 64-bit Windows files on my Windows 8.1 PC, but I > cannot get SQLite to install on my PC. > > > > Any help or directions would be greatly appreciated, I understand the source of your

Re: [sqlite] Help Installing SQLite on a Windows 8.1 PC

Hi Krista, Regarding: I have downloaded the two 64-bit Windows files on my Windows 8.1 PC, Are you referring to sqlite.exe and maybe sqlite.dll ? Regarding: but I cannot get SQLite to install on my PC. I'm not sure I understand you. Maybe you could rewrite this in form of something

[sqlite] Help Installing SQLite on a Windows 8.1 PC

Dear SQLite Users, I am in a Predictive Analytics course which requires the use of SQLite. I am not a developer or an analyst and have zero hands on experience with working with software for databases. I have downloaded the two 64-bit Windows files on my Windows 8.1 PC, but I cannot get

Re: [sqlite] Help with SQLite error message

https://discussions.apple.com/message/15712311#15712311 -- Marco Bambini http://www.sqlabs.com On Sep 5, 2011, at 10:46 PM, Lani Gonzales wrote: > Dear Technical Support: > > Please help me remove this error message: > > The procedure entry point sqlite3_wal_checkpoint could not be

[sqlite] Help with SQLite error message

Dear Technical Support: Please help me remove this error message: The procedure entry point sqlite3_wal_checkpoint could not be located in the dynamic link library SQlite3.dll Please kindly send instructions on how to resolve this problem. Thank you, Lani Gonzales

Re: [sqlite] Help with SQLite and VB2010 Express

answer them, if I can help. And if I know of another Forum that answers the better will provide it. So do not be so sanctimonious. Guy -Original Message- From: Simon Slavin Sent: Monday, January 10, 2011 5:49 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Help

Re: [sqlite] Help with SQLite and VB2010 Express

answer them, if I can help. And if I know of another Forum that answers the better will provide it. So do not be so sanctimonious. Guy -Original Message- From: Simon Slavin Sent: Monday, January 10, 2011 5:49 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Help

Re: [sqlite] Help with SQLite and VB2010 Express

Thank you for the reply, it makes more sense now. I'll go to the forum on System.Data.SQLite. BobK --- On Mon, 1/10/11, Simon Slavin <slav...@bigfraud.org> wrote: From: Simon Slavin <slav...@bigfraud.org> Subject: Re: [sqlite] Help with SQLite and VB2010 Express To: "G

Re: [sqlite] Help with SQLite and VB2010 Express

On 10 Jan 2011, at 9:34pm, Bob Keeland wrote: > Obviously I don't know what I'm doing with SQLite so I'll ask the question > that shows my ignorance. > What is the difference between what can or should be asked on this list and > what should be directed to the System.Data.SQLite forum? The

Re: [sqlite] Help with SQLite and VB2010 Express

to you cause now every thing works fine now Be patient, Guy -Original Message- From: Bob Keeland Sent: Monday, January 10, 2011 4:34 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Help with SQLite and VB2010 Express Obviously I don't know what I'm doing with SQLite so

Re: [sqlite] Help with SQLite and VB2010 Express

Obviously I don't know what I'm doing with SQLite so I'll ask the question that shows my ignorance. What is the difference between what can or should be asked on this list and what should be directed to the System.Data.SQLite forum? They seem to have duplicate purposes - helping people who are

Re: [sqlite] Help with SQLite and VB2010 Express

You really don't need to run the msi. You can download the binary package and added the dlls as references and start using the dataprovider. In the future, this sort of question should be asked in the System.Data.SQLite forum. On Mon, Jan 10, 2011 at 12:10 PM, Bob Keeland

[sqlite] Help with SQLite and VB2010 Express

I've been struggling with how to use SQLite with Visual Basic2010 Express. VB2010 Express does not work with Microsoft Access (which I've used in the past) and so I have to use SQL. I don't feel that I need the capabilities of Microsoft SQL Server and so I've been looking at SQLite and MySQL.

[sqlite] Help building SQLite project, please

This isn't directly related to SQLite, but rather to how I am converting the source code into a DLL. I hope someone here can help me understand what's happening. It appears that my previous problem was caused by some problem within the ancient, unbelievably slow and ugly library we have been

Re: [sqlite] Help with SQLite Query

Igor, That has worked perfectly. Thankyou very much for your assistance. Regards Andrew -- View this message in context: http://www.nabble.com/Help-with-SQLite-Query-tp24297858p24305860.html Sent from the SQLite mailing list archive at Nabble.com

Re: [sqlite] Help with SQLite Query

JokBoy wrote: > I have tried your query and I don't get any rows returned. Any ideas > why it wouldn't work? If you tried it against the database file you showed in your original post, note that you have MOEData.Date in different format from Criteria.StartTime_crit and EndTime_crit. Recall

Re: [sqlite] Help with SQLite Query

Igor, I have tried your query and I don't get any rows returned. Any ideas why it wouldn't work? Regards Andrew -- View this message in context: http://www.nabble.com/Help-with-SQLite-Query-tp24297858p24298529.html Sent from the SQLite mailing list archive at Nabble.com

Re: [sqlite] Help with SQLite Query

JokBoy wrote: > Basically, I would like to be able to query one table based on > criteria entered into another table. > > I have attached an excel file with a couple of hours of monitoring > data, the 10 minute data has been interpolated to give minute answers > (as

[sqlite] Help with SQLite Query

age in context: http://www.nabble.com/Help-with-SQLite-Query-tp24297858p24297858.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Help! Excel-->SQLite -- getting numbers to behave like numbers!

I'm fiddling with SQLite running on Mac OSX and am using the Firefox extension SQLite Manager ... I have some Excel tables I'd like to re-create in SQLite. It looks easy to me: 1. Save your Excel table as a .csv file. 2. In SQLite Manager used DATABASE-->IMPORT ... and follow the directions.

Re: [sqlite] Help with Sqlite

On Wed, 2008-08-20 at 09:36 +0100, Brandon, Nicholas (UK) wrote: > > I'm using the install of Firefox that comes with the Wubi > > install of Linux. I like sqlite, but have a little problem. > > Perhaps someone can help. > > > > When I add a new record to a database, an entry screen comes >

Re: [sqlite] Help with Sqlite

Thanks to all for the guidance. Yes, I'm using it as a FF extension. I'll have to look further in the proper forms. Thanks again. On Wed, 2008-08-20 at 11:20 +0530, Graeme wrote: > As the previous rely said, this is not a sqlite problem. I am not sure what > it > is because Firefox by itself

Re: [sqlite] Help with Sqlite

> I'm using the install of Firefox that comes with the Wubi > install of Linux. I like sqlite, but have a little problem. > Perhaps someone can help. > > When I add a new record to a database, an entry screen comes > up with my fields and the ability to enter the new record. > But the

Re: [sqlite] Help with Sqlite

As the previous rely said, this is not a sqlite problem. I am not sure what it is because Firefox by itself does not seem to allow direct editing of the sqlite databases it uses (are you using some extension?). I suggest you ask on the Ubuntu forums. Also, look for the issue in the Wubi

Re: [sqlite] Help with Sqlite

On 8/20/08, Jeffrey Needle <[EMAIL PROTECTED]> wrote: > I'm using the install of Firefox that comes with the Wubi install of > Linux. I like sqlite, but have a little problem. Perhaps someone can > help. You don't have any problem with SQLite. Your problem is with whatever this Wubi thing is

[sqlite] Help with Sqlite

I'm using the install of Firefox that comes with the Wubi install of Linux. I like sqlite, but have a little problem. Perhaps someone can help. When I add a new record to a database, an entry screen comes up with my fields and the ability to enter the new record. But the information I type

Re: [sqlite] Help for sqlite syntax

Hi Igor, Thank you very much, it working :-) Cheers, 2008/2/13, Igor Tandetnik <[EMAIL PROTECTED]>: > > "li yuqian" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL PROTECTED] > > now my sql working, but result different mysql result. > > > > sqlite> SELECT t.variable, t.value,

Re: [sqlite] Help for sqlite syntax

Hi Igor, Thanks for your kind of help :-) now my sql working, but result different mysql result. 1. mysql: --- mysql> SELECT t.variable, t.value, d.value state FROM `globals` t JOIN (SELECT x.variable, x.value FROM globals x WHERE x.variable LIKE 'OUTDISABLE\_%') d ON

Re: [sqlite] Help for sqlite syntax

li yuqian <[EMAIL PROTECTED]> wrote: > now i try follow sql > SELECT t.variable, t.value, ifnull(d.value, ''||'off') state FROM > globals t LEFT JOIN globals d ON (substr(t.variable,5) = > substr(d.variable,12) and t.variable LIKE 'OUT\_%' ESCAPE '\' and > d.variable LIKE 'OUTDISABLE\_%' ESCAPE

Re: [sqlite] Help for sqlite syntax

Hi Igor, we want porting the FreePBX(freepbx.org) to our project www.astfin.org, Actually i don't know this substr(t.value,1,0) means :-( now i try follow sql SELECT t.variable, t.value, ifnull(d.value, ''||'off') state FROM globals t LEFT JOIN globals d ON (substr(t.variable,5) =

Re: [sqlite] Help for sqlite syntax

"li yuqian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > i follow the documents for sqlite function and change the sql to: > --- > SELECT t.variable, t.value, ifnull(d.value, > group_concat(substr(t.value,1,0),'off')) > state FROM globals t LEFT JOIN globals d ON

Re: [sqlite] Help for sqlite syntax

Hi Igor, thank you very much. i follow the documents for sqlite function and change the sql to: --- SELECT t.variable, t.value, ifnull(d.value, group_concat(substr(t.value,1,0),'off')) state FROM globals t LEFT JOIN globals d ON (substr(t.variable,5) = substr( d.variable,12) and

Re: [sqlite] Help for sqlite syntax

"li yuqian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > i tried your sql, but get a error: > - > SQL error: no such function: substring > In SQLite, it's named substr. Check the documentation to make sure it expects the same parameters as substring in MySQL

Re: [sqlite] Help for sqlite syntax

Hi Igor, Thanks for your reply. i tried your sql, but get a error: - SQL error: no such function: substring is something wrong? thanks 2008/2/12, Igor Tandetnik <[EMAIL PROTECTED]>: > > "li yuqian" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL PROTECTED] > > i am a

Re: [sqlite] Help for sqlite syntax

"li yuqian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > i am a newbie of sqlite3, we want porting the Freepbx(freepbx.org) to > our > project www.astfin.org, the freepbx can support sqlite3, but not very > well, > now i got a problem about sqlite3 > - > SELECT

Re: [sqlite] Help for sqlite syntax

uot;li yuqian" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Cc: "Dimitar Penev" <[EMAIL PROTECTED]>; "Mark" <[EMAIL PROTECTED]> > Sent: Tuesday, February 12, 2008 1:56 PM > Subject: [sqlite] Help for sqlite syntax > > > >

Re: [sqlite] Help for sqlite syntax

Could you just use ORDER BY 1 ? best regards -- radzi -- - Original Message - From: "li yuqian" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Cc: "Dimitar Penev" <[EMAIL PROTECTED]>; "Mark" <[EMAIL PROTECTED]> Sent: Tuesday, Febru

[sqlite] Help for sqlite syntax

Hi guys, i am a newbie of sqlite3, we want porting the Freepbx(freepbx.org) to our project www.astfin.org, the freepbx can support sqlite3, but not very well, now i got a problem about sqlite3 - SELECT t.variable, t.value, d.value state FROM `globals` t JOIN (SELECT

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

On 10/17/07, Uma Krishnan <[EMAIL PROTECTED]> wrote: > Yes. Makes sense (not to cache query results for embedded apps). > So what is cached. Just dirty pages? or are raw tables cached when > queried? SQLite implements a tables and indices as btrees over a pager layer. The pager layer caches

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

PostgreSQL has the capability of storing pre-compiled SQL so that it can be reused and have data bound to the compiled statement. I have not looked at the mechanics, but it would be of interest and educational for you to see the PostgreSQL approach. Sqlite does cache the results of a query.

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

Yes. Makes sense (not to cache query results for embedded apps). So what is cached. Just dirty pages? or are raw tables cached when queried? Thanks Uma Scott Hess <[EMAIL PROTECTED]> wrote: On 10/17/07, Trevor Talbot wrote: > On 10/17/07, Uma Krishnan wrote: > > One other question, when a

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

On 10/17/07, Trevor Talbot <[EMAIL PROTECTED]> wrote: > On 10/17/07, Uma Krishnan <[EMAIL PROTECTED]> wrote: > > One other question, when a query is issued, does SQLite cache the results, > > so that future queries can be processed off the cache (I think not) > > Like the "query cache" in some

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

On 10/17/07, Uma Krishnan <[EMAIL PROTECTED]> wrote: > As far as I know, Postgres does not have a virtual engine. I could be wrong. It's not a virtual machine style, where it has a specific instruction set; instead it's more like a graph of operations. Execution means walking a graph instead of

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

On 10/17/07, Uma Krishnan <[EMAIL PROTECTED]> wrote: > One other question, when a query is issued, does SQLite cache the results, so > that future queries can be processed off the cache (I think not) Like the "query cache" in some other databases? No. SQLite does have a cache of database

RE: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

Regarding: "... when a query is issued, does SQLite cache the results, so that future queries can be processed off the cache (I think not) " ... = P.S. And I should certainly have mentioned the sqlite items below: http://sqlite.org/pragma.html PRAGMA cache_size=

RE: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

Regarding: "... when a query is issued, does SQLite cache the results, so that future queries can be processed off the cache (I think not) " Hi Uma, In effect, powerful caching effects *do* occur because of the disk cache provided by modern operating systems. Since the hard disk operations

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

Thanks John and Joe for your responses. As far as I know, Postgres does not have a virtual engine. I could be wrong. One other question, when a query is issued, does SQLite cache the results, so that future queries can be processed off the cache (I think not) Thanks Uma John Stanton <[EMAIL

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

Moreover, is it typical to have an implementation like VDBE in other databases as well? This is a common approach and has been used for a very long time. For example we used it in products produced during the 1980s because producing a virtual machine and a compiler for its

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

--- Uma Krishnan <[EMAIL PROTECTED]> wrote: > I'm a student trying to understand SQLite for my DB project. There are a > couple of aspects that > I don't quite understand: > 1) VDBE. I see how the vdbe stack is created using VDBEAddOp etc. But once > the code is > generated, I don't see when

[sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

Hello, I'm a student trying to understand SQLite for my DB project. There are a couple of aspects that I don't quite understand: 1) VDBE. I see how the vdbe stack is created using VDBEAddOp etc. But once the code is generated, I don't see when it's executed. Moreover, is it typical to have an

Re: [sqlite] HELP! DDD & SQLite

Hello Ken, I just realized that sqlite3 is a bash program. When I do ddd sqlite3, it gives an error. So when I need to load a program, thru GUI interface I load main.o. But I guess that's not right What should I do? Thanks Uma Ken <[EMAIL PROTECTED]> wrote: you

Re: [sqlite] HELP! DDD & SQLite

you need to set a breakpoint. hit the continue button in DDD. That will allow execution of the code and allow the attached program to continue. It would be better however to run ddd as follows: ddd sqlite3 Then set a breakpoint. Then run the program inside the ddd that way you can first set

[sqlite] HELP! DDD & SQLite

Hello I'm trying to debug SQLite (to understand the code). But e when I attach the process sqlite3, the sqlite3 terminal hangs (ie would not accept any user inputs) till I detach. Can someone please tell me what I'm doing wrong Thanks Uma Cory Nelson <[EMAIL PROTECTED]> wrote: On

Re: [sqlite] Help In SQLIte

Looks like you haven't include the Sqlite library for the linker. Ashish Singh wrote: Hello SQLite Users I am using SQlite 2.8.17 version I am trying to compile this piece of code on linux system when i type the command "g++ test.cpp" I get the following error which is at the bottom of

[sqlite] Help In SQLIte

> > > > Hello SQLite Users > > I am using SQlite 2.8.17 version > > I am trying to compile this piece of code on linux system when i type the > > command "g++ > test.cpp" > > > > I get the following error which is at the bottom of this mail. > > If anybody could which is the library file I

Re: [sqlite] HELP for SQLite MEMORY test.

On 5/18/06, Manzoor Ilahi Tamimy <[EMAIL PROTECTED]> wrote: DEAR All , I want to use SQLite for our project, the main thing is that the database contains millions of Records. So for the faster operations on the db I want to use the SQLite as in-memory database. I have compared the

[sqlite] HELP for SQLite MEMORY test.

DEAR All , I want to use SQLite for our project, the main thing is that the database contains millions of Records. So for the faster operations on the db I want to use the SQLite as in-memory database. I have compared the results of SQLite as Disk db and as Memory db but I

Re: [sqlite] help with sqlite command

Dennis Cote wrote: To get every N'th row after deletions you need some way to assign a series of integers to the result rows. The easiest way I can think of is to create a temporary table from your initial query. Then you can use the modulus operator to select every N'th record from that table

Re: [sqlite] help with sqlite command

On 3/27/06, Uma Venkataraman <[EMAIL PROTECTED]> wrote: > I would like to delete n records from a table, based on some condition. Can > some one please let me know how to do this with sqlite? http://sqlite.org/lang_delete.html

Re: [sqlite] help with sqlite command

I would like to delete n records from a table, based on some condition. Can some one please let me know how to do this with sqlite? Thanks

Re: [sqlite] help with sqlite command

Thanks Dennis..that seems to do the trick... - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, March 27, 2006 2:46 PM Subject: Re: [sqlite] help with sqlite command Jay Sprenkle wrote: I believe rowid i

Re: [sqlite] help with sqlite command

Too bad sqlite doesn't have Oracle's ROWNUM: "Pseudo-Columns While not actual datatypes, Oracle supports several special-purpose data elements. These elements are not actually contained in a table, but are available for use in SQL statements as though they were part of the table. ROWNUM For

Re: [sqlite] help with sqlite command

On 3/27/06, Dennis Cote <[EMAIL PROTECTED]> wrote: > Jay, > > The rowid is the key from the btree used to store the table rows. It is > not generated dynamically. Ah. Thanks! Learn something new every day.

Re: [sqlite] help with sqlite command

Jay Sprenkle wrote: I believe rowid is assigned dynamically to the result set so it would give a different set of results for a different query. Jay, The rowid is the key from the btree used to store the table rows. It is not generated dynamically. To get every N'th row after

Re: [sqlite] help with sqlite command

o it: SQLite version 3.2.1 Enter ".help" for instructions sqlite> .read /tmp/x.sql CREATE TABLE x (i INTEGER PRIMARY KEY, t TEXT); INSERT INTO x VALUES (1, 'one'); INSERT INTO x VALUES (2, 'two'); INSERT INTO x VALUES (3, 'three'); INSERT INTO x VALUES (4,

Re: [sqlite] help with sqlite command

- Original Message From: Uma Venkataraman <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, March 27, 2006 11:07:18 AM Subject: Re: [sqlite] help with sqlite command Hi Jay, Thanks for your reply. I am trying the command select * from mytable where row_id = row_

Re: [sqlite] help with sqlite command

> Thanks for your reply. I am trying the command > > select * from mytable where row_id = row_id % 5 > > from sqlite browser and it says, no such column row_id.. Also I replaced > row_id with rowid and it gave only the first 4 records from my table. My > other concern is I will be deleting and

Re: [sqlite] help with sqlite command

, 2006 1:56 PM Subject: Re: [sqlite] help with sqlite command On 3/27/06, Uma Venkataraman <[EMAIL PROTECTED]> wrote: Hi All, I need to be able to select the TOP N rows from a table. How do i do it = select * from mytable limit 5 with sqlite? Also how does one select EVERY Nth row

Re: [sqlite] help with sqlite command

On 3/27/06, Uma Venkataraman <[EMAIL PROTECTED]> wrote: > Hi All, > > I need to be able to select the TOP N rows from a table. How do i do it = select * from mytable limit 5 > with sqlite? Also how does one select EVERY Nth row from a table? use modulus operator for that: select * from

[sqlite] help with sqlite command

Hi All, I need to be able to select the TOP N rows from a table. How do i do it = with sqlite? Also how does one select EVERY Nth row from a table? Thanks

[sqlite] Help with SQlite locking in version 3.08

Hi.. We had a question regarding the lock data structures in the file os_unix.c. The data structure is the lockInfo structure. The fields in the lock info structure are struct lockInfo { struct lockKey key; /* The lookup key */ int cnt; /* Number of SHARED locks held */ int