[sqlite] Retriving data from SQLite

Hi , I am new bee to SQLite, I am using SQLite in one of the embedded applications. What I wanted to know how to retrive the data from table once the query is exected? how to store the results of the query executed. Regards, Vivek R

[sqlite] re： [sqlite] Retriving data from SQLite

--- Vivek R <[EMAIL PROTECTED]>写道: > Hi , > I am new bee to SQLite, I am using SQLite in one of > the embedded > applications. What I wanted to know how to retrive > the data from table once > the query is exected? how to store the results of > the query executed. > > Regards, > Vivek R >

Re: [sqlite] "SQL Error: near 'Table': Syntax error"

On Jul 26, 2006, at 5:33 PM, Dennis Cote wrote: John Newby wrote: Is there any other names I need to look out for other than the "sqlite_" and "table" that SQLite doesn't like as being a table name that anyone knows of? John, All keywords need to be quoted to use them as identifiers.

[sqlite] Another question about RAM

Hi, all I want to build SQLite on the uc/os-II kernel in an embedded device. Because uc/os-II doesn't provide malloc(), free() to manage memory, instead, it divides the memory into fixed-length blocks and provides OSMemGet() and OSMemPut() to get and put fixed-length memory block. In order to

Re: [sqlite] memory leak

mycmos wrote: > When I use cat /proc/meminfo, I found the MemFree is > decreasing. Does that means some degree memory leak to > Sqlite2.8.17? No. ;) If you run "ps -ef" or "top" you'll see a list of all of the processes running on your machine. How could you associate changes in MemFree with

Re: [sqlite] memory leak

