[sqlite] Windows dll - Export Symbol

it using the dumpbin utility. But the dll downloaded from www.sqlite.org exports symbols. How can I build the dll correctly? Thanks, Lloyd ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

Re: [sqlite] Deserialize a WAL database file

On Fri, Mar 1, 2019 at 4:09 PM Simon Slavin wrote: > On 1 Mar 2019, at 10:27am, Lloyd wrote: > > > I am able to serialize, deserialize and prepare a SQL query against the > rollback database. When I do the same against the WAL database file, the > 'prepare' statement

[sqlite] Deserialize a WAL database file

bHandle, "main", mem, sz, sz,SQLITE_DESERIALIZE_READONLY) != SQLITE_OK){//error} char* Query = "select * from test"; sqlite3_stmt *statement = nullptr; int res=sqlite3_prepare_v2(dbHandle, Query, strlen(Query), , 0); //res is 1 for WAL Thanks, Lloyd

[sqlite] sqlite3_deserialize - Any chance for failure?

LITE_DESERIALIZE_READONLY); if (RetSqlite != SQLITE_OK) throw std::exception("sqlite3 db open fialed"); sqlite3_stmt *statement = nullptr; string Query = "select content,dateAdded,lastModified FROM moz_annos"; if (sqlite3_prepare_v2(dbHan

Re: [sqlite] Open and query sqlite db in a buffer

> > I see Richard already pointed out that you can create a connection to a > strictly in-memory DB which doesn't touch a file, and then Deserialize to > it. Just to emphasize, if you can make that work, it is definitely worth > it. From my experience, making the VFS will easily sink around 30

Re: [sqlite] Open and query sqlite db in a buffer

> > > Do what you want, but remember you can always create a valid database > connection using sqlite3_open(":memory:", ) and then do the > sqlite3_deserialize(). > > Thank you Richard, I didn't know that it can be done this way. ___ sqlite-users mailing

Re: [sqlite] Open and query sqlite db in a buffer

> > Only https://www.sqlite.org/draft/c3ref/deserialize.html comes to mind, > and that's brand new and assumes the buffer comes from the companion > serialize. Not sure it's release in 3.24 yet. Google finds it in the Draft > only. --DD Deserialize cannot solve my problem as it needs a valid db

Re: [sqlite] Open and query sqlite db in a buffer

> > > But I imagine you had a more specific question in mind - please ask > exactly what you would like to know, and make sure to include all the > details what we need to know to be able to give answers or advice that > somewhat resemble the truth. > > (Is the buffer a queried cursor? a part of

[sqlite] Open and query sqlite db in a buffer

Hi, I have a "buffer" containing data read from a file-based sqlite database. Is there any possibility for processing this "buffer" to query the data? Thanks, Lloyd ___ sqlite-users mailing list sqlite-users@mailingl

Re: [sqlite] Issue with entity framework

DB first worked for me. But I didn't find it documented that code first wont work. On Tue, Aug 30, 2016 at 7:06 PM, grégoire saint-ellier < greg.stell...@gmail.com> wrote: > Thank you for your answer. So wich approach should I use ? DB first? Code > First ? > > Regards > > 2016-08-30 14:08

Re: [sqlite] System.Data.SQLite

19, 2016 at 6:02 PM, Lloyd <lloydkl.t...@gmail.com> wrote: > Hi, > > I am trying to use SQLite with EntityFramework6 on a .Net application. > > I have referred the documentation, created the app.config file as > specified in the documentation. When I

[sqlite] System.Data.SQLite

e based on my entity classes? I couldn't find any tutorial on using System.Data.SQLite with Entity Framework. Any hint/help/a link to tutorial is greatly appreciated Thanks, Lloyd ___ sqlite-users mailing list sqlite-users@mailingl

[sqlite] Sqlite .Net Entity Framework support

32-bit Windows (.NET Framework 4.6)". sqlite-netFx46-setup-bundle-x86-2015-1.0.102.0.exe. But it doesn't seem to support EF. Thanks a lot, Lloyd ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-

Re: [sqlite] Which SQLite API return SQLITE_BUSY?

Thanks Jay for your detailed reply. I would be more happy if the SQLite documentaion include the error codes each function can return. Thanks a lot, Lloyd - Original Message - From: "Jay A. Kreibich" <j...@kreibi.ch> To: "General Discussion of SQLite Da

Re: [sqlite] order of select result

Thanks Swithun. I dont have any supportive column in table to issue "order by". Can it be achieved by issuing an "ordr by" query on "row_id" (used by sqlite internaly)? Thanks, Lloyd > Hello > > L> Lets assume that we have a very simple without an

[sqlite] order of select result

Hi, Lets assume that we have a very simple without any indexing or constraints. Now we have inserted some data to the table. When we do a simple "select" query, is it guranteed that the rows will be retrieved in the same order as they are inserted? Thanks a lo

[sqlite] Which SQLite API return SQLITE_BUSY?

Hi, Which are all the type of SQLite APIs can return SQLITE_BUSY? sqlite3_open_v2 sqlite3_prepare_v2 sqlite3_step sqlite3_finalize sqlite3_bind_blob sqlite3_column_int Thanks, Lloyd __ Scanned and protected by Email scanner

Re: [sqlite] sqlite3_step returns sqlite_busy

So it means we can have mor than one valid db handle? Thanks, Lloyd - Original Message - From: "Pavel Ivanov" <paiva...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, July 07, 2010 6:40 PM Subject: R

Re: [sqlite] EXTERNAL: sqlite3_step returns sqlite_busy

want it to return the data always. (Even if the database is locked, I am ready to wait and open it) You men to handle the BUSY by waiting for some time and trying to execute sqlite3_step? Thanks a lot, Lloyd __ Scanned and protected by Email scanner

[sqlite] sqlite3_step returns sqlite_busy

hreads are obtaining the DB handle at the same time using sqlite_open - with wrtie permission- is it possible?) I have tried compiling the application with both -DSQLITE_THREADSAFE=2 and -DSQLITE_THREADSAFE=1. Any hint would be very helpful... Thanks a lot, Lloyd __

Re: [sqlite] View - What happens internally

Thank you Igor and Dan. Now I am clear about the concept. On Sat, 28 Feb 2009 20:07:45 +0530, Dan <danielk1...@gmail.com> wrote: > > On Feb 28, 2009, at 8:44 PM, Lloyd wrote: > >> >> Hi, >> >> When we create a view what happens internally in sqlite?

[sqlite] View - What happens internally

base would require more memory. Thanks, Lloyd __ Scanned and protected by Email scanner ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL question, probably stuipid but ...

To escape "'" use cosecutive "'" , i.e "''" On Wed, 18 Feb 2009 10:32:28 +0530, J. R. Westmoreland wrote: > I can't remember how to escape a "'" in a string. > > My statement looks something like: > > "insert . values ('DAY'S AVE' .); > > > It's been a long day. > > Thanks in

Re: [sqlite] Updating only the last raw

Thank you very much Dan. On Fri, 2008-10-17 at 14:10 +0700, Dan wrote: > On Oct 17, 2008, at 1:43 PM, Lloyd wrote: > > > Hi, > > > > Lets assume a table having following data > > > > No. NameAddress > > > > 1

[sqlite] Testing sqlite

Hi, In the test folder of sqlite3 source distribution I saw so many test scripts. How can I run these tests? I am curious to know the various testing methods used in sqlite. Thanks, Lloyd __ Scanned and protected by Email scanner

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

Hi Punkish, I think after installing the library, and making the path entry in the /etc/ld.so.conf (If it is not there), simply running the "ldconfig" command will serve your need. Regards, Lloyd On Thu, 2008-03-13 at 12:09 -0500, P Kishor wrote: > I am not at all conversant

Re: [sqlite] 64bit on 32bit machine

Thank you very much Andrew. Regards, Lloyd On Thu, 2007-07-12 at 23:37 -0500, Andrew Finkenstadt wrote: > Use sqlite_int64 as your type. That typedef supports 'long long' or 'signed > __int64' or whatever the compiler environment needs. > > --a > > On 7/12/07, Lloyd <[EM

Re: [sqlite] Re: 64bit on 32bit machine

Thanks Igor :) Regards, Lloyd On Fri, 2007-07-13 at 00:18 -0400, Igor Tandetnik wrote: > Lloyd wrote: > > So, SQLite doesn't have its own features to manage this? So I must be > > able to perform 64bit operations on a 32bit machine using C. How can I > > do that? or h

Re: [sqlite] 64bit on 32bit machine

Thanks Andy. So, SQLite doesn't have its own features to manage this? So I must be able to perform 64bit operations on a 32bit machine using C. How can I do that? or how to declare a 64bit integer on a 32bit machine? Thanks, Lloyd On Thu, 2007-07-12 at 15:06 -0500, Andrew Finkenstadt wrote

[sqlite] 64bit on 32bit machine

Hi, Can I know how SQLite performs 64bit operations (addition, multiplication, division) on 32bit machine? Thank you very much, Lloyd __ Scanned and protected by Email scanner

[sqlite] reserved chars in insert

Hi, I would like to know the reserved characters which cannot be used in inserting a string.. (like ",',...). Thanks in advance, Lloyd __ Scanned and protected by Email sc

Re: [sqlite] Copying the content of a table to another table

doesn't seem to work for me alter table x add (v3 number,v4 number); Regards, Lloyd On Tue, 2007-06-05 at 11:25 +0530, Kirrthana M wrote: > Hi all, > I have created a table with two columns c1 and c2 and inserted some > values into,in future i may include some additional colu

Re: [sqlite] Monitor Queries

just replace libsqlite3.so with your own. How should be my own libsqlite3.so looking like. Can you explain the way I should make the library? I would like to learn this technique :) > If it is statically linked and has -g symbols, use gdb. > If it's stripped, x86 assembler

Re: [sqlite] A suggestion

In old versions it work... But in new versions (3.* I think) its not working! On Wed, 2007-05-09 at 12:11 +0200, Peter van Dijk wrote: > On 9-mei-2007, at 11:06, A.J.Millan wrote: > > > As a suggestion, and even in the risk to abuse of Mr Hipp's > > patience. Would > > it be possible to

Re: [sqlite] Sqlite 14 (cant open database)

Thank you Arjen. I would consider your alternative or I will go for some other file system. (Because I would have to handle files larger than 2GB) Thanks and Regards, Lloyd On Thu, 2007-05-03 at 13:52 +0200, Arjen Markus wrote: > Lloyd wrote: > > >This error occurs only on FAT 32

Re: [sqlite] Sqlite 14 (cant open database)

system on my Linux) Thanks and Regards, Lloyd On Wed, 2007-04-25 at 10:13 +0530, Lloyd wrote: > Hi, > I am working on Redhat EL4, with sqlite3. In my application (written in > C++ and wxWidgets, and I use wxSqlite3 wrapper) there a module which > will be called repeatedly which i

[sqlite] Sqlite 14 (cant open database)

) for short period of time (10 mins -small input) am not getting any error. But when it runs for around 1 hour (large input) I am getting an error called sqlite 14, cant open database ! What could be the reason for this particular error? Thanks and regards, Lloyd

Re: [sqlite] Data structure

Thank you John Stanton. This has opened new doors for me, and think it would be helpful for others in the list too.. Thanks and Regards Lloyd On Thu, 2007-04-12 at 12:34 -0500, John Stanton wrote: > We use a very simple data retrieval method for smallish datasets. The > data is just

Re: [sqlite] Data structure

Would anybody suggest a good tool for performance measurement (on Linux) ? On Wed, 2007-04-11 at 10:35 -0500, John Stanton wrote: > You might discover that you can craft a very effective memory > resident > storage system using a compression system like Huffman Encoding and > an > index method

Re: [sqlite] Data structure

Thank you all. I got so many new ideas from your replies. Now I just have to derive the best solution for me, thanks :) Lloyd On Wed, 2007-04-11 at 10:35 -0500, John Stanton wrote: > You might discover that you can craft a very effective memory > resident > storage system using a co

