@sqlite.org
Subject: Re: [sqlite] Month string from -mm-dd
RB Smissaert wrote:
> Is it possible with the date-time functions to get the month as a string,
so
> January etc. from the date in the format -mm-dd?
Doesn't look like it. Nothing in the wiki and I couldn't see anything in
the
, but
I somehow guess it will be slower.
RBS
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 18 February 2007 19:37
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Month string from -mm-dd
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Is it pos
Analyzing the lookup table knocks the time down from 0.36 to 0.31 secs,
something I didn't expect.
RBS
-Original Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 18 February 2007 19:59
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Month string from -mm-dd
Thanks, I
Trying to update my mmdd integers to months with a SELECT CASE
statement:
SELECT CASE
(CAST(DATE_OF_BIRTH / 100 AS INTEGER) - CAST(DATE_OF_BIRTH / 1 AS
INTEGER) * 100)
WHEN 1 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'January'
WHEN 2 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'February'
Thanks, I understand now.
Will fix it and see how it compares the other methods.
RBS
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: 19 February 2007 04:54
To: SQLite
Subject: [sqlite] Re: What is wrong with this SELECT CASE statement?
RB Smissaert <[EM
@sqlite.org
Subject: Re: [sqlite] What is wrong with this SELECT CASE statement?
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Trying to update my mmdd integers to months with a SELECT CASE
> statement:
>
> SELECT CASE
> (CAST(DATE_OF_BIRTH / 100 AS INTEGER) - CAST(
This is about 20% faster than a table lookup, even when the lookup table is
already present.
So, learned something useful there.
RBS
-Original Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 19 February 2007 08:04
To: Bart Smissaert2
Subject: FW: [sqlite] Re: What is wrong
Could anybody pass me step by step instructions to compile the source with
MS VC++ ? I don't code or compile in C at all and only code in VB/VBA.
I am following the tutorial by Todd Tanner:
http://www.tannertech.net/sqlite3vb/index.htm
But this is with Visual Studio Net and I am running in some
Thanks, will have a look at that.
Do you know from experience that it will compile OK with VC6++?
RBS
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 12:02
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
RB Smissaert wrote
) : error C2373: 'sqlite3_libversion' :
redefinition; different type modifiers
No idea what to do about this.
RBS
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 13:29
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
RB
Think I got this fixed now.
It simply was something I had overlooked to change:
//const char *sqlite3_libversion(void);
BSTR __stdcall sqlite3_libversion(void);
Lots of warnings (265) but no errors and a dll is produced, which I will try
now.
RBS
-Original Message-
From: RB Smissaert
ByRef ErrStr As String) As Variant()
Private Declare Function sqlite_libversion _
Lib "SQLiteVB.dll" () As String
Private Declare Function number_of_rows_from_last_call _
Lib "SQLiteVB.dll" () As Long
RBS
-Original Message-
From:
-Original Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 14:31
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] compiling with VC++
Think I got this fixed now.
It simply was something I had overlooked to change:
//const char *sqlite3_libversion(void);
BSTR
Thanks, that is it, nice and simple.
RBS
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 15:40
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
RB Smissaert wrote:
> Now what do I do make it compile a dll cal
)'
warning C4244: '+=' : conversion from '__int64 ' to 'int ', possible loss of
data
warning C4761: integral size mismatch in argument; conversion supplied
RBS
-Original Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 16:18
To: sqlite-users@sqlite.org
Subject
*,__int64 ),void *)'
warning C4133: 'initializing' : incompatible types - from '__int64 (__cdecl
*)(struct sqlite3_stmt *,int )' to 'double (__cdecl *)(struct sqlite3_stmt
*,int )'
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> When compiling this source code I get 265 warning, which doesn
Subject: Re: [sqlite] compiling with VC++
RB Smissaert wrote:
> When compiling this source code I get 265 warning, which doesn't really
> worry me that much as it all seems to be working fine, but in general what
> kind of warning should be taken seriously?
This has come up the list b
Did you make the alterations to make the dll VB compatible?
RBS
-Original Message-
From: Dennis Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 18:39
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
RB Smissaert wrote:
> Thanks, will have a l
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 18:52
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
RB Smissaert wrote:
> Thanks, that is very helpful and reassuring as well.
> Will see if I can figure out then what is c
: 24 February 2007 19:06
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] compiling with VC++
The function signatures at the lines in question look wrong to me.
Do you have the correct version of sqlite3ext.h?
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Here examples of all 3, all from
e3_changes,
sqlite3_close,
sqlite3_last_insert_rowid,
sqlite3_libversion,
sqlite3_libversion_number,
sqlite3_open,
sqlite3_open16,
Instead you should disable compiling the loadable module extension by
defining SQLITE_OMIT_LOAD_EXTENSION.
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
>
Will give that a try and see if it gives any less warnings.
RBS
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 19:21
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
RB Smissaert wrote:
> Did you make the alterati
rom: Joe Wilson [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 19:45
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] compiling with VC++
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Downloaded it from the one you pointed to me:
You're confusing me with someone else.
Here's a way to b
:06
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> All C4028 warnings originate from this code block:
>
> const sqlite3_api_routines sqlite3_apis = {
[...]
> sqlite3_busy_timeout,
> //sqlit
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 20:06
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> All C4028 warnings originate from this code block:
>
> const sqlite3_
Came across a situation where it was impossible to delete or rename a SQLite
db file even after the application (Excel) that had locked the database was
closed. It wasn't me, so I don't have very exact information, but there was
a statement to create a table and to insert data. For some reason
Why does this query give a syntax error near offset?
SELECT
Name
FROM SQLITE_MASTER
WHERE TYPE = 'table'
ORDER BY 1 ASC
offset 2
limit works fine.
RBS
-
To unsubscribe, send email to [EMAIL PROTECTED]
I can see now that doing
SELECT
name
FROM SQLITE_MASTER
WHERE TYPE = 'table'
ORDER BY 1 ASC
limit -1
offset 2
works, but it doesn't do what I was trying and that is to keep
the field name out.
RBS
-Original Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 06 March 2007 19
Yes, thanks I understand now.
I take it there is no way to make it not return the field name.
RBS
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: 06 March 2007 19:53
To: SQLite
Subject: [sqlite] Re: What is wrong with this simple query (offset)?
RB Smissaert
2007 20:28
To: SQLite
Subject: [sqlite] Re: Re: What is wrong with this simple query (offset)?
RB Smissaert <[EMAIL PROTECTED]>
wrote:
> I take it there is no way to make it not return the field name.
I'm not sure what you mean by "not return the field name". My wild guess
is yo
: [sqlite] What is wrong with this simple query (offset)?
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Ah, thanks.
> I am not using the sqlite3 command line utility, but a VB adapted version
of
> the regular sqlite3.dll. I take it should be no problem to do the same
with
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 06 March 2007 21:22
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] What is wrong with this simple query (offset)?
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Ah, thanks.
> I am not using the sqlite3 command line ut
is simple query (offset)?
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Ah, thanks.
> I am not using the sqlite3 command line utility, but a VB adapted version
of
> the regular sqlite3.dll. I take it should be no problem to do the same
with
> that. Is there a pragma for this?
OK, forget about this, I think I am nearly there.
RBS
-Original Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 06 March 2007 22:42
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] What is wrong with this simple query (offset)?
Could I ask if somebody could tell me how I
ByRef iFields as long as well, but same error.
Any obvious mistakes here? I know this is not that much to do with SQLite,
but maybe it is something simple I am doing wrong and somebody could tell
me, other than that I should learn C first.
RBS
-Original Message-
From: RB Smissaert [mailto:[EM
Thanks, will have a look at that, but I am sure I am calling the new dll as
the declaration in VB doesn't mention the full path and I point to the dll
by changing the curdir.
RBS
-Original Message-
From: Trey Mack [mailto:[EMAIL PROTECTED]
Sent: 07 March 2007 13:12
To:
You were absolutely right, I didn't call the new dll.
All solved now.
RBS
-Original Message-
From: Trey Mack [mailto:[EMAIL PROTECTED]
Sent: 07 March 2007 13:12
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] What is wrong with this simple query (offset)?
> It looks all as it should
If I remember well this is a problem if you have the extension .db for the
database file and I think if you change that to something like .db3 then it
won't happen.
RBS
-Original Message-
From: Allan, Mark [mailto:[EMAIL PROTECTED]
Sent: 09 March 2007 16:23
To: sqlite-users@sqlite.org
Doesn't have to be .db3, but there are certain extension to avoid as posted.
RBS
-Original Message-
From: Allan, Mark [mailto:[EMAIL PROTECTED]
Sent: 09 March 2007 16:52
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] journal - "Unable to open the database file"
RB
UPDATE
A3SQLADC_J
SET
ADDED_DATE = '' WHERE ADDED_DATE = 0 OR ADDED_DATE IS NULL,
START_DATE = '' WHERE START_DATE = 0 OR START_DATE IS NULL
near ",": syntax error
I am sure I have run this before with no trouble.
RBS
Yes, thanks, that works indeed.
RBS
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: 11 March 2007 02:55
To: SQLite
Subject: [sqlite] Re: What is wrong with this UPDATE?
RB Smissaert <[EMAIL PROTECTED]>
wrote:
> UPDATE
> A3SQLADC_J
> SET
> ADD
Looking at the fastest way to convert a field in a table and wonder if in
general an update with a CASE WHEN construction or an update with a join to
a lookup table is faster.
These conversions are of this type:
UPDATE A3SQL77D_J
SET ENTRY_TYPE = (case
when ENTRY_TYPE = 9
Sorry, had to rush off and missed your alternative.
Will do some testing now.
RBS
-Original Message-
From: T [mailto:[EMAIL PROTECTED]
Sent: 18 March 2007 14:55
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Question about speed of CASE WHEN
Hi RBS,
>> Perhaps the alternative form
'Issue
> when 2 then 'Note'
Etc
But didn't get that to work as it always produced the first WHEN option.
RBS
-Original Message-
From: Christian Smith [mailto:[EMAIL PROTECTED]
Sent: 18 March 2007 15:29
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Question about speed of CASE
Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 18 March 2007 17:17
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Question about speed of CASE WHEN
Done some testing now and surprisingly, it seems the lookup method with a
join to a lookup table is very slightly faster than the CASE
[mailto:[EMAIL PROTECTED]
Sent: 18 March 2007 23:46
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Question about speed of CASE WHEN
RB Smissaert wrote:
> Ok, now done some better testing and the method with CASE WHEN is indeed,
as
> expected a bit faster
To me the lookup table method
Simplified I have the following situation:
2 tables, tableA and tableB both with an integer field, called ID, holding
unique integer numbers in tableA and non-unique integer numbers in tableB.
Both tables have an index on this field and for tableA this is an INTEGER
PRIMARY KEY.
Now I need to
Had a good look at this now and doing:
delete from tableB
where not exists
(select id from tableA where tableA.id = tableB.id)
Is indeed quite a bit faster than doing:
delete from tableB
where id not in
(select tableA.id from tableA)
In my case about 3 times as fast.
Looking at the query plan
Is there any difference in an index created like this:
Create table 'table1'([ID] INTEGER PRIMARY KEY)
with this:
Create table 'table1'([ID] INTEGER)
Create unique index idx_table1_ID on table1(ID)
I tended to use the first form, but as that can make subsequent table
inserts or deletes slower
PRIMARY KEY)"
RBS
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: 27 March 2007 22:51
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Difference in these indices?
RB Smissaert wrote:
> Is there any difference in an index created like this:
>
> Create
]
Sent: 27 March 2007 23:34
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Difference in these indices?
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Thanks for that.
> So if I can then I should create the table with INTEGER PRIMARY KEY.
> Is it right that this won'
Difference in these indices?
RB Smissaert wrote:
> Is it right that this won't affect the speed of any subsequent inserts or
> deletes?
>
Well inserts will be done in id order. If you have predefined ids
assigned by some outside source and specify them when you insert into
sqlite, it
: 28 March 2007 15:41
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Difference in these indices?
RB Smissaert wrote:
> As to quotes etc.
> As my code works fine as it is I probably will leave this as the double
> quotes look ugly and it will be a reasonably big job to alter all this.
&g
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Difference in these indices?
RB Smissaert wrote:
> Does this only apply to table and column names?
> I will never use double quote characters in my identifier
> names, so there should be no problem there.
>
>
It applies to all the ide
Funny you ask that as just 2 days ago I posted a little project
on RAC to do exactly this. In my case it has to be called from
VBA or VB. Unfortunately and surprisingly no takers yet.
RBS
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert L Cochran
Kees,
Would you be interested to do a project for me for a fee?
I need to upload/download data to/from a hosted SQLite 3 DB.
This has to be done from VBA or from a VB6 AX dll.
I have posted this to RAC, but there seems little interest/progress.
If interested then could you contact me off-list?
I
Kees,
Thanks for the interest in this and replied off-list.
Bart
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kees Nuyt
Sent: 12 March 2008 22:06
To: General Discussion of SQLite Database
Subject: Re: [sqlite] PHP Code That Can Store and Retrieve
DRH,
I would be seriously interested in a PRAGMA to disable/avoid a
journal file as in my application I don't need it at all and it
only slows down my DB writes. Would it be possible to add this?
If so, thanks in advance.
RBS
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Have tested this now on a table of some 30 rows (no indexes at all)
and with 100 rows to find in the middle of the table, sorted asc on
time-stamp field.
It gave me a speed increase of about 25%.
If I looked for rows at the beginning of the table the speed increase was
more, some 50% faster.
Using the latest SQLite and trying to speed up the making of some
intermediate tables. I thought I could do that by doing
PRAGMA temp_store = MEMORY and CREATE TEMP TABLE etc.
I do run the PRAGMA directly after establishing the SQLite connection.
So far I haven't seen any speed increase yet and I
: [sqlite] temp tables and PRAGMA temp_store
RB Smissaert <[EMAIL PROTECTED]> writes:
>
> Using the latest SQLite and trying to speed up the making of some
> intermediate tables. I thought I could do that by doing
> PRAGMA temp_store = MEMORY and CREATE TEMP TABLE etc.
>
I compared the speeds and found them to be the same.
RBS
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote
Sent: 07 May 2008 22:25
To: General Discussion of SQLite Database
Subject: Re: [sqlite] sorting records in random order
Samuel Neff
Done some testing with 3.5.9 with PRAGMA journal_mode = OFF and it seems
that strangely it makes DB writing queries slower. I use SQLite from VB/VBA
with the wrapper from Olaf Schmidt. Should it not be that PRAGMA
journal_mode = OFF should make inserts, create index etc. faster rather than
slower?
Can this be done in SQLite SQL?
ID Value
---
1 A
1 B
1 C
1 D
1 E
2 A
2 B
2 C
2 D
2 E
2 F
Delete rows to leave x rows per ID, say 3 rows, so we get:
ID Value
---
1 C
1 D
1 E
2
22:54
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] delete to leave x rows per group
RB Smissaert <[EMAIL PROTECTED]>
wrote:
> Can this be done in SQLite SQL?
>
> ID Value
> ---
> 1 A
> 1 B
> 1 C
> 1 D
> 1 E
> 2 A
> 2 B
> 2 C
> 2 D
> 2
Have a large (about half a Gb) SQLite db file, made with version 3.6.1.
I make this file on one PC (Windows XP) put the file on a USB stick, take it
home, copy it to the home PC (Win XP) local drive and then from there copy
the file to a Windows mobile (WM6) device, a Samsung Omnia.
On that device
-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of RB Smissaert
Sent: 09 January 2009 20:00
To: sqlite-users@sqlite.org
Subject: [sqlite] Why the difference in these 2 SQLite files?
Have a large (about half a Gb) SQLite db file, made with version 3.6.1.
I make this file
and hopefully it does.
Maybe I need some app to compare the 2 db files to see what is going on
here. Baffling me.
RBS
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of RB Smissaert
Sent: 09 January 2009 20:54
To: 'General Discussion
Try this:
select
avg(age)
from acoda
union all
select
avg(durata)
from main
union all
select
sum(età )
from dipendenti
RBS
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of silvio grosso
Sent: 10 January 2009 10:41
To:
-boun...@sqlite.org] On Behalf Of RB Smissaert
Sent: 09 January 2009 22:15
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Why the difference in these 2 SQLite files?
OK, any DB write to this file on the desktop (not the mobile device)
will make the query go fast. A completely
Would it be possible to make a SQLite file un-usable by overwriting bytes in
certain places and then (via an encrypted password) make the file usable
again by putting the right bytes back in the right places?
I use a VB wrapper that can encrypt the database, but I am using this SQLite
file on a
: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jay A. Kreibich
Sent: 25 January 2009 18:48
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Lock SQLite file by overwriting bytes and then
un-lock?
On Sun, Jan 25, 2009 at 06:29:28PM -, RB
-lock?
On Sun, 25 Jan 2009 18:29:28 -, "RB Smissaert"
<bartsmissa...@blueyonder.co.uk> wrote in General Discussion
of SQLite Database <sqlite-users@sqlite.org>:
>Would it be possible to make a SQLite file un-usable by overwriting bytes
in
>certain places and then (via
ock?
On Jan 25, 2009, at 2:32 PM, RB Smissaert wrote:
> Yes, you are right there. It won't be much good for anything else
> then a
> casual peek at the device. This is a clinical database, so it involves
> patients, diagnoses, medications etc. The ID data and the clinical
>
by overwriting bytes and then un-lock?
RB Smissaert <bartsmissa...@...> writes:
>
> For some reason this mail went to the junk mail folder.
> That sounds good and I would be happy to buy this, but I am not sure
about:
> > All you need to do is replace the DLL
>
Thanks; will do that.
RBS
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of MikeW
Sent: 26 January 2009 12:02
To: sqlite-users@sqlite.org
Subject: Re: [sqlite]Lock SQLite file by overwriting bytes and then un-lock?
RB
What SQLite version produced the file World.db3?
I ask as my wrapper doesn't pick correctly the fields of a table.
This is Olaf Schmidt's VB wrapper dhRichClient with SQLite 3.6.11.
BTW, SQLiteSpy looks a very nice GUI tool.
RBS
-Original Message-
From: sqlite-users-boun...@sqlite.org
-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ralf Junker
Sent: 08 March 2009 14:38
To: General Discussion of SQLite Database
Subject: Re: [sqlite] tool to browse a sqlite database
RB Smissaert wrote:
>What SQLite version produced the file World.db3?
I am not 100% s
-users-boun...@sqlite.org] On Behalf Of Ralf Junker
Sent: 08 March 2009 14:38
To: General Discussion of SQLite Database
Subject: Re: [sqlite] tool to browse a sqlite database
RB Smissaert wrote:
>What SQLite version produced the file World.db3?
I am not 100% sure about the exact SQLite vers
Does SQLite have a string function that produces the first position of a
string within another string?
For example select Instr('abcd', 'c') would produce 3
Looked in the documentation and the forum, but couldn't see it.
RBS
___
sqlite-users mailing
] On Behalf Of Igor Tandetnik
Sent: 11 September 2009 22:40
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Does SQLite have an Instr function?
RB Smissaert <bartsmissa...@blueyonder.co.uk>
wrote:
> Does SQLite have a string function that produces the first position
> of a string wi
of SQLite Database
Subject: Re: [sqlite] Does SQLite have an Instr function?
RB Smissaert wrote:
> Does SQLite have a string function that produces the first position of a
> string within another string?
> For example select Instr('abcd', 'c') would produce 3
> Looked in the d
Have 2 tables with both one text field called term and need to run a SQL
like this, to count the records in table1 where the start of term in table1
equals a term in table2:
select
count(a.rowid)
from table1 a inner join table2 b on
(lower(b.term) = lower(substr(a.term,1,length(b.term
term
on tmptable2(shortest)
-Run this sql
select
count(a.rowid)
from tmptable1 a inner join tmptable2 b on a.shortest=b.shortest
where (lower(b.term) = lower(substr(a.term,1,length(b.term
RB Smissaert wrote:
>
> Have 2 tables with both one text field called term and need to run a SQL
> like this,
: 12 September 2009 14:56
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Any way to speed up this SQL?
RB Smissaert wrote:
> Have 2 tables with both one text field called term and need to run a
> SQL like this, to count the records in table1 where the start of term
> in table1 equa
Maybe, what is it?
RBS
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of mcnamaragio
Sent: 23 September 2009 14:16
To: sqlite-users@sqlite.org
Subject: [sqlite] Sqlite profiler
Hello,
Would anyone be interested in sqlite
OK, thanks.
In that case I do that in my application code.
RBS
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Christian Schwarz
Sent: 23 September 2009 14:33
To: General Discussion of SQLite Database
Subject: Re: [sqlite]
> I'm using Olaf Schmidt's VB SQLite binder.
That does use parameterized statements.
Look at the methods and properties of the cCommand object in the object
browser. Also look at the demo code that comes with dhRichClient3.
RBS
-Original Message-
From: sqlite-users-boun...@sqlite.org
I would like to do a where on a text field and check if the values have
non-numeric characters,
which is in this case is anything other than 1,2,3,4,5,6,7,8,9,0 or a space
character.
Is this possible without using a UDF or a very long OR construction?
RBS
201 - 289 of 289 matches
Mail list logo