Re: [sqlite] Help on DELETE FROM...

; Advanced Analytics Directorate > Northrop Grumman Information Systems > > > > > From: sqlite-users-boun...@sqlite.org on behalf of Marcus Grimm > Sent: Mon 1/17/2011 6:17 AM > To: General Discussion of SQLite Database > Subject: EXTERNAL:[sqlit

Re: [sqlite] Help on DELETE FROM...

Directorate Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org on behalf of Marcus Grimm Sent: Mon 1/17/2011 6:17 AM To: General Discussion of SQLite Database Subject: EXTERNAL:[sqlite] Help on DELETE FROM... Hi List, sorry for not being

Re: [sqlite] Help on DELETE FROM...

the Bugs From: Marcus Grimm <mgr...@medcom-online.de> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Mon, January 17, 2011 5:47:45 PM Subject: [sqlite] Help on DELETE FROM... Hi List, sorry for not being very sqlite specifi

[sqlite] Help on DELETE FROM...

Hi List, sorry for not being very sqlite specific here but I would like to have an advice on a delete operation for which I can't find the right sql command. Currently I do it on C programming level using a loop but I think there must be a better sql way. Anyway, here is the story: I have a

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.

Re: [sqlite] help with optimazing sql query

On 1/6/2011 5:54 PM, gasperhafner wrote: > Igor Tandetnik wrote: >> >> On 1/6/2011 5:25 PM, gasperhafner wrote: >>> Igor Tandetnik wrote: select ID_DISH, sum(ID_INGREDIENT not in (2, 4)) stillMissing from x group by ID_DISH having stillMissing != count(*) order by

[sqlite] Help: Sqlite3 memory leaks & Invalid write errors from valgrind tool

Hi, It would be very helpful, if you can provide us some info on the below issues (Memory leak & Invalid write errors, found from valgrind tool on Sqlite3 library usage). Executed some Select & Update queries. Don't know if these issue got fixed in the latest sqlite3 library- Sorry for the

Re: [sqlite] Help with query

>From: Drake Wilson Sun, November 14, 2010 7:50:19 AM >> SELECT COUNT(Offset_Y) FROM (SELECT DISTINCT Offset_Y FROM Tiles WHERE >>PatternID >> >> = 1); >> >> Is it possible to have a single query that will generate a row for each >> PattenID, COUNT(Offset_Y) combination? >

Re: [sqlite] Help with query

Quoth Jeff Archer , on 2010-11-13 11:20:51 -0800: > And I can get the number of unique Y offsets in a pattern like so: > > SELECT COUNT(Offset_Y) FROM (SELECT DISTINCT Offset_Y FROM Tiles WHERE > PatternID > = 1); > > Is it possible to have a single query that

[sqlite] Help with query

I have a table CREATE TABLE [Tiles] ( TileID    INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, PatternID INTEGER NOT NULL REFERENCES [Patterns] DEFERRABLE INITIALLY DEFERRED, Offset_X  REAL NOT NULL DEFAULT 0.0, Offset_Y  REAL NOT NULL DEFAULT 0.0 ); And I can get the number of

Re: [sqlite] Help registering custom tokenizer

:34 AM To: sqlite-users@sqlite.org Subject: [sqlite] Help registering custom tokenizer I am currently working on writing a custom tokenizer for use with a FTS3 indexed database. I believe I have written the new tokenizer module correctly and am just missing something with registering the tokenizer

[sqlite] Help registering custom tokenizer

I am currently working on writing a custom tokenizer for use with a FTS3 indexed database. I believe I have written the new tokenizer module correctly and am just missing something with registering the tokenizer with the database. To verify this I copied the simple_tokenizer1.c to a new file

Re: [sqlite] Help: Required help/guidance for the segmentation fault in sqlite3 library to proceed further...

On Fri, Sep 24, 2010 at 9:50 AM, Pavel Ivanov wrote: > Apparently you are calling sqlite3_free twice on the same statement > pointer. Try to add assigning to NULL after freeing and checking for > NULL before freeing. > The second step (checking for NULL before freeing) is

Re: [sqlite] Help: Required help/guidance for the segmentation fault in sqlite3 library to proceed further...

On Sep 23, 2010, at 9:57 PM, Borra, Kishore Babu wrote: > Hi, > > I require some help in getting the fix for some memory corruption > issues, occurring while using the sqlite3 library. It would be very > helpful, if you can guide to fix the below issues or atleast provide > some info on

Re: [sqlite] Help: Required help/guidance for the segmentation fault in sqlite3 library to proceed further...

Apparently you are calling sqlite3_free twice on the same statement pointer. Try to add assigning to NULL after freeing and checking for NULL before freeing. Pavel On Thu, Sep 23, 2010 at 10:57 AM, Borra, Kishore Babu wrote: > Hi, > > I require some help in getting

[sqlite] Help: Required help/guidance for the segmentation fault in sqlite3 library to proceed further...

Hi, I require some help in getting the fix for some memory corruption issues, occurring while using the sqlite3 library. It would be very helpful, if you can guide to fix the below issues or atleast provide some info on this, to minimize the memory corruption, occurring mostly while

Re: [sqlite] Help with database corruption?

___ > > From: sqlite-users-boun...@sqlite.org on behalf of Filip Navara > Sent: Mon 8/23/2010 7:43 AM > To: General Discussion of SQLite Database > Cc: d...@hwaci.com > Subject: EXTERNAL:Re: [sqlite] Help with database corruption? > > > > I can

Re: [sqlite] Help with database corruption?

From: sqlite-users-boun...@sqlite.org on behalf of Filip Navara Sent: Mon 8/23/2010 7:43 AM To: General Discussion of SQLite Database Cc: d...@hwaci.com Subject: EXTERNAL:Re: [sqlite] Help with database corruption? I can now reliably corrupt the database using standard commands. An SQL

Re: [sqlite] Help with database corruption?

I can now reliably corrupt the database using standard commands. An SQL script can be downloaded at the address below that creates a database and then stresses it until a corruption happens. http://www.emclient.com/temp/sqlite_corrupt_log.zip Please help fix the problem or at least confirm that

[sqlite] Help with database corruption?

Hello, is there anybody willing to help analyze corrupted database for possible bug in SQLite? It is a database file taken from one of our test machines and it is only few days old at most. The database file was only ever accessed with SQLite 3.7.0.1. It has page size of 1024, WAL mode,

Re: [sqlite] help with huge bulk inserts

On 17 Aug 2010, at 12:16am, Maciej Kurczewski wrote: > I'm using sqlite as a data storage backend for my log parsing application. > I have around 7 milion - equals to 1GB of binary log (up to 35 mln.) > records to insert at once, I'm using prepared statments, huge > transactions, and optimised

[sqlite] help with huge bulk inserts

Hello, I'm using sqlite as a data storage backend for my log parsing application. I have around 7 milion - equals to 1GB of binary log (up to 35 mln.) records to insert at once, I'm using prepared statments, huge transactions, and optimised (I hope) pragma settings: PRAGMA journal_mode = OFF;

Re: [sqlite] Help with simple query

Brilliant. Thanks a million. It's moments like these when I love the internet. Igor Tandetnik wrote: > > zipforbrains wrote: >> I have two tables, one with bank accounts, one which holds groupings of >> those >> accounts, as follows: >> Table Accounts >> aName >>

Re: [sqlite] Help with simple query

zipforbrains wrote: > I have two tables, one with bank accounts, one which holds groupings of those > accounts, as follows: > Table Accounts > aName > aBalance > > Table GroupMembers > gName > aName > > What SQL query would total the account balances (aBalance) for all the

[sqlite] Help with simple query

I have two tables, one with bank accounts, one which holds groupings of those accounts, as follows: Table Accounts aName aBalance Table GroupMembers gName aName What SQL query would total the account balances (aBalance) for all the accounts (aName) associated with each group (gName)? Each

Re: [sqlite] Help with complex UPDATE question

of peterwinson1 Sent: Fri 7/23/2010 9:37 PM To: sqlite-users@sqlite.org Subject: EXTERNAL:Re: [sqlite] Help with complex UPDATE question Jim, I see what you mean. Would it be faster then if I read the from the table, do the math in a program, and then insert the values back into the table? Or would

Re: [sqlite] Help with complex UPDATE question

Jim, I see what you mean. Would it be faster then if I read the from the table, do the math in a program, and then insert the values back into the table? Or would it faster to amend the table as you suggest and use SQL UPDATE? I wonder. Jim Morris-4 wrote: > > AYou must add additional data

Re: [sqlite] Help with complex UPDATE question

You must add additional data to the rows so you can refer to them unambiguously. table1 (KEY, COL1, ord) 0, 1,1 0, 2,2 1, 3,1 1, 4,2 2, 5,1 2, 6,2 3, 7,1 3, 8,2 On 7/23/2010 12:16 PM, peterwinson1 wrote: > Jim you maybe correct that I don't have enough data to unambiguously identify > the

Re: [sqlite] Help with complex UPDATE question

Jim you maybe correct that I don't have enough data to unambiguously identify the rows. But just in case I was not very clear the first time. What I want to do is take the COL1 values of the first 2 rows [1, 2] and subtract them from the COL1 values, two rows at a time. so [1, 2] - [1, 2],

Re: [sqlite] Help with complex UPDATE question

On 7/23/2010 10:09 AM, Jim Morris wrote: > What you are trying to do is unclear to me. It seems that table1 > doesn't have enough data to unambiguously identify the rows. > > On 7/23/2010 8:03 AM, peterwinson1 wrote: >> Thanks Eric and Alan for your help. I tried to apply your code to my

Re: [sqlite] Help with complex UPDATE question

What you are trying to do is unclear to me. It seems that table1 doesn't have enough data to unambiguously identify the rows. On 7/23/2010 8:03 AM, peterwinson1 wrote: > Thanks Eric and Alan for your help. I tried to apply your code to my problem > and it works to a limited extent because the

Re: [sqlite] Help with complex UPDATE question

Thanks Eric and Alan for your help. I tried to apply your code to my problem and it works to a limited extent because the problem is more complicated than the example I gave in the post. I tries to simplify my exact problem but that didn't work out. So here is the problem that I trying to

Re: [sqlite] Help with complex UPDATE question

On 22/07/10 23:38, peterwinson1 wrote: > > Hello, > > I have a some what complex question about UPDATE. I have the following > table > > table1 (KEY, COL1) > > 0, 1 > 1, 2 > 2, 3 > 3, 4 > > What I would like to do is to UPDATE COL1 by subtracting the COL1 value > where KEY = 0 from the COL1 value

Re: [sqlite] Help with complex UPDATE question

peterwinson1 wrote: > Hello, > > I have a some what complex question about UPDATE. I have the following > table > > table1 (KEY, COL1) > > 0, 1 > 1, 2 > 2, 3 > 3, 4 > > What I would like to do is to UPDATE COL1 by subtracting the COL1 value > where KEY = 0 from the COL1 value of the current

[sqlite] Help with complex UPDATE question

Hello, I have a some what complex question about UPDATE. I have the following table table1 (KEY, COL1) 0, 1 1, 2 2, 3 3, 4 What I would like to do is to UPDATE COL1 by subtracting the COL1 value where KEY = 0 from the COL1 value of the current row so that the result would be. 0, 0 1, 1 2, 2

Re: [sqlite] HELP : sqlite execute low speed in ARM9+Linux embadded system.

On 17 Jun 2010, at 4:47pm, backup wrote: > sprintf(sqlstr,"update db set isSent=1 where ID in (select ID from > db where isSent=0 limit %d);",RECORD_NUM); Can you post the commands used to create the table and any indexes on it ? Simon. ___

[sqlite] HELP : sqlite execute low speed in ARM9+Linux embadded system.

hi, everyone, I program in an embaded system: ARM9 soc S3C2410 +Linux 2.4+sqlite 3.3. All data store in NAND FLASH , the file system is YAFFS . My question is the function "sqlite3_exec(.)" take too many seconds, the following is my source code, please see the "printf" 's

Re: [sqlite] Help with Transaction Error.

On 10 Jan 2010, at 4:56am, Vathir wrote: >I am trying to use SQL Jet within my java application, but I consistently get >the following error when I run this section of code. For some reason I >cannot open this particular database. I can open up a separate database >with in my program, but this

Re: [sqlite] Help with Transaction Error.

On 10 Jan 2010, at 4:56am, Vathir wrote: > I am trying to use SQL Jet within my java application, but I consistently get > the following error when I run this section of code. For some reason I > cannot open this particular database. If you open the database using the command-line tool, do you

[sqlite] Help with Transaction Error.

I am trying to use SQL Jet within my java application, but I consistently get the following error when I run this section of code. For some reason I cannot open this particular database. I can open up a separate database with in my program, but this one always causes the error.

Re: [sqlite] Help with Insert using select

Pavel Ivanov wrote: > Why this doesn't work? > > insert into table (creationdate, modifieddate, mytext, title) > select date('now'), date('now'), "show text", "show title"; It is possible that, if you run this statement at just the wrong moment, the two date('now') calls will produce different

Re: [sqlite] Help with Insert using select

Why this doesn't work? insert into table (creationdate, modifieddate, mytext, title) select date('now'), date('now'), "show text", "show title"; Pavel On Wed, Dec 23, 2009 at 11:24 AM, Christopher Doss wrote: > Hello, I have a table that I'd like to create that needs

[sqlite] Help with Insert using select

Hello, I have a table that I'd like to create that needs calculated data in multiple fields. The columns are: mytext, creationdate, title, modifieddate, etc. etc If I only had one calculated data date, i could do something like insert into table (creationdate, mytext, title) select date('now'),

Re: [sqlite] sqlite help requested to support this requirement

On Fri, Dec 4, 2009 at 8:01 AM, Pronab Ganguly wrote: > Thanks a lot for all help suggestion.Let me know if you have any experience > on file parsing using sqlite. .. SQLite doesn't do any "file parsing." You have to do the file parsing, and then stick the v -- Puneet

Re: [sqlite] sqlite help requested to support this requirement

You don't need any file parsing with SQLite and SQLite is not a file-parsing utility. SQLite is a database engine. It creates file of its own format and parses it without user noticing it. All you have to do is issue necessary SQL commands to work with your database. You definitely need to read

Re: [sqlite] sqlite help requested to support this requirement

Thanks a lot for all help suggestion.Let me know if you have any experience on file parsing using sqlite. -P On Fri, Dec 4, 2009 at 6:15 PM, Pavel Ivanov wrote: > > SQLite is an implementation of SQL. SQL is used to store information in > a way that allows you to look

Re: [sqlite] sqlite help requested to support this requirement

> SQLite is an implementation of SQL. SQL is used to store information in a > way that allows you to look things up more quickly than searching a flat > file. If you can search for data your flat files fast enough to make your > software work acceptably, you do not need SQL and your project

Re: [sqlite] sqlite help requested to support this requirement

On 4 Dec 2009, at 11:50am, Pronab Ganguly wrote: > I am newbie to sqlite.Would like to is sqlite is better than flat file > parsing? > > We have platform specific files of different formats to be read so our > code is complex and difficult for maintenance considering support for > newer

[sqlite] sqlite help requested to support this requirement

Hi All, I am newbie to sqlite.Would like to is sqlite is better than flat file parsing? We have platform specific files of different formats to be read so our code is complex and difficult for maintenance considering support for newer platforms and backward compatibility. We are planning for a

Re: [sqlite] Help me please to optimize sql query

Thank you, Simon! Could you please say me what indexes will be correct? I'm trying CREATE INDEX mgwrInd1 ON mgWordsRelations (id_norm) CREATE INDEX mgwrInd2 ON mgWordsRelations (id_norminrel) CREATE INDEX wfInd1 ON wform (wordForm) CREATE INDEX wfInd2 ON wform (wordNorm) CREATE INDEX wfInd3 ON

Re: [sqlite] Help me please to optimize sql query

Thank you very much! It works well! Igor Tandetnik wrote: > > Try this: > > select wf1.wordForm > from wform wf1 join mgWordsRelations rel on (wf1.wordNorm = > rel.id_norminrel) > join wform wf2 on (rel.id_norm = wf2.wordNorm) > where wf1.ancode = 'someAncode' and wf2.wordForm =

Re: [sqlite] Help me please to optimize sql query

On 15 Nov 2009, at 12:08am, Igor Tandetnik wrote: > select wf1.wordForm > from wform wf1 join mgWordsRelations rel on (wf1.wordNorm = rel.id_norminrel) >join wform wf2 on (rel.id_norm = wf2.wordNorm) > where wf1.ancode = 'someAncode' and wf2.wordForm = 'someWord' > order by random() limit 1;

Re: [sqlite] Help me please to optimize sql query

Unabashed wrote: > I need to execute query > SELECT wordForm FROM Lang.wform WHERE (ancode='someAncode') AND (wordNorm IN > (SELECT DISTINCT id_norminrel FROM mgWordsRelations WHERE id_norm IN (SELECT > wordNorm FROM Lang.wform WHERE wordForm='someWord'))) ORDER BY RANDOM() > LIMIT 1 Try this:

[sqlite] Help me please to optimize sql query

Hello! Nabble is really wonderful resource, because I received answers to all my questions. Sorry now, but I have to ask to help me again (if someone could). I'm not good in sql yet, so if anyone could find a minute to think about optimization of my sql query I'll be very much obliged. I have two

Re: [sqlite] help in understanding sqlite_master output

On Tue, Oct 20, 2009 at 11:50 PM, Andy wrote: > I'm new to sqlite. Just started on a project that comes with a lot of > pre-created tables. > > Trying to understand the data structure, I did: > >>sqlite3 dev.db >>select * from sqlite_master; > > Some of the output of the

[sqlite] help in understanding sqlite_master output

I'm new to sqlite. Just started on a project that comes with a lot of pre-created tables. Trying to understand the data structure, I did: >sqlite3 dev.db >select * from sqlite_master; Some of the output of the above query is a bit confusing to me. I checked out the doc in

Re: [sqlite] Help-using Case in query

how about this select * from TestName where History > 399 and History < 501 the above SQL is saying (in laymans terms) >From the table TestName gather all the column data and display ONLY those rows where data in History column is greater than 399 and is below 501. _OR_ Select ONLY those

Re: [sqlite] Help-using Case in query

yvette roberson wrote: > I am definitely an novice in writing but trying to practice and get > up to speed and would appreciate any help: > > In laymen terms I have a quey that I am trying to write with the > following columns > TestName (where testname '1' = History,

[sqlite] Help-using Case in query

I am definitely an novice in writing but trying to practice and get up to speed and would appreciate any help: In laymen terms I have a quey that I am trying to write with the following columns TestName (where testname '1' = History, TestName '2'=Math, TestName '3'= Western Civilization, TestName

[sqlite] help

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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 inconsistent results and segfault

Thanks Dan much appreciated We are using 3.6.2 (the standard version on our ubuntu machines). We will upgrade to 3.6.16 Regards Pavlos - "Dan Kennedy" wrote: > On Aug 4, 2009, at 4:58 AM, Pavlos Christoforou wrote: > > > Hello all, > > > > We are currently

Re: [sqlite] help with inconsistent results and segfault

On Aug 4, 2009, at 4:58 AM, Pavlos Christoforou wrote: > Hello all, > > We are currently evaluating sqlite for using it as the > base engine for a financial reporting module. We have some > fairly complex queries which yield strange results. We have > tried to isolate the problem below. Please

[sqlite] help with inconsistent results and segfault

Hello all, We are currently evaluating sqlite for using it as the base engine for a financial reporting module. We have some fairly complex queries which yield strange results. We have tried to isolate the problem below. Please see select queries at the end and associated comments which

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

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 MOEData Tab in the excel sheet). This Table of Data

Re: [sqlite] help with a utf-8 error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dinesh B Vadhia wrote: > Hi! I'm using pysqlite in Python 2.5.2 and got the following error [...] > sqlite3.OperationalError: Could not decode to UTF-8 column 'j' with text You should use the pysqlite mailing list

[sqlite] help with a utf-8 error

Hi! I'm using pysqlite in Python 2.5.2 and got the following error File "py", line 120, in ... cursor.execute(sqlquery) sqlite3.OperationalError: Could not decode to UTF-8 column 'j' with text '77395 149900 178104 251956 257906 290771 294739 421322 537670 565626 600208 81 1358 866671

[sqlite] help , testing problem

Hello, I just have a project based on SQLite, and for some reasons, I have to change source code of SQLite. So I have to verify the changed code. I wish TCL Tests can be used to the work, but I don't know how to compile a test dll of SQLite in windows. How can I do it . thanks, :)

Re: [sqlite] help,low RAM problem

You have to configure the page size and cache size (number of pages) to fit your 30K RAM. To be specific: page size * cache size < 30K. 徐中华 wrote: > > > > > hi, > I have a project based on an embedded platform. > the platform just has 30K RAM and a large NAND Flash, > so I want to use

Re: [sqlite] help,low RAM problem

I have used sqlite on a similar platform. I use the GHS Integrity operating system. With a few tweaks I was able to get it to run well. The flash will keep things on the slower side, but I see my inserts (with idexes) taking a little as 0.05 seconds. Queries of 250 out of 10K sorted taking

Re: [sqlite] help,low RAM problem

In my app, I had to adjust the default cache size. This was 2000 pages and caused my app to run out of memory. I dropped it down to 200. You may want to drop it even further. Chris ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] help,low RAM problem

hi, I have a project based on an embedded platform. the platform just has 30K RAM and a large NAND Flash, so I want to use SQLite on this platform. Can SQLite 3.6 be used on this platform . And if it 's possible, how can I configure the SQlite ? Thanks.

Re: [sqlite] Help with SQL and index (or schema?)

On Fri, 27 Mar 2009 18:08:13 +0100, Kees Nuyt wrote: > PRIMARY KEY (filepathid,filename,istarget) Oops, make that PRIMARY KEY (pathid,filename,istarget) -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list

Re: [sqlite] Help with SQL and index (or schema?)

On Fri, 27 Mar 2009 15:53:18 +0100, Jonas Sandman wrote: >Hello, > >I have a database with about 137000 * 2 rows with four columns; >fileid, filename, filepath and istarget. >It's used to determine if two scanned directories are equal so I run a >simply query to get the

Re: [sqlite] help: need help in date conversion

On 1/29/09, venkat karri wrote: > Hi All, > > I have a database where date is stored in the integer format ( eg: > 1125426109) I want the output in mm/dd/ format. can any one tell me the > syntax to convert the date. http://www.sqlite.org/lang_datefunc.html You

[sqlite] help: need help in date conversion

Hi All, I have a database where date is stored in the integer format ( eg: 1125426109) I want the output in mm/dd/ format. can any one tell me the syntax to convert the date. Regards, Venkata ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] help : sqlite database restore