Re: [sqlite] Data structure

On Wed, 2007-04-11 at 10:00 -0500, P Kishor wrote: > I think, looking from Lloyd's email address, (s)he might be limited to > what CDAC, Trivandrum might be providing its users. > > Lloyd, you already know what size your data sets are. Esp. if it > doesn't change, putting the

Re: [sqlite] Data structure

y experts ;) (like bloom filter) Thanks, Lloyd __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Data structure

tructure sizing 70 bytes and the key field would be of size maximum of 20 bytes). (I will see, what is memory based hash) Thanks and Regards, Lloyd __ Scanned and protecte

[sqlite] Data structure

in the data structure and it will be searched millions of times. The data is not in any ordered form. Thanks for your information, Lloyd __ Scanned and protected by Email scanner

[sqlite] What would you suggest?

, I will have millions of integers to store and retrieve) What the real data is a network packet dump file. I want to store and retrieve the location of each packet, in order to make packet reading a faster way from a very large dump file (in terms of GBs) Thanks, Lloyd

[sqlite] matching only part of a string

Hi, My table contains a text field called Name. Let the data be Name --- Abc abcd AB cab def I want to selcct all the rows which contains the term ab (not case sensitive). How can I do this? Thanks in advance, Lloyd - This email was sent using

Re: [sqlite] C

