Manzoor Ilahi Tamimy wrote:
Hello All,
We are Using SQLite for one of our project.
The Database Size is more than 500 MB.
It contain one table and about 10 million Records.
We are facing Problem in the select with single Join. The join is between a
big table and a small table. The small t
Hello All,
We are Using SQLite for one of our project.
The Database Size is more than 500 MB.
It contain one table and about 10 million Records.
We are facing Problem in the select with single Join. The join is between a
big table and a small table. The small table contain records not more t
Is it possible to compile sqlite on embedded visual c 3.0 for wince 2.11
without MFC and TCL/TK on a Symbol PDT7242 barcode scanner.
I have tried with the already preprocessed windows source but keep
getting error with missing header files like assert.h etc.
I am unable to use the dll as it requi
Bud Beacham <[EMAIL PROTECTED]> wrote:
> I cannot find any documentation
> on the SQLite documentation page that explains these functions.
> What other functions exist? What is the syntax? Where can they
> be used in SQL statements? Is there any documentation on these
> functions?
>
http://ww
Bud,
I could well be educated on the point, but I think that this is exactly how
you go about adding functions for use in the SQL.
R,
Christopher L. Smith
Have you pondered the meaning of life today?
From: Bud Beacham <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sql
On 6/18/06, Bud Beacham <[EMAIL PROTECTED]> wrote:
My apologies if I have overlooked it.
I also had trouble finding them first few times, even though I knew
they were there somewhere.
Anyway, here's what you're looking for:
http://www.sqlite.org/lang_expr.html
--
Nemanja Corlija <[EMAIL PROTE
Bud Beacham <[EMAIL PROTECTED]> wrote:
> I have the book SQLite by Chris Newman and it has examples of
> functions embedded within SQL statements.
>
> For example on page 38 the ifnull() function is used.
>
> SELECT code, ifnull(due_date, 'Ongoing') FROM projects;
>
> Also, on page 81 the strftime
Thank you, but I am not looking for C/C++ functions. I am using
Tcl. I am looking for the functions that appear to extend the
SQL syntax. I did not see either of the two functions I
mentioned (ifnull, strftime) on those pages.
bb
--- Christopher Smith <[EMAIL PROTECTED]> wrote:
> The C/C++
The C/C++ documentation can be found here:
http://sqlite.org/capi3ref.html#sqlite3_create_function
For those of us in the mortal category, various wrappers can make life
better. For example,
http://initd.org/pub/software/pysqlite/doc/usage-guide.html#creating-user-defined-functions
HTH,
Chris
I have the book SQLite by Chris Newman and it has examples of
functions embedded within SQL statements.
For example on page 38 the ifnull() function is used.
SELECT code, ifnull(due_date, 'Ongoing') FROM projects;
Also, on page 81 the strftime() function is used.
SELECT strftime('%m/%d/%Y', '20
"Alexey Petrovsky" <[EMAIL PROTECTED]> wrote:
> select e164 from lcr15 except select e164 from lcr16 order by ...
>
> select e164 from lcr15 where e164 not in (select e164 from lcr16) ...
>
> ...
> I thought that those queries provide the same result.
> ...
> Any guess?
>
> Alexey.
It's not neces
[EMAIL PROTECTED] wrote:
> I have a related question. Suppose I have a table containing rows each with
> values and a counter. If the new row is unique in the table it should be
> INSERTed and the counter set to 1; otherwise the counter for the matching
> row should be incremented. It's a classi
Luther Baker <[EMAIL PROTECTED]> wrote:
>
> I have one question - if I make a call to something like
> _sqlite3_column_text16_ and get back a void* - do I need to deallocate
> said memory or is that memory somehow static within the scope of the
> function call and I simply need to COPY it if I
Greetings,
Thank to topic "[sqlite] WHERE clause syntax error" by James W. Walker
I found it somehow relevant to my everyday work.
I have two lists of e.164 codes for two days that may be served by our
VOIP-switch. Someday the ruleset may broke (shorter than expected) and
I need quickly find a d
On 6/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Garrett Rooney" <[EMAIL PROTECTED]> wrote:
> On 6/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > "Garrett Rooney" <[EMAIL PROTECTED]> wrote:
> > > I've been using lemon as the parser generator for ETL
> > > and we've been running
On Sun, Jun 18, 2006 at 01:16:35AM -0400, C.Peachment wrote:
> On Sun, 18 Jun 2006 00:23:58 -0400, David D Speck wrote:
> >What would the most elegant way be to insert a name and address entry
> >into the main table ONLY if it is not already there? I could see doing
> >a SELECT WHERE lname = new
Hi David,
* David D Speck <[EMAIL PROTECTED]> [2006-06-18 06:25]:
> What would the most elegant way be to insert a name and address
> entry into the main table ONLY if it is not already there? I
> could see doing a SELECT WHERE lname = new_lname AND fname =
> new_fname, AND street = new_street, et
17 matches
Mail list logo