Thanks a lot Donald, These links really helps me a lot... On 1/27/09, Griggs, Donald wrote: > > > > On 1/27/09, Griggs, Donald wrote: > > > > Venkat, > > > > If you have a ".db" file it almost certainly *is* an sqlite database. > > A

Re: [sqlite] help : sqlite database restore

Venkat, Sorry. I really intended to quote page: http://www.sqlite.org/sqlite.html Though http://www.sqlite.org/quickstart.html May be helpful as well. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] help : sqlite database restore

On 1/27/09, Griggs, Donald wrote: > > Venkat, > > If you have a ".db" file it almost certainly *is* an sqlite database. > A great attribute of sqlite databases is that they are contained in a > single file. > > If you're looking for a GUI frontend, they are

Re: [sqlite] help : sqlite database restore

?p=ManagementTools > > Donald > > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of venkat karri > Sent: Tuesday, January 27, 2009 3:25 PM > To: punk...@eidesis.org; General Discussion of SQLite Databa

Re: [sqlite] help : sqlite database restore

g; General Discussion of SQLite Database Subject: Re: [sqlite] help : sqlite database restore This morning I had a meeting with the team and found that we also have a db file, could you please send me the complete syntax to import or restore this .db file

Re: [sqlite] help : sqlite database restore

This morning I had a meeting with the team and found that we also have a db file, could you please send me the complete syntax to import or restore this .db file in sqlite. On 1/27/09, P Kishor wrote: > > On 1/27/09, venkat karri wrote: > > Yes it has