Thanks John. yes, I am familiar with this way, I just wanted to know whether there is a way to make bit field array. From Igor's reply I understood that it is not possible in C. Thanks, Lloyd On Thu, 2007-03-01 at 09:48 -0600, John Stanton wrote: > Use a mask to load from and store to your

Re: [sqlite] Re: C

Thanks Igor. This is what I wanted. On Thu, 2007-03-01 at 07:46 -0500, Igor Tandetnik wrote: > Lloyd wrote: > > How can I make an array of bit fields? something like, using the 16 > > bits > > of a short as an array of bits > > You can't. But, if you can use C++

[sqlite] C

of a short as an array of bits Thanks, Lloyd Sorry for asking irrelevant question to this list. __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Abuse of the SQLite website

Would not adding verification cause a problem for those include the downloading of sqlite in bash/make files of certain apps. Lloydie T - Original Message - From: "Rich Shepard" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 30, 2007 2:50 PM Subject: Re:

[sqlite] A little help with count

I wish to create a query where I do a number of counts on the same table but with different filters. ie: count(id) as numrows count(id) as inrows where direction = 'In' count(id) as outrows where direction = 'Out' Could I do the above in a single query? | id | date | direction |

Re: [sqlite] LEMON

Ethereal make use of Lemon On Fri, 2006-12-29 at 11:08 -0400, Cesar Rodas wrote: > Where can i find a tutorial with examples of how to use LEMON parser... > because i need to build interpreted language > > Thanks to all __ Scanned and protected by Email