mycmos wrote: > I am using sqlite2.8.17 for linux2.6. My program > is as following: > > int main() > { >sqlite *db; > >while(1){ > db = sqlite_open("./example.db",0777,0); > if(db == 0){ > printf("Could not open database."); > exit(1); > } >

Re: [sqlite] how to use the sqlite command-line specific commands with the dll version

Hi Nuno and John, thanks for the tips, I'll look into it. John On 27/07/06, John Stanton <[EMAIL PROTECTED]> wrote: John Newby wrote: > Hi, I was wondering how I could use the commands specific to the > command-line interface with the dll version. > > The commands I am wanting to use are as

Re: [sqlite] temp_store=1 performance on Mac OS X vs. Windows

On 7/27/06, Joe Wilson <[EMAIL PROTECTED]> wrote: Also, consider running that Task Manager and enable all the column statistics (I/O, threads, VM Faults, Page Faults, etc) to see what's going on while you're running your software. You never know what crazy process might be screwing up your

Re: [sqlite] re： [sqlite] Retriving data from SQLite

On 7/27/06, mycmos <[EMAIL PROTECTED]> wrote: --- Vivek R <[EMAIL PROTECTED]>写道: > Hi , > I am new bee to SQLite, I am using SQLite in one of > the embedded > applications. What I wanted to know how to retrive > the data from table once > the query is exected? how to store the results of >

[sqlite] User function in WHERE clause

Hi, is there a way to create user function similar to LIKE? I'd like to use my function in clause WHERE. E.g. this selection: SELECT * FROM Table WHERE Name MYFUNCTION param Param is integer. Thanks Stan -- View this message in context:

Re: [sqlite] User function in WHERE clause

On 7/27/06, Stan <[EMAIL PROTECTED]> wrote: Hi, is there a way to create user function similar to LIKE? I'd like to use my function in clause WHERE. E.g. this selection: SELECT * FROM Table WHERE Name MYFUNCTION param Param is integer. http://sqlite.org/capi3ref.html#sqlite3_create_function

[sqlite] Re: User function in WHERE clause

Stan <[EMAIL PROTECTED]> wrote: is there a way to create user function similar to LIKE? I'd like to use my function in clause WHERE. E.g. this selection: SELECT * FROM Table WHERE Name MYFUNCTION param Param is integer. Not like this, but you can create a function and use it this way: SELECT

[sqlite] Please unsubscribe me from sqlite

Please unsubscribe me from sqlite From: "Igor Tandetnik" <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: "SQLite" Subject: [sqlite] Re: User function in WHERE clause Date: Thu, 27 Jul 2006 10:47:35 -0400 Stan <[EMAIL PROTECTED]> wrote: is there a way to

[sqlite] Please unsubscribe me from sqlite

Please unsubscribe me from sqlite From: Peter van Dijk <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: Re: [sqlite] "SQL Error: near 'Table': Syntax error" Date: Thu, 27 Jul 2006 08:44:59 +0200 On Jul 26, 2006, at 5:33 PM, Dennis Cote wrote: John

[sqlite] Please unsubscribe me from sqlite

Please unsubscribe me from sqlite From: mycmos <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org CC: Vivek R <[EMAIL PROTECTED]> Subject: [sqlite] re£º [sqlite] Retriving data from SQLite Date: Thu, 27 Jul 2006 15:31:24 +0800 (CST) --- Vivek R <[EMAIL

RE: [sqlite] Re: User function in WHERE clause

> -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 7:48 AM > To: SQLite > Subject: [sqlite] Re: User function in WHERE clause > > Stan <[EMAIL PROTECTED]> wrote: > > is there a way to create user function similar to LIKE? > > I'd like to

RE: [sqlite] Please unsubscribe me from sqlite

Send e-mail to [EMAIL PROTECTED] to unsubscribe > -Original Message- > From: prabhu kumaravelu [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 7:53 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Please unsubscribe me from sqlite > > > Please unsubscribe me from sqlite

[sqlite] Re: Re: User function in WHERE clause

Robert Simpson <[EMAIL PROTECTED]> wrote: -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Not like this, but you can create a function and use it this way: SELECT * FROM Table WHERE MYFUNCTION(Name, param) Actually with a userdef function, SELECT * FROM Table WHERE

Re: [sqlite] User function in WHERE clause

"Robert Simpson" <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > > Sent: Thursday, July 27, 2006 7:48 AM > > To: SQLite > > Subject: [sqlite] Re: User function in WHERE clause > > > > Stan <[EMAIL PROTECTED]> wrote: > > > is there a

Re: [sqlite] Please unsubscribe me from sqlite

prabhu kumaravelu uttered: Please unsubscribe me from sqlite Try sending an email to this address: [EMAIL PROTECTED] And stop spamming the list. From: "Igor Tandetnik" <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: "SQLite" Subject: [sqlite]

Re: [sqlite] retrieving integers and long

Ah! That helps. At least I have a hint. Thanks for the pointer. -- wyan On Jul 26, 2006, at 4:07 PM, John Stanton wrote: Wyan wrote: I'm calling sqlite3_column_type() to get the type, and, for a number (20), it returns SQLITE_INTEGER. I'm guessing this covers int, long, and long

Re: [sqlite] UTF8

Cesar David Rodas Maldonado wrote: > I wanted to ask how can i know if a given text is UTF8 or ISO-8859-1? Well, there might be a way if you only want to know if the text is UTF-8 or ISO-8859-1 (it means that you already know that is one is the other). There are some invalid UTF-8 sequences. If

RE: [sqlite] User function in WHERE clause

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 8:33 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] User function in WHERE clause > > "param MYFUNCTION Name" is equivalent to > "MYFUNCTION(Name, param)" onoly if

[sqlite] Project

Now i have another question! Is any way to serialize all the dates given a preference to SELECT and delay the insert and update. I am building a Small Library in C & SQLite that will be under GPL , is something like Lucene. Please help me how to give a preference to SELECT and a delay to INSERT

[sqlite] invite to OSCAMP SQLite discussion in E146

Richard Hipp, and anyone else now at OSCON, Sorry for the late notice, but starting at 1:30pm today and possibly through to 5pm (to 3:15 at least) is a discussion on SQLite in E146, the OSCAMP room. You are invited to attend. While I didn't create the session, I will be participating. Hoping

[sqlite] Re: Project

If a SQLite Db is LOCKED can i exec an TRIGER?

[sqlite] Problem parsing comments from SQL?

Hi, I've run into a weird situation where SQLite seems to not like in-line comments depending on where they are placed. I'm using the following: DOS CLP 3.3.6 Best to show via an example: If I have the following DDL/DML: -- BEGIN TRANSACTION;

RE: [sqlite] Enabling SQLITE_ENABLE_MEMORY_MANAGEMENT on Visual Studio.Net

You'll have to change that in the makefile before building the "target_source" code, which means you'll need Linux or a similar build environment on Windows. I don't think you want to do that anyway. MS's memory handlers don't like that at all. For proof (once you get it enabled) put this into

[sqlite] sqlite using whole-file (not byte-range) locking

I'm interested in using SQLite with AFS (the Andrew FileSystem). Unlike NFS, AFS has solid, reliable support for *whole-file* advisory locking across the network. AFS does some very sophisticated caching, so an SQLite database in AFS accessed by a single reader/writer would be very efficient. A

RE: [sqlite] Enabling SQLITE_ENABLE_MEMORY_MANAGEMENT on Visual Studio.Net

Hello Brandon: Thanks for your replay. Can you tell me what directive you use in the make file in Linux to enable that. I am trying to reduce the memory usage of SQL. DO you have any ideas about how I can do that on Windows (other thank using SQLITE_ENABLE_MEMORY_MANAGEMENT ) Thanks