Re: [sqlite] help : sqlite database restore

On 1/27/09, venkat karri wrote: > Yes it has create queries and insert statements in which case, it is a SQL dump. Read up the help on the .read command or the .import command in the command line sqlite3 program. > > > On 1/27/09, Simon wrote: >

Re: [sqlite] help : sqlite database restore

Yes it has create queries and insert statements On 1/27/09, Simon wrote: > > You may want to open the file in a basic text editor to see if it's a > SQL dump. The dump will usually have the queries to create the tables > and insert data into them. > > Simon > > On Tue,

Re: [sqlite] help : sqlite database restore

You may want to open the file in a basic text editor to see if it's a SQL dump. The dump will usually have the queries to create the tables and insert data into them. Simon On Tue, Jan 27, 2009 at 11:57 AM, venkat karri wrote: > Hi Kishor, > > Actually iam working on

Re: [sqlite] help : sqlite database restore

Hi Kishor, Actually iam working on defect tracking migration from trac to qualitycenter, the trac developers have given me this .bak file, the person who has taken this bak file is no longer with the company, so they asked me to restore the .bak file and see the data, I dont know how its been

Re: [sqlite] help : sqlite database restore

On 1/27/09, venkat karri wrote: > Hi > > Iam new to sqlite, I have a database backup copy with extension > trac.db.1.bak. Now iam trying to setup sqlite 3.6.10 on my local machine and > need to import this bak file to my local database and has to view the data > in the

[sqlite] help : sqlite database restore

Hi Iam new to sqlite, I have a database backup copy with extension trac.db.1.bak. Now iam trying to setup sqlite 3.6.10 on my local machine and need to import this bak file to my local database and has to view the data in the table. can any one help me how to restore the database into my local

Re: [sqlite] HELP: prep'ed query ... LF function to return column_isNull??

Jay, I thank you for an inciteful and well considered position piece, and I respond in-line below ... (sorry for the length, but I found it difficult to excise much of the excellent description that you wrote). On Mon, 10 Nov 2008, Jay A. Kreibich wrote: [regretfully elided owing to space

<    1   2   3   4   5   6   7   8   9   >