RE: [sqlite] Time zone conversion

Thanks Karthick. My code too works fine... (I made a small typo mistake in query, which executed silently) But I guess your method is the right one. Regards, Lloyd On Wed, 2006-12-20 at 16:54 +0530, Karthick V - TLS , Chennai wrote: > Let the time zone given by user > +0530 > &g

[sqlite] Time zone conversion

is shown) what could be the reason? Is there any better way for me to achieve the same result? Thanks and Regards, Lloyd __ Scanned and protected by Email scanner - To unsubscribe, send

Re: [sqlite] Query generation

Thanks, 0=0 works well enough for me. (This hint is what I wanted) Thanks again, Lloyd On Wed, 2006-12-06 at 10:00 +0100, Mario Frasca wrote: > Lloyd wrote: > > >select a from mytable where (b=0) and > > > >and this is a syntax error. > > > > > you're

[sqlite] Query generation

there in no where clause to add, so my final query become select a from mytable where (b=0) and and this is a syntax error. Is there any option to add a null clause after the 'and' ? Thanks, Lloyd __ Scanned and protected by Email scanner

Re: [sqlite] Re: Re: ip2long

I feel little difficulty in understanding what you actually want (I thing the same is for all...). So could make it more clear? so that your problem can be solved fast! Thanks, Lloyd. Yes, they are stored as INTEGER. and the conversion outside sqlite > is simple. However, I still n

Re: [sqlite] Re: Re: ip2long

The way I am dealing with this is... First convert the IP to a 32bit integer. (In the system it will represented as a 32bit integer) Store it in the database. Perform the comparison operations on this stored data. Thanks, Lloyd On Mon, 2006-12-04 at 22:07 -0500, Igor Tandetnik wrote: > Ke

[sqlite] Selection Time

Hi, How much time can it take to perform 2000 selection queries on the same database ? Mostly the result set will contain only 1 raw. Is there is any way to improve the selection speed? Thanks, Lloyd __ Scanned and protected by Email scanner

Re: [sqlite] Music Files

I think, Through the command line mode it is impossible. For this you have to write a program which open and reads the (binary) data in file and inserts it to the sqlite database. Thanks, Lloyd On Tue, 2006-11-28 at 13:36 +0800, LuYanJun wrote: > Can anybody give a simple exam

Re: [sqlite] Journal file not getting deleted

Are you forgetting to close the database? On Fri, 2006-11-24 at 02:03 -0800, mithin wrote: > Hi, > > In my application I am using SQLite 3 c++ API. Everything works fine till my > application is open. While doing any transaction a journal file is created. > Once I close the app, the journal file

Re: [sqlite] Database Locked

Thanks Clay Dowling, Yes there is a function for fanalize function. Now the problem is solved. On Tue, 2006-11-14 at 08:02 -0500, Clay Dowling wrote: > Lloyd, > > You need at some point to call the sqlite3_finalize function. I don't use > wxSqlite, but if it's not handled by th

Re: [sqlite] Database Locked

, Lloyd. On Wed, 2006-11-15 at 14:46 +0530, Lloyd wrote: > Hi, > I have opened a database, created tables and inserted data to it in a > single transaction. Then I have closed the data base. Then I reopened > the database and tried to update the table entries. But it throws an

[sqlite] Database Locked

wrapper class. All these are performed from a single program. Thanks, Lloyd. __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] PHP5 with SQLite3

- Original Message - From: "Rúben Lício" <[EMAIL PROTECTED]> To: Sent: Wednesday, November 08, 2006 1:03 PM Subject: [sqlite] PHP5 with SQLite3 Are you connecting correctly to the database. Which version of sqlite3 was the database created in. I beleive

Re: [sqlite] Date and time

Thanks Craig Morrison. Now I got the idea clearly. On Wed, 2006-11-08 at 00:55 -0500, Craig Morrison wrote: > Lloyd wrote: > > select datetime(1162961284,'unixepoch','localtime'); > > > > 2006-11-08 10:18:04 > > > > The result is correct. > &g

[sqlite] Date and time

it accurately. (as in the localtime). Which way can I prefer ? Thanks, Lloyd. __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Retrieving date

the accurately converted date and time ? Thanks, Lloyd. __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Date data type

Thanks gg and Craig Morrison for your informative reply. I would like to know one more thing, can I use these date and time functions with comparison operators? Will they return the correct result or as per the string comparison rules? Thanks again, Lloyd. On Tue, 2006-11-07 at 04:25 -0500

[sqlite] Date data type

Hi, How can I manage date and time using sqlite? [Do I have to do it outside sqlite?] Thanks, Lloyd. __ Scanned and protected by Email scanner - To unsubscribe, send email

