Dear sqlite users,
I noticed that when you delete lines from a FTS virtual table, somehow there is
some data remaining in the sqlite db, so that's it does not shrink much in size.
$ sqlite3 test.sql "CREATE VIRTUAL TABLE tab USING fts5(x)"
$ curl -s https://www.wikipedia.org | tr -cd '[:alnum:][
le" RENAME TO "My_Table";
-- Search FTS table - all of these work perfectly now
SELECT * FROM "My_Table" WHERE Text MATCH 'table';
SELECT * FROM "My_Table" WHERE Text MATCH 'table' ORDER BY rank;
SELECT * FROM "My_Table" WHERE Text MATCH 'table' ORDER BY bm25(`My_Table`);
Thanks,
Matt
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Hey guys,
I wonder if version 3.29 does support error handling for sql transaction
rollbacks. Also, does it support bypassing errors by forcing unconditional
rollback yet.
--
Cheers,
Matt Zand
Cell: 202-420-9192
Work: 240-200-6131
High School Technology Services <https://myhsts.org/>
Thanks so much! I figured I was missing something :)
Matt Parsons
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
7;) values ('hello')
on conflict do nothing;
Am I misreading the grammar chart? If this is a difference between the
grammar and the implementation, which one should be updated?
Thanks,
Matt Parsons
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3071601.zip: Data is returned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3071600.zip: Data is returned!
Cheers,
Matt
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqli
at the URI
http://www.sqlite.org/sqlitedll-. I'm sure the rest are hosted
somewhere. I'm trying to save time from having to download and compile the
source for every major release.
Can someone help?
Cheers,
Matt
___
sqlite-users mailing list
sqlite-user
load_extension() has the very sensible behavior of:
> So for example, if "samplelib" cannot be loaded, then names like
> "samplelib.so" or "samplelib.dylib" or "samplelib.dll" might be tried
> also.
I would like to see that extended to include "libsamplelib.so" since that is
the default naming sch
Hi all,
I'm trying to use SQLite in an asynchronous application that requires
low/predictable latency access to the database. To achieve this is, I plan
to disable WAL autocheckpoints and manually run permissive WAL checkpoints
on a second thread (as hinted at by the docs).
If I do this, can a WA
> On 13 May 2016, at 16:04, Dan Kennedy wrote:
>
> On 05/13/2016 09:19 PM, Matt Hamilton wrote:
>> Hi all,
>> Anyone know if/how you can call the FTS5 tokeniser functions manually? e.g.
>> I want to look something up in the fts5vocab table but can't as I ne
somehow map 'running' => 'run' in order to query the fts5vocab table
to get stats on that term? And how could I tokenise 'running man' => 'run',
'man' in order to look up multiple tokens?
-Matt
?
Matt Hamilton
Quernus
matt at quernus.co.
ion.
Does this make sense? Or anyone else see any other way to achieve what I want
to do?
thanks
-Matt
?
Matt Hamilton
Quernus
matt at quernus.co.uk <mailto:matt at quernus.co.uk>
+44 117 325 3025
64 Easton Business Centre
Felix Road, Easton
Bristol, BS5 0HE
Quernus Ltd is a com
also correct if you build an index on the queried column.
Thanks for your help (and great software)!
Matt
```
drop table if exists test;
create table test ( x );
insert into test values(1);
insert into test values(2);
-- expected output: a single row
-- 1|1
--
-- actual output:
-- 1|1
-
Using the _ character to separate words is an informal language standard,
s in: method_do_this...
On Tue, Feb 28, 2012 at 12:40 AM, Dan Kennedy wrote:
> On 02/28/2012 12:09 AM, Jos Groot Lipman wrote:
>
>> It was reported before (and not solved)
>> http://www.mail-archive.com/**sqlite-users@sql
// The cmd string direct output to result
// Execute the command, then open result and read
#include
#include
#include
void main() {
FILE *f;
char buff[100];
const char * query = "select 'hello Sqlite3';";
const char * cmd = "sqlite3 test.db < name > result";
f = fopen("name", "w+");
if(f==0)
https://github.com/Matt-Young/Embedded-SQL
It speaks Json text at the console, and operates from self directed
serialized Bson like streams formatted onto Sqlite triple tables.
Working, but just out of the lab, buggy, good for browsing. c code
http://www.c-sharpcorner.com/UploadFile/prasad_1/RegExpressionSample72005040853AM/RegExpressionSample1.aspx
At that site they parse your string using regex in c#, though I did't see a
time stamp test, and their is the equivalent regex functions, many, in a c
libs.
On Tue, Jan 17, 2012 at 4:
http://javascriptsource.com/forms/dynamic-table.html
Looks great if you operate from a browser. Can we still get sqlite
embedded into the browser, or do we have to plug it in?
On Tue, Jan 17, 2012 at 8:05 AM, Chris Green wrote:
> I'm after an application which will allow me to enter data into a
still needing a self contained user id management. So, import the
standard user id function from the sqlite repositories and be done with it.
On Tue, Jan 17, 2012 at 5:01 AM, Matt Young wrote:
> Mainly grouping sqlite applications in the embedded environment, hopefully
> generating some re
16, 2012 at 11:58 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 16/01/12 21:46, Matt Young wrote:
> > Group projects, collected together because sqlite is the common
> > foundation. Would be nice?
>
> You'll need to use longer s
Group projects, collected together because sqlite is the common
foundation. Would be nice?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I used the strcpy_s function from Microsoft, the so called safe version
that includes a char count. I used it under the Studio debugger. Set a
buffer of 200 chars to zero, set the char count to 20 in strcpy_s, and the
debugger wrote in the top 180!!
I freaked, didn't see that as safe at all!
On
select count() from sqlite_master;
No??
On Wed, Dec 21, 2011 at 10:32 AM, smallboat wrote:
> Hello,
>
> I have a sqlite file. I would like to open it and know how many tables in
> it.
>
> What is the command line to open a sqlite file and get to know how many
> tables in it? Thanks.
>
> Regards
Good idea, as soon as I figure out how it works!
On Wed, Nov 23, 2011 at 2:41 PM, Nico Williams wrote:
> Docs would help people understand what you're up to...
>
> Nico
> --
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org
A base of code that implements about every embedded function for sqlite3,
source code on my blog. It is a triple machine, looks at the world as
ripples for ontology. I tries to follow SQLITE standards. The control
program pops triple off of the configure table and executes them,
installing more co
In the documentation on trigger, begin has no semicolon, and it works.
From the command line, I can begin and end transaction, but I need the
semicolon after begin. Is there a difference?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlit
Well, it was listed as an initial option o the trigger, so I didn't quite
get it either.
On Sat, Nov 19, 2011 at 7:02 PM, Igor Tandetnik wrote:
> Matt Young wrote:
> > sqlite> drop trigger if exists mytrigger;
> > sqlite> create trigger mytrigger after insert
sqlite> drop trigger if exists mytrigger;
sqlite> create trigger mytrigger after insert on result
...> begin
...> select 'Test2';
...> end;
sqlite> insert into result values(0,0,0);
sqlite>
Explain the path of select here?
___
sqlite-users maili
200 lines of code with embedded c. (headers omitted)
This code comes up and reads triples from a table view called self, reads
triples one at a time. The triples are either a configure and load sql
statement command, or the triple is executed, as a random sql procedure
doing whatever, Rinse and re
You saved the day!
On Mon, Nov 14, 2011 at 2:25 PM, Igor Tandetnik wrote:
> On 11/14/2011 5:03 PM, Matt Young wrote:
>
>> OK,I found the gotcha. I can swap out the target table in a view, but I
>> cannot read the rowids from a view.
>>
>
> You can, if you make the
OK,I found the gotcha. I can swap out the target table in a view, but I
cannot read the rowids from a view.
So, do I have t, are rowids unavailable in a view?
>
>
> On Mon, Nov 14, 2011 at 10:25 AM, Nico Williams wrote:
>
>> I thought nowadays SQLite3 was smart enough to re-prepare a prepared
>>
using, I
don;t care if is fake, but I do care if there are gotchas!
Tell me, why does this work? And if it works, why aren't we advertising it?
Matt
On Mon, Nov 14, 2011 at 10:25 AM, Nico Williams wrote:
> I thought nowadays SQLite3 was smart enough to re-prepare a prepared
> sta
I have table1, I make a view view one of that table. I then delete the
table, the view does not work.
I then recreate the table, and alter its name to the one viewed.
and view suddenly works.
Am I dreaming? Does SQLite3 maintain a schema in views an allow us to
alter table names?
Matt
SQL needs a create schema, then the statement can be prepared against a
know schema, and swap out the table pointer at run time. The problem of
one great sql procedure that works on many different table of the same
format.
I have a work around.
___
sqli
Using cv api.
I install a prepared statement, but it cannot allow the table identifiers
to be replaced with sqlite3_bind. If the table in the statements is a view,
then I suppode it is an error to redefine the vie?
Bottom line, it is an error to change any table definition in a prepared
statement?
Embedded Sqlite3 questions:
I want to load and prepare multiple statements, keep them prepared and when
I want to use one of them, I will reset, bind and step.
Can pre-prepare multiple independent statements, then run them one at a
time at random?
Thanks, this may be a newbie question for embede
may be due to the standard C header files included with
Mac OSX. For example, there is a line as such:
rc = write(fd, "S", 1);
where rc is an int and write() returns a ssize_t. Is the LLVM Clang
compiler supported by the authors of Sqlite3?
Thanks.
M
LinkedIn
Matt Young requested to add you as a connection on LinkedIn:
--
Zarko,
I'd like to add you to my professional network on LinkedIn.
- Matt
Accept invitation from Matt Young
http://www.linkedin.com/e/-62mihx-gnwac0
How about a text editor with search and replace. There must exist a list of
the files in text form, hence search and replace gets a batch function that
uses .import
On Mon, Apr 4, 2011 at 2:41 PM, Simon Slavin wrote:
>
> On 4 Apr 2011, at 9:04pm, Gert Van Assche wrote:
>
> > We need to import t
Right, ORDER by, oherwise the row order is undefined.
Why the urge to grab the mailing list, then look at the references?
Dunno, sloppy hobbyist..
On Sat, Apr 2, 2011 at 5:14 PM, Jay A. Kreibich wrote:
> On Sat, Apr 02, 2011 at 05:01:34PM -0700, Matt Young scratched on the wall:
> &g
sqlite> select 1 as type union select 2;
type
1
2
sqlite> select 'tr' as type union select 2;
type
2
tr
sqlite>
The order of the rows change when text replaces a numeric.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bi
A Web Sql widget really, here is a screen shot link
http://bettereconomics.blogspot.com/2011/03/xml-commander.html
It is all XML htp get, web sql and xml in javascript, working on opera
browsers. The idea is to get the publisher simple access to the combination
of SQL in his document and ad hoc XM
Yes, that one did it. Iterating on arrays by their factors.
Thanks.
On Fri, Mar 18, 2011 at 11:05 AM, H. Phil Duby wrote:
> Nothing to do with SQLite, but ...
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mail
Here is my Javascript code, it works. Except I have to know the table field
names within the javascript code itself: This little phrase:
results.rows[i].f1
f1 is a field name, I have to know this in the call.
Yes I know indexDB is coming, but is there a workaround for this? I want to
scoop up th
I thought is just about matches everything I need for managing my databases.
I gave it a thumbs up.
That is all from a small researcher with gobs of data.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listin
I looked up Noah Hart and found a very nice C# inerface to the SQLIite
system. That sound's ideal, under Chrome OS so with other vendor support I
hear. So specialized blog readers can use widgets built with c#/ and get it
all, in the bowser
On Mon, Mar 7, 2011 at 5:03 AM, Richard Hipp wrote:
> O
http://www.w3.org/TR/2010/NOTE-webdatabase-20101118/
//I can open a database
// write to it, read from it.
// But I would like access to the hidden database it creates.
// I look everywhere, cannot find it!
var databaseOptions = {
fileName: "file://localhost/C:/R/work/test.db",
version: "1.0",
d
Trying to understand it. How do I specifically open sqlite from a jquery
widget.
Or best simple example.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I am a regular user of sqite at the office, but I want to progress to sqlite
web access via the web. Who has the best widgets for that? Web space not a
problem. Widgets that work in blogger pages would be nice, but I can start
fresh also.
___
sqlite-use
Bingo, I live and learn
On 5/28/10, Igor Tandetnik wrote:
> Igor Tandetnik wrote:
>> Matt Young wrote:
>>> I second that documentation confusion. There is no truncate to
>>> integer, though I wish it would.
>>
>> Somewhat off-topic, but if you wan
OK, got it. I was referring to the number of decimal points, but yes
round(x,0) does do something
On 5/27/10, Igor Tandetnik wrote:
> Matt Young wrote:
>> Round(x,0) really doesn't exist, it simply does round(x,1)
>
> select round(4.1, 0), round(4.1, 1);
> 4.04.1
simply does round(x,1)
On 5/27/10, Igor Tandetnik wrote:
> Matt Young wrote:
>> I second that documentation confusion. There is no truncate to
>> integer, though I wish it would.
>
> Somewhat off-topic, but if you want truncation, this would do it: round(x -
> 0.5) . W
I second that documentation confusion. There is no truncate to
integer, though I wish it would.
On 5/27/10, Wilson, Ronald wrote:
> From http://www.sqlite.org/lang_corefunc.html
>
> "The round(X,Y) function returns a string representation of the
> floating-point value X rounded to Y digits to th
Don't forget to mention Python
On 5/21/10, Gilles Ganault wrote:
> On Fri, 21 May 2010 15:23:13 +0200, Jean-Christophe Deschamps
> wrote:
>>AutoIt, while a scripting language can be seen and used as a RAD
>>platform. It enjoys good support, up to date SQLite embedding and
>>executables produced
I have that problem. A solution is an ultra lite SQLite window to
play along side existing spread sheet packages. Then just get read and
write to the spreadsheet happening.
I did that simply with R; I reasoned Windows was smart enough to
handle files, so I just read and write files netween SQLit
I mentioned a while back that .import can be made to work with
flexible number columns by setting a mode that says 'ignore column
error on import'. The idea is that SQLite can import from csv files
where the number of columns is not known.
I looked that the code for import. If there was a column
Thanks. A novice sometimes posts prior to a complete search of documentation.
On 5/11/10, P Kishor wrote:
> On Tue, May 11, 2010 at 1:50 PM, Matt Young wrote:
>> sqlite> create virtual table if not exists words using fts3 (f1 );
>> Error: near "not": syntax error
C:\R\SQLite>sql ap.data.3.Food.db
SQLite version 3.6.23.1
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
Col2U seriesdata seriesid
sqlite> .q
C:\R\SQLite>sql
SQLite version 3.6.23.1
Enter ".help" for instructions
Enter SQL statements te
sqlite> create virtual table if not exists words using fts3 (f1 );
Error: near "not": syntax error
sqlite> create table if not exists U (w1 );
sqlite>
Different syntax? virtual tables don't persist?
___
sqlite-users mailing list
sqlite-users@sqlite.or
is not clear to me where you want to put that aggregated set. Do
> you have another *table* called SERIESID with those three columns in it?
>
>
> Regards
> Tim Romano
> Swarthmore PA
>
>
> On Mon, May 10, 2010 at 2:43 AM, Matt Young wrote:
>
>> # series data l
# series data looks like:
create table seriesdata (
data_index INTEGER PRIMARY KEY autoincrement,
series_id text,
year numeric,
value numeric);
# and is filled
insert into seriesid
select
s.series_id as id, min(data_index),max(data_index)
The second example without the min picks the last of the c2, not the first.
On 5/7/10, Matt Young wrote:
> On 5/7/10, Pavel Ivanov wrote:
>> Sorry, I can hardly understand what you are trying to say but want to
>> point out one error:
>>
>>> sqlite> select 'St
T0 group by c2;
>
> Other aggregate variants are possible too. In general if you use
> "group by" clause then only columns from "group by" clause can be
> mentioned in select list, all other columns MUST be inside some sort
> of aggregate function (http://www.sqlite
In the following code I try select by group on one column. I am
assuming the query optimizer will figure to stop gathering column 1s
right away because there are no other selection constraints. Yet in
the example, sql still looks through the entire table for additional
column ones as one can see
Righto yes, a simple macro somewhere in the path to correct for row size
On 5/6/10, Jim "Jed" Dodgen wrote:
> On Thu, May 6, 2010 at 3:56 PM, Simon Slavin wrote:
>>
>> On 6 May 2010, at 11:19pm, Matt Young wrote:
>>
>>> I need a version of import tha
It could be done and only adds a few bytes to the binary since the
code would simply check the 'ignore on import setting of .mode' before
taking error action for missing or too many columns. I will look at
the source
On 5/6/10, Simon Slavin wrote:
>
> On 6 May 2010, at 11:19pm,
I need a version of import that reads what it can, filling in defaults
when too few columns, discarding data when too many.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Got that one two, thanks, this mail list saves time.
On 5/6/10, Jay A. Kreibich wrote:
> On Thu, May 06, 2010 at 12:31:26AM -0700, Matt Young scratched on the wall:
>
>> Can I create a virtual table mapped to an existing table in my
>> database?
>
> You'll need t
Got it, thinks Jay.
On 5/6/10, Jay A. Kreibich wrote:
> On Thu, May 06, 2010 at 05:10:31AM -0700, Matt Young scratched on the wall:
>> OK, I got it.
>>
>> insert into seriesid
>> select series_id,min(ROWID) from
>> seriesdata group by series_id;
, limit to extract just the
date series I want.
Starting to get it.
On 5/6/10, Simon Davies wrote:
> On 6 May 2010 12:03, Matt Young wrote:
>> # I am doing a simulation of distinct
>>
>> insert into seriesid (series_id,pointer)
>> select series_id
# I am doing a simulation of distinct
insert into seriesid (series_id,pointer)
select series_id,ROWID from seriesdata as s
where s.series_id not in(
select
series_id
from
seriesid
Can I create a virtual table mapped to an existing table in my
database? Does this let me alias a whole table? Thinking out loud,
does this give me ability to write a query on the virtual table, then
remap the virtual table to a current table and execute the query?
___
ctly read and write SQLite databases. Also see the
> sqldf package.
>
> On Tue, May 4, 2010 at 1:02 PM, Matt Young wrote:
>> I can work SQLite from by R stat package, but I am having hard time
>> mixing special sqlite command intermixed with SQL statements when I
>> send
I can work SQLite from by R stat package, but I am having hard time
mixing special sqlite command intermixed with SQL statements when I
send a text sequence to swqlite (even from the dos consol)
sqlite3 test.db ".mode csv select * from selected limit 4"
Makes sqlite choke because I do not know
Thanks,
I eventually ended up doing something like that,and got it working.
I booked marked the your example and will try variations of it.
I got most of my system working, but I am still overwhelmed with
economic data releases from around the word.
On 5/3/10, Tim Romano wrote:
> Matt,
&g
f, RODBC, RJDBC, sqliteDF) then you can
> communicate to the maintainers of those packages.
>
> On Sun, May 2, 2010 at 8:38 PM, Matt Young wrote:
>> I want to see SQLite integrated into the R statistical package. R Project
>> http://www.gardenersown.co.uk/Education/Lectures/R/r
I want to see SQLite integrated into the R statistical package. R Project
http://www.gardenersown.co.uk/Education/Lectures/R/regression.htm#multiple_regression
for example.
R statistical is very and becoming more popular, has great plotting,
and wrestles data in frames that look awfully like sql
I am a bit of a novice. I am dealing with meta data, descriptions of
the Bureau of Labor Statistics database. BLS data is identified by a
series code (16 chars long) but the series format is different for
each data group)
I need to extract from an SQL table the names of other SQL tables and
refer
Hi,
I'm trying to update a field of the last record using UPDATE and MAX().
The following query parses ok but updates all records. Any reason why ?
UPDATE logs SET Stop = DATETIME('NOW') WHERE (SELECT MAX(ID) FROM logs)
Th
e this.
Thanks,
Matt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
count of the largest set. But not the actual
value. For that you need to combine it with a HAVING clause. But I'll
leave that as an exercise :-)
Matt.
__
This email has been scanned by the MessageLabs Email Security Syste
oesn't return the
data unchanged at all. If I take the \n out of single quotes I just
get an error.
TIA
Matt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
How does the replace function identify a windows CRLF? I've tried
using \n, \r, \p, 0D0A, etc. I just want to remove multiple carriage
returns from a text typed field. Something like: Select replace
(field1, '\n\n','\n') from table; I've just started dabbling with
SQLite. I mainly work with MSSQL a
-- like a cruel
Matryoshka doll on my desktop.
The file in question: http://www.sqlite.org/sqlite3-3.6.17-osx-x86.bin.gz
Thanks in advance.
Matt
--
Matt Stiles
Reporter, Texas Tribune <http://www.texastribune.org>
Email: msti...@texastribune.org
Mobile: 512.965.5197
[image
On Mon, 17 Aug 2009 10:47:23 -0400, Angus March wrote:
>> Because yes, that's what synchronous=OFF means. It stops SQLite from
>> issuing fflush calls (effectively).
>>
> Right, and this is implied by the documentation, but I was concerned
> that the documentation might be playing fast and
On Fri, 14 Aug 2009 12:33:30 -0400, Angus March wrote:
> I want my INSERT done right away, I just don't want it to be flushed
> from the filesystem's write-behind cache until the kernel decides, not
> when SQLite decides.
Did you mean you do "want it to be flushed from the filesystem's
write-
On Sat, 18 Jul 2009 10:17:14 -0700, Kelly Jones wrote:
> On a website, I want to take a user's query "as is", save it to a
> userquery.txt, and then do:
>
> sqlite3 /path/to/mydb < userquery.txt
>
> where /path/to/mydb is a *read-only* file.
>
> Is there *any* risk of an injection attack here?
On Tue, 23 Jun 2009 22:01:26 +0200, Misza wrote:
> I wonder if anyone used SQLite extensively with big datasets and could
> provide some insight into performance?
> In a nutshell, I am writing an ETL framework and need a good (read:
> performing) engine for the "T"ransform part.
> I suppose I could
BD::SQLite? I would be very
> delighted and grateful to be able to use an up-to-date SQLite version
> in my Perl scripts.)
I'm here, I'm just very slow. I did try and pass it off to someone else
as maintainer but they vanished. No idea why.
Matt.
_
the time. It only seems to happen for
the following specific query:
SELECT x FROM table
WHERE id IN ()
AND x IN (SELECT x FROM table2 WHERE id=)
Any ideas? Has this been fixed in a newer version already? I've already
worked around this and I no longer issue SQLite any "IN ()" queries,
On Sat, 21 Jun 2008 11:50:31 +0700, Dan wrote:
>
>> On Thu, 19 Jun 2008 12:05:56 -0400, D. Richard Hipp wrote:
>>>
>>> On Jun 19, 2008, at 11:49 AM, Matt Sergeant wrote:
>>>>
>>>> Note that there are some C++ style comments crept back into the
On Thu, 19 Jun 2008 12:05:56 -0400, D. Richard Hipp wrote:
>
> On Jun 19, 2008, at 11:49 AM, Matt Sergeant wrote:
>>
>> Note that there are some C++ style comments crept back into the code
>> (I
>> noticed in the amalgamation, so I can't give you a dire
you cannot compile SQLite
> directly using a C++ compiler.
Note that there are some C++ style comments crept back into the code (I
noticed in the amalgamation, so I can't give you a direct pointer to
them). This causes compile failures on stricter C compilers.
Matt.
_
I am not familiar with the DLL realm. Any idea what this means?
sqlite3.dll: 127: The specified procedure could not be found. -
Init_sqlite3 (LoadError)
Thanks,
Matt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
ified procedure could not be found. - Init_sqlite3
(LoadError)
I have SQLite 3.5.7 downloaded. Any ideas?
Thank you,
Matt M
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
am bailing on Views and have a major programming
change to do so.
Thanks,
Matt
-Original Message-
From: Noah Hart [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 07, 2007 10:45 AM
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: RE: [sqlite] Slow View Performance
Matt, if looks
TabB INNER JOIN TabC
it runs as I expect.
Is this a know issue? Is there a simple workaround?
Matt Froncek
QODBC Development Support / FLEXquarters.com LLC Consultant
QODBC Driver for QuickBooks - Unleash your data at <http://www.qodbc.com/>
www.qodbc.com
TabB INNER JOIN TabC
it runs as I expect.
Is this a know issue? Is there a simple workaround?
Matt Froncek
QODBC Development Support / FLEXquarters.com LLC Consultant
QODBC Driver for QuickBooks - Unleash your data at <http://www.qodbc.com/>
www.qodbc.com
ith a syntax error
about the "=".
Change the last to lines to:
Customer.FullName = 'Okami' OR (
Customer.FullName = 'Okami2' OR (
Customer.FullName = 'Quickspice, Inc.')
Matt Froncek
QODBC Development Support /
er"."FullName" = 'Columbus Distributing,
Inc.')
OR (("Customer"."FullName" = 'Cost Plus World Markets-West') OR
(("Customer"."F
ullName" = 'DeKalb Farmers Market') OR (("Customer"."FullName" =
1 - 100 of 207 matches
Mail list logo