Re: [sqlite] sqlite backup from the program.

Whether your database creation error solved? what was the problem? - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Friday, November 03, 2006 2:18 PM Subject: [sqlite] sqlite backup from the program. Hi All, How to take a backup of the

Re: [sqlite] sqlite backup from the program.

SQLite database is stored as a normal file in the disk. Why dont you use Operating System calls to back up the file? - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Friday, November 03, 2006 2:18 PM Subject: [sqlite] sqlite backup from the program.

Re: [sqlite] Memory Usage

I don't know whether I am right in this perspective. Just to know whether sqlite is causing the high memory usage, comment the commands (statements) related to sqlite and check the memory status. Thanks, Lloyd. On Mon, 2006-10-30 at 12:45 +, Nuno Lucas wrote: > On 10/30/06, Ben Clew

Re: [sqlite] Regarding sqlite3_open

Which platform are you using? Do you (application) have enough permission to create files in the specified location ? On Sat, 2006-10-28 at 16:19 +0530, [EMAIL PROTECTED] wrote: > Hi All, > > I am using sqlite3_open() in my program. It is returning > error code 14(file not found)

Re: [sqlite] Memory Usage

Most probably it will be a memory leak in your program. We must release the dynamically allocated memory ourselves. So check whether you are forgetting to do that. Most probably that leak will be happening inside some loops or repeatedly calling functions. On Fri, 2006-10-27 at 17:00 +0100, Ben

Re: [sqlite] reg:SqliteDB file

the full path of the file. It will work fine. Thanks, Lloyd. On Fri, 2006-10-27 at 12:17 +0530, sandhya wrote: > Hi, >Is it possible to refer db file from other than the Current project > location.If Yes,How can we refer(tell) the location of the DB file to the > project.Pl

Re: [sqlite] Re: number problem with 3.2.8

I did try number literal >10 but mad no difference. I will rebuild the database row as an integer. Lloyd - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" <sqlite-users@sqlite.org> Sent: Thursday, October 26, 2006 12

[sqlite] number problem with 3.2.8

I am using sqlite 3.2.8 which is included in PHP5.1. I seem to be having a problem doing queries where with '>' to search a number. for instance if I do the following select ring_time fron calls where ring_time > '10'; I get the following results 3 6 3 6 3 6 2 3 3 3 2 etc. Why? This row is

[sqlite] hexadecimal

Hi list, can I insert a hexadecimal value to an integer field? if yes How can do that? Thanks, Lloyd __ Scanned and protected by Email scanner - To unsubscribe, send email

Re: [sqlite] encrypted file

Sorry for my mistake. I was creating database using sqlite3 API and trying to open it with sqlite command line client version 2.7 Thanks a lot. Lloyd. On Wed, 2006-10-25 at 11:51 +0530, Lloyd wrote: > Thanks for your informative reply. > > I would like to know, whether I can open a

Re: [sqlite] encrypted file

uot;: file is encrypted or is not a database . How can I open the database using sqlite command line? ] Thank you very much. Lloyd. On Tue, 2006-10-24 at 11:02 +, [EMAIL PROTECTED] wrote: > Lloyd <[EMAIL PROTECTED]> wrote: > > Hi List, > > Whether the data base whic

[sqlite] encrypted file

to use the interface provided by the sqlite. How can I open the database in SQLite ? Thanks, Lloyd. __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL

Re: [sqlite] insertion time

Hi, When this 3M inserts are performed, it takes 130 more seconds compared to the actual application running time. The actual application run time is 20 seconds but when this 3M inserts are performed it takes 150 seconds. Is there any way to reduce the time ? Thnaks, Lloyd. On Mon, 2006

[sqlite] insertion time

a combined primary key of text and integer. Is this the expected performance? Can I improve it anyway? (I am using the wxSQLite wrapper class) Thanks, Lloyd. __ Scanned and protected by Ema

[sqlite] Inserting uniquely

to throw error] How can I get this done? Thanks, Lloyd. __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] See table structure

Hi List, In SQLite, to see the table structure which command can I use? (as in Oracle's desc ) Thanks, Lloyd __ Scanned and protected by Email scanner - To unsubscribe, send

Re: [sqlite] wxSqlite- Long Insertion time

> Are these inserts in 1 transaction or 1000? Yes it is in 1000 transactions. For me consistancy, atomicity...(ACID) are not a problem. But the speed of operation is major constraint. How can I achieve speed in insertion cases like this? Thanks for your informative reply. Lloyd. On

[sqlite] wxSqlite- Long Insertion time

, Lloyd. __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Regarding sqlite3_exec

I think you are asking for this... This is the case when we use wxSQLite3. wxSQLite3ResultSet result = samp.ExecuteQuery(wxT("select name,age from test")); while (result.NextRow()) { cout << (const char*)(result.GetString(0).mb_str()) << result.GetInt (1)<< endl; } On Fri, 2006-10-06

[sqlite] Installing Library

Hi All, I have downloaded the SQLite library (sqlite-3.3.7.so.gz) from the homepage. But I don't know how to install it. Please help me. My Redhat Enterprise Linux machine runs on i386 architecture. Thanks and Regards, Lloyd. __ Scanned and protected

Re: [sqlite] SQLite under linux

Thanks everybody, I have downloaded the library RPM from http://rpm.pbone.net/ and the library name is libsqlite-3.2.1-1.i386.rpm It may be useful for newbie like me... and did as what you said. And works fine... Thanks, Lloyd. On Wed, 2006-09-27 at 10:08 +0200, Markus Hoenicka wrote

Re: [sqlite] SQLite under linux

ease help me.. If I am dealing with the wrong file, please let me know from where I can get the needed installable library. Thanks for your clear and patient reply. Thanks, Lloyd. __ Scanned and protected by E

Re: [sqlite] SQLite under linux

/sqlite-3.3.7 How can I solve this? From where do I can get an installable copy if the SQLite library for linux? Thanks, Lloyd. On Tue, 2006-09-26 at 13:17 +0100, Lloyd Thomas wrote: > Hi Lloyd, > I had exactly the same problem being new to C++. These are the > steps I took. You

[sqlite] SQLite under linux

omplete type and the error continues How can I resole this. Please help me... Can I use the library alone without recompiling the whole sqlite? (Thus it will be easier for me to distribute my application along with sqlite) Thanks and regards, Lloyd. On Tue, 2006-09-26

Re: [sqlite] SQLite under linux

Hi Lloyd, I had exactly the same problem being new to C++. These are the steps I took. You may find that the library files may be in a folder where RH does not expect them to be. Try 'whereis libsqlite3.so' to locate. I can't remember where the default lib folder is. you will need

[sqlite] SQLite under linux

te library and how to install it in my machine. Awaiting for your kind reply. Thanks and regards, Lloyd. __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Compiling PHP5 in order to use SQLite3

I far as i know you compile with php5-pdo-sqlite, but this was only tested on debian. Last time i looked this supports sqlite 3.2.8 and you have to use php's pdo functions and not the sqlite functions which only work with v2. - Original Message - From: "Michael Young" <[EMAIL

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

I am still having some problems compiling my code. I suspect it maybe something to do with my app not linking (ld) with sqlite libraries, but I do not know how to do this or it could be something else. Can you advise? -

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

Nearly there just a couple of outstanding issues any help apreciated Error:-- make: Warning: File `logger.cpp' has modification time 45 s in the future g++ -c -Wall -O -g logger.cpp -o logger.o logger.cpp: In function `void* start_one_channel(void*)':

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

--- Lloydie T - Original Message - From: "Teg" <[EMAIL PROTECTED]> To: "Lloyd Thomas" <sqlite-users@sqlite.org> Sent: Sunday, September 10, 2006 12:47 AM Subject: Re[2]: [sqlite] A lillte help adding sqlite to a c program Hello Lloyd,

  1   2   >