2019-07-19 19:29 +02:00, d...@sqlite.org :
> On 7/19/19, Gilles Pérez wrote:
> > set tvalue true
>
> This statement sets the TCL variable "tvalue" to the four-character
> string "true", not to a boolean true.
Is it possible in Tcl to specify I want a bo
th true and false in variables. If I write true or false directly,
> no problem, sqlite store a 1 or a 0.
>
> But if a put them in a variable, sqlite always store them as strings "true"
> or "false".
>
> How to achieve a correct resul
t;false".
How to achieve a correct result with a $value or :value without prefiltering
values “true” or “false”?
Thank you,
Gilles.
sqlite3 version: 3.24.0 2018-06-04 19:24:41
c7ee0833225bfd8c5ec2f9bf62b97c4e04d03bd9566366d5221ac8fb199aalt1
libsqlite3 version: 3.25.3
INSERT INTO t
Simon Slavin-3 > To clarify the clarification, you can use the SQLite
shell tool just fine as long as you use it to process files, rather than
expect characters which are entered through the keyboard or shown on the
display to work. So use ".read" or ".output" or ".once", and then use a
R Smith >
>> 2. Do not use the sqlite3.exe CLI if the data use anything more than
>> the basic latin alphabet. Instead, use a GUI application (eg. for
>> Windows, SQLite Studio, SQLitespeed, etc.)
> Every lesson is valuable! Just to be clear - there is nothing wrong
with using the CLI. When
Posted by David Raymond on Jun 19, 2017; 5:22pm > /The Windows command
prompt and unicode have always not played well with each other. SQLite
itself works perfectly with data on disk or in the database, there are
just translation and display problems when going to and from the command
prompt.
Found the problem: Turns out the CSV file isn't in UTF8 but in CP1252 :-/
Icon.exe can be used to convert a file before importing it in SQLite.
https://dbaportal.eu/2012/10/24/iconv-for-windows/
Thanks everyone for the help.
___
sqlite-users mailing
Thanks everyone.
It looks running sqlite3.exe in a terminal window (CMD) in Windows 7
doesn't work: Apparently, it doesn't support UTF-8.
And when using DB Browser for SQLite, it does work only if I copy/paste
the output with the "?" where an accented character lives:
reproduce?
Regards
Gilles
Here is the script without double quote
drop table if exists records;
create table if not exists records( activityId integer primary key,
activityDate text, activityType integer,message text) ;
insert into records values (1,'2016-09-01',22,'{"Date":
re is NO double quote in the database.
Regards
Gilles Vollant
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ls
from (
select *, length(message) as msglen,
message as jsonstr ,
json_valid(message) as is_json_valid
from (select * from records where activitytype=22 ) where
is_json_valid=1)
) as allrs1
group by date order by date);
Best regards
Gilles Vollant
_
On Fri, 7 Dec 2012 22:05:47 -0500, John Gabriele
wrote:
>Just checked stackoverflow and found this:
>https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ . Might
>be what you're after.
Thanks. I'll try it, but judging from the screenshots, but it's
probably harder
On Wed, 12 Mar 2014 19:05:01 +0100, big stone
wrote:
>What don't you like in base solution that made you ask for other ideas ?
I just like SQLite's simplicity and speed, so wanted to make sure
there weren't alternatives.
Besides, it seemed a bit overkill to have her
On Wed, 12 Mar 2014 11:46:53 +, Simon Slavin
wrote:
>Any GUI you see is provided by a third party. There's no point in trying to
>keep track of more than a hundred database management GUIs, many of which are
>buggy, many of which interface with other database systems
On Wed, 12 Mar 2014 07:59:39 -0400, David Bicking
wrote:
>Not exactly "lite" in size, but kexi does have most of the features of
>Access and uses sqlite to store its data:
>
>http://kexi-project.org/
Thanks for the link. It's currently not available for Windows, but
I'll keep
On Wed, 12 Mar 2014 10:29:43 +0100, Kees Nuyt
wrote:
>Not what you asked for, but LibreOffice Base can use SQLite via ODBC:
>
>http://ch-werner.de/sqliteodbc/
>
>I have no experience with that solution, but at least the package is
>maintained and reasonably up to date.
Thanks
Hello
A friend needs to move from Excel to a database. The school won't
pay for the full version of MS Office that includes Access, so
recommended that she use LibreOffice Base instead.
I just checked it out, and it seems to only be a front-end to the
HSQLDB database which is written in
On Fri, 19 Apr 2013 16:41:53 -0700, "Joe Mistachkin"
wrote:
>Actually, ALL the non-static packages on the download page require the MSVC
>runtime libraries of the appropriate version to be installed.
>
>The download page does mention these requirements in each applicable
On Fri, 19 Apr 2013 23:42:19 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>Thanks the tip. More testing in the IDE shows that it works OK even
>when editing the PATH, and I can no longer trigger the "Unable to
>load DLL 'SQLite.Interop.dll': The specified module
On Thu, 18 Apr 2013 23:46:58 -0400, markus diersbock
wrote:
>Since it worked, you can move the files to any final folder, and add a
>reference to System.Data.SQLite.dll
>
>And add your folder to PATH, to find SQLite.Interop.dll
Thanks the tip. More testing in the IDE shows
On Thu, 18 Apr 2013 13:36:54 -0400, markus diersbock
wrote:
>Put SQLite.Interop.dll in the same folder as your VB assembly (ie
>/debug or /release)
Thanks for the tip.
But it's kind of a pain to have to copy SQLite.Interop.dll +
System.Data.SQLite.dll in \debug with every
On Thu, 18 Apr 2013 16:10:48 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>It did work finally by using
>
>sqlite-netFx45-static-binary-bundle-Win32-2012-1.0.84.0.zip
I wanted to edit the FAQ to spare other newbies, but even after
logging on as "anonymous"
It doesn't work either with
sqlite-netFx45-binary-bundle-Win32-2012-1.0.84.0.zip
whether System.Data.SQLite.dll is located in .\Externals or some other
location.
It did work finally by using
sqlite-netFx45-static-binary-bundle-Win32-2012-1.0.84.0.zip
Could it be due to VC++ dependency?
On Thu, 18 Apr 2013 15:32:02 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>Does it mean that we have to copy the two files in each and every
>application, instead of just putting them in eg. C:\Windows?
Still no go.
1. Per the FAQ
(http://system.data.sqlite.org/index.html/d
On Thu, 18 Apr 2013 09:27:00 -0400, Kevin Benson
wrote:
>http://sqlite.1065341.n5.nabble.com/Newbie-issues-with-SQLite-amp-C-td65823.html
Thanks.
"In order for this to work successfully, it must be able to locate
that file at runtime, which means the
Hello,
I'm having a problem getting VB Express to find SQLite .Net:
1. I went to...
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
... to download sqlite-netFx45-binary-Win32-2012-1.0.84.0.zip
2. Unzipped file in C:\Downloads\SQLite\.Net\1.0.84.0\
3. Launched VB Express
On Mon, 25 Mar 2013 17:46:17 -0400,
wrote:
>I installed slqite, its sqlite3 command line interface, and a GUI admin
>console. Have built and populated a couple of databases. But what I really
>want to do is to connect to sqlite databases from Visual Studio 2012 using
On Fri, 01 Mar 2013 18:08:43 +0100, Bernd Lehmkuhl
wrote:
>I asked Joe Mistachkin a while back the same. Here's what he replied:
>
>Am 21.09.2012 00:35, schrieb Joe Mistachkin:
>> Bernd wrote:
>>>
>>> Could you elaborate on why I should avoid doing as I do at the moment?
>>>
>>
>>
On Tue, 26 Feb 2013 19:45:27 -0500, Kevin Benson
wrote:
>> Right, but while the first DLL will be found since it's now part of
>> the project (Project > Add Reference), the wiki doesn't say that this
>> doesn't take care of the other DLL.
On Tue, 26 Feb 2013 18:44:28 -0500, Kevin Benson
wrote:
>The directory doesn't *HAVE* to be called ...\Externals. You pick the name,
>any name, and then tell Visual Studio, that is all ;-)
Right, but while the first DLL will be found since it's now part of
the project
On Tue, 26 Feb 2013 13:09:10 -0500, Kevin Benson
wrote:
>Because there are actually a number of different ways the (CLR)untime
>locates assemblies, I ~believe~ the FAQ only attempts to offer a general
>advisement about the "Externals" folder as a *HINT*. The rest is up
Next, just to check, I reinstalled a fresh Windows7 + VS Express 201
to try the "Precompiled binaries no bundle" this time.
Even with the VC++ 2012 runtime, it still complained about
"SQLite.Interop.dll : The specified module could not be found".
Turns out the wiki is half-wrong: When using the
On Tue, 26 Feb 2013 15:28:13 +0100, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>but it fails on the second line with "Type SQLiteCommand is not
>defined". Is there another component I need to install?
Got it: It just needs the following line at the top of the file:
Impo
After installing "Visual Studio Express 2012 for Windows Desktop", I
downloaded and ran "Setups for 32-bit Windows (.Net Framework 4.5)
bundle 1.0.84.0".
I left the default option checked "Generate native images for the
assemblies and install the images in the native image cache", and
didn't
On Tue, 26 Feb 2013 04:08:26 -0500, Kevin Benson
wrote:
>*(8) How do I install System.Data.SQLite on a development machine?*
Thanks, but I still want to understand what the difference is between
all the options in the Downloads page
>Strictly speaking, there is no need
On Mon, 25 Feb 2013 22:32:26 +, Simon Slavin
wrote:
>There is no particular version of SQLite installed on your computer, and you
>don't have to worry about downloading the latest version of SQLite.
I installed it to use SQLite with VB.Net, and would like to upgrade to
On Mon, 25 Feb 2013 15:18:17 +0100, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>When do we need the design-time components? Which package should I use
>for development + deployment onto users' host?
I'm not clear about which package to install on a development host,
and whic
Hello
I'm running the 32-bit version of XPSP3, whose "Add and Remove
Programs" show that I have "QQLite ADO.NET 2*0/3.5 Provider 1.065.0"
from Phoenix Software Solutions, LLC (http://sqlite.phxsoftware.com).
Now that SQLite.Ado.Net is handled by www.slite.org, what is the right
way to
On Mon, 10 Dec 2012 15:07:05 +0100, Noel Frankinet
wrote:
>It's probably a good way to get something working, but you loose the
>cross-platform
I know, but Windows is 95% of the market for end-users, cross-platform
is a pain to write, they take longer to load and always
On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin
wrote:
>There are lots of people who manipulate data that way, but they tend to export
> their data from the SQLite database into their favourite spreadsheet app,
> do the manipulation there, then reimport to SQLite.
> This
On Sun, 09 Dec 2012 14:15:30 +0100, Olaf Schmidt
wrote:
>The only thing remaining for a decent workflow, which in
>the end is based on SQLite-storage, would then be a small
>batch-program or -script, which ensures the SQLite-To-CSV
>conversion (the sqlite-commandline-tool could do
On Sun, 9 Dec 2012 07:42:08 -0600, "Michael Black"
wrote:
>Generally speaking database and spreadsheet functionality are not similar
>enough to combine.
Thanks for the input. Indee, maybe the two concepts are just too
different.
On Sun, 9 Dec 2012 11:40:15 +, Simon Slavin
wrote:
>If you think you can make money by providing a basic app, write one and market
>it.
>
>People don't want one. If they have already paid for and learned to use
>Excel, they'll use that.
> If they haven't, they'll use
On Sun, 09 Dec 2012 00:04:40 +0100, Olaf Schmidt
wrote:
>If no such special Formatting is needed, then the
>term "DataGrid" is the more common one, since
>"real SpreadSheet functionality" is usually associated
>with the extended requirements (at individual cell-level)
>I've listed
On Sun, 09 Dec 2012 00:49:03 +0100, Jean-Christophe Deschamps
wrote:
>What are those $20 suppose to pay for?
Licenses by users interested in buying that utility optimized to build
lists and sort data much better than in Excel (which isn't meant for
that, but people use it
On Sat, 08 Dec 2012 23:30:09 +0100, Jean-Christophe Deschamps
wrote:
>Either use a full-blown SQLite DB manager (e.g. the free version of
>SQLite Expert among others) or develop a simple script based on an
>ad-hoc ListView and SQLite functions using something like AutoIt.
>
On Sat, 8 Dec 2012 22:34:28 +, Simon Slavin
wrote:
>Google 'sqlite database editor'
Thanks. I'll check 'em out, although it's very likely those are meant
for computer people, not regular folks.
___
sqlite-users mailing list
On Sat, 8 Dec 2012 20:58:17 +, Simon Slavin
wrote:
>On the other hand, if you put in the great amount of effort to write
>a general tool and clean it up so other people can use it,
>it requires enough time that you'll want to charge for your work.
>Hence the large
On Sat, 8 Dec 2012 09:49:09 -0800, Peter Haworth
wrote:
>As others have mentioned, there are several third party products out there
>that will do something similar to what you want. My SQLiteAdmin tool has a
>grid view of data in a table. You can't edit directly in the table but
On Fri, 07 Dec 2012 19:01:27 +0100, "noel.frankinet"
wrote:
>The best route is tcl/tk + sqlite I think, tcl and sqlite works
>naturally together and tcl/tk has a nice table widget to edit data.
>Everything can be bundled together with a tclkit. Et voilà, a killer
On Fri, 7 Dec 2012 20:22:56 -0500,
da...@dandymadeproductions.com wrote:
>Or perhaps MyJSQLView
>Be sure to install Xerial JDBC jar in jre/lib/ext/
>
>http://myjsqlview.org
>http://www.xerial.org
Thanks for the tip. Java + JDBC + SQLite seems a bit heavy, though.
On Fri, 7 Dec 2012 16:37:51 -0800, Tom Lynn
wrote:
>Why not use LibreOffice or OpenOffice with the odbc driver for SQLite?
Too heavy just to make a list.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Fri, 7 Dec 2012 18:15:11 +, Rob Richardson
wrote:
>My favorite is SQLiteSpy because it's fast, even though you can't insert or
> update data in its grid view (you have to write insert or update queries
>to do that, which I admit is a pain, but most of the time
On Fri, 7 Dec 2012 16:02:13 +, "Duquette, William H (318K)"
wrote:
>I don't think the OP really cares about linking SQLite to a spreadsheet.
>If I'm reading him correctly, he's just looking for an easy way to
>populate SQLite database tables using a simple GUI
On Fri, 7 Dec 2012 13:43:03 +, "Black, Michael (IS)"
wrote:
>http://www.sqlmaestro.com
>May do what you want...
Thanks. I'll check that their SQLite tool does.
www.sqlmaestro.com/products/sqlite/
___
sqlite-users mailing
On Fri, 7 Dec 2012 08:39:07 -0500, Kevin Benson
wrote:
>http://sqliteforexcel.codeplex.com/
>
>This project, *SQLite for Excel*, is a lightweight wrapper to give access
>to the SQLite3 library from VBA. It provides a high-performance path to the
>SQLite3 API functions,
On Fri, 7 Dec 2012 13:37:45 +, Simon Slavin
wrote:
>Use the free SQLite shell tool downloadable from the SQLite site.
>
>Write your own interface in PHP using the sqlite3 interface which does exactly
>what you want.
Thanks but before I build my own, I wanted to check
On Fri, 7 Dec 2012 11:27:57 -0200, Jonas Malaco Filho
wrote:
>Maybe you can achieve this if you use ODBC connectors and Excel Tables.
Thanks for the info, but having to buy MS Office and install/configure
ODBC is a bit on the heavy site. I for one would be interested
Hello
I need to enter a bunch of items into a table that I can later read
from a web app.
I was wondering if someone had come up with a Windows application that
would...
- use Sqliteto host the data
- make it very easy to add a table anc columns (possibly several
related tables)
- display a
The crash occur with sqlite 3.7.8 on line below:
u.bp.pC->nullRow = (u8)u.bp.res;
u.bp.pC did not reference a valid address.
here is the stack
(gdb) bt
#0 0x00055000 in sqlite3VdbeExec (p=0x18e9d8) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:68038
#1 0x96d2 in sqlite3_step
Thank you a lot for your answer.
Do you known more about this bug? Is there any other documentation?
Does it affect other code? Will apple fix it soon?
My currenct solution was using sqlite 3.7.1
Regards
Gilles Vollant
Le jeudi 1 décembre 2011, James Berry <ja...@jberry.us> a écrit :
&g
Hello,
I'm using a recompiled version of SQLite in one project (I need FTS3 and now
FTS4 support, which is not avaiable in the sqlite included in iOS).
So I just include "sqlite3.c" and "sqlite3.h" in my XCode projet.
I've discovered that using LLVM compiler of Xcode 4.2.1 on Mac OS Lion
On Wed, 29 Jun 2011 13:21:21 +0200, Roger Andersson
wrote:
>:) No CAST needed
>SELECT round((COUNT(rowid))/(SELECT COUNT(*)*0.01 FROM people),2) FROM
>people WHERE zip="12345";
Thanks everyone.
___
sqlite-users mailing list
On Wed, 29 Jun 2011 11:33:15 +0200, Roger Andersson
wrote:
>SELECT (COUNT(rowid)*100)/(select count(*) from people) FROM people WHERE
>zip="12345";
Thanks, that worked:
SELECT COUNT(*) FROM people;
400599
SELECT COUNT(*) FROM people WHERE zip="12345";
12521
SELECT
Hello
Using a table that lists people and the zipcode where they live, I
need to compute the percentage of those living in, say, NYC.
I googled for this, but I'm not sure how to do this in SQLite.
I wonder if it's done through a sub-query or maybe some temporary
variable?
This computes
On Tue, 28 Jun 2011 07:48:09 -0400, Richard Hipp
wrote:
>SQLite uses only unicode (utf8 by default, but it also works with utf16).
>Probably your DBF file was exported as MBCS. You need to convert the MBCS
>from the export into utf8 or utf16 prior to import into SQLite.
Thanks
Hello
After importing DBF files into SQLite, it looks like data are in
Unicode, so I get funny characters when running sqlite3.exe in a DOS
box on Windows:
sqlite> select * from varmod_stent2010 limit 5;
A10|BE|Industrie manufacturiFre, industries extractives et autres
On Mon, 27 Jun 2011 18:05:41 +0200, Dominique Pellé
wrote:
>Spatialite (extension of SQLite) implements VirtualDbf and VirtualShp.
Thanks for the info. I'm not sure I understand what Spatialite is
("The SpatiaLite extension enables SQLite to support spatial data too
On Mon, 27 Jun 2011 17:14:52 +0400, Alexey Pechnikov
wrote:
>1. sqlite3-dbf - converter of XBase / FoxPro tables to SQLite
>http://sqlite.mobigroup.ru/wiki?name=sqlite3-dbf
Thanks Alexey, worked the first time:
# dpkg -i sqlite3-dbf_2010.08.16_i386.deb
# sqlite3-dbf
On Mon, 27 Jun 2011 14:22:43 +0100, Carlos Rocha
wrote:
>I think you'll find what you need here
>http://www.vlsoftware.net/
Thanks for the link.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Mon, 27 Jun 2011 14:57:31 +0200, Stephan Beal
wrote:
>Google suggests several:
Yes, but I'd like to save time by not having to evaluate them if
someone's done this recently.
There are only two converters listed on the site, and they seem to
require FoxPro for DOS
On Mon, 27 Jun 2011 13:42:33 +0100, Simon Slavin
wrote:
>Dump the contents as text and use the SQLite command-line shell to import it.
Thanks for the tip, but I don't have the DBase application, just the
file (it's actually three files: Two small ones with the column
Hello
I have a 87MB file in DBF format that I'd like to import into SQLite.
What is the best tool for this, free or affordable?
Thank you.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Fri, 15 Apr 2011 09:23:10 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>I need to write a Makefile to cross-compile amalgamation-3070601 to
>generate the static and shared libraries.
For the benefit of other newbies who might need this:
BASE=/opt/toolchain
CC=bfin-linux-u
Hello
I need to write a Makefile to cross-compile amalgamation-3070601 to
generate the static and shared libraries.
Is this the right way?
==
#Path added to PATH
CC=bfin-linux-uclibc-gcc
AR=bfin-linux-uclibc-ar rcu
CFLAGS=-O2 -Wall -I/usr/src/baps/uClinux-dist/linux-2.6.x/include
At 22:38 02/12/2010, Mike Frysinger wrote:
>that doesnt really make sense. just build sqlite in the dist and
>look at how configure is run.
If I got it right, the SQLite package that lives in the uClinux-dist
uses the GNU build system
On Thu, 2 Dec 2010 15:17:28 -0500, Eric Smith
wrote:
>You can do it on the command line -- just try it.
Sorry guys for being dense: After rereading the above, it clicked: The
"-lpthread" option must be put on the line when linking the three
object files to create the final
On Thu, 2 Dec 2010 13:50:30 -0600, "Black, Michael (IS)"
wrote:
>The -lpthread goes on the FINAL link you do with your OBJS.
Sorry about that :-/ Apparently, gcc will compile and link in one go.
Is a Makefile required to add the -lpthread switch, or can this be
done on
On Thu, 2 Dec 2010 12:38:18 -0600, "Black, Michael (IS)"
wrote:
>If you need threadsafe just add -lpthread to your final link
I get an error when using "-lpthread", which I guess makes sense,
since I don't have the pthread library cross-compiled:
=
#
On Thu, 2 Dec 2010 08:06:13 -0600, "Black, Michael (IS)"
wrote:
>You're linking your two .o into the shared library instead of sqlite3.o
>
>src/$(LIBNAME): $(OBJS)
>$(CC) $(CFLAGS) $(LIB_OPTION) $(DRIVER_LIBS) -o $@ sqlite3.o
Thanks a bunch,
At 17:47 01/12/2010, Mike Frysinger wrote:
>why dont you consult the Blackfin uclinux-dist to see how it's doing it ?
I did, but it's the same code as from www.sqlite.org so doesn't
contain infos on what parameters to pass "configure" to compile for
the Blackfin.
After cd'ing to
On Wed, 1 Dec 2010 11:10:54 -0600, "Black, Michael (IS)"
wrote:
>I don't think you need to do the LDFLAGS thing...
>
>gcc -O2 -fpic -shared -Wl,-soname,sqlite3.so -o sqlite3.so sqlite3.c
>
>Works fine for me. Though I'm not using the Blackfin compiler...
Thanks
On Wed, 01 Dec 2010 17:28:29 +0100, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>Any help appreciated on cross-compiling SQLite using the Autoconf
>tool.
Without necessarily knowing what I'm doing, the following does compile
without errors:
CC="/opt/uClinux/bfin-linux-uclibc/
Hello
I need to cross-compile SQLite on an x86 Ubuntu host for a device
using the Blackfin CPU and the uClinux distribution.
I downloaded sqlite-amalgamation-3.7.3.tar.gz, since it's "the
recommended source distribution for all Unix and Unix-like platforms".
Then, I read the README and
On Sun, 3 Oct 2010 17:07:04 +0100, Simon Slavin
wrote:
>There are several tools around to synchronise specific databases,
>and they depend on knowing how those specific databases work
> and what the data means. But devising a general synch tool that
> would be useful for
Hello
I was wondering if someone came up with a tool to sync an SQLite
database with smartphones (Blackberry, iPhone, Android, etc.)?
I've read about SyncML and OpenSync, but they seem to be still under
development.
Thank you.
___
sqlite-users
Hi,
How pertinent is this source code (are the calls made in the right order?,...)?
Could this source code be a rather good basis for "Asynchronous I/O modules for
SQLite"?
Thanks a lot,
Best regards,
Gilles
___
sqlite-users mailing l
Hello,
Here follows, my Async IO implementation (at the moment, I just have tested the
Win32 part. I will test soon the pthreads part).
The main thread creates a worker thread (in charge of running the
sqlite3async_run function).
In "Build options/compiler/defines", it seems that the following
serialized modes must be used?
Thanks a lot,
Best regards,
Gilles
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Tue, 27 Jul 2010 22:56:23 -0700, Roger Binns
wrote:
>You can if you quote it. Note use double quotes to quote table & column
>names, single quotes for strings. You can also quote names using square
>brackets - eg [table name].
Thanks Roger for the tip.
On Tue, 27 Jul 2010 14:40:11 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>I'm having a problem with this PHP5 script running under Nginx +
>PHP5-FPM and PDO-SQLite3
Found it: For newbies like me... "table" is a reserved name so cannot
be used as a name to table:
Hello
I'm having a problem with this PHP5 script running under Nginx +
PHP5-FPM and PDO-SQLite3:
=
exec("CREATE TABLE IF NOT EXISTS table (id INTEGER PRIMARY
KEY AUTOINCREMENT, name VARCHAR(255))");
$dbh->exec("INSERT INTO table (name) VALUES ('dummy')");
$dbh = null;
On Sat, 24 Jul 2010 18:50:05 +0200, Kees Nuyt
wrote:
>There's also pdo_sqlite_external which uses the sqlite3.dll
>the user provides, so you can use the latest and greatest
>sqlite version without having to wait for incorporation in
>PHP or PDO itself.
Thanks guys for the
Hello
I'm using the pre-compiled PHP5-FPM/FastCGI (www.php-fpm.org) which
seem to contain the following DB connectors:
PDO drivers mysql, sqlite, sqlite2
pdo_mysql 5.1.48
pdo_sqlite 3.6.22
SQLite 2.8.17
sqlite3 3.6.22
So from the above, it looks like this binary supports access to
MySQL(i)
Hello
Using the script below to build an ipkg package for OpenWrt, I need to
add the command-line exe, ie. sqlite3.exe on Windows:
=
# cat sqlite3.mk
#
# sqlite3 for the Blackfin
# David Rowe March 2008
#
# usage: make -f sqlite3.mk sqlite3-package
#
# Thanks OpenWRT for
On Tue, 1 Jun 2010 15:13:57 -0400, Doug Currie
wrote:
>You may find eLua interesting. http://www.eluaproject.net/
>The supported platforms are heavily ARM based, but in the same performance
>class as Blackfin.
Thanks very much for the link. I'll go check if it can be
On Tue, 1 Jun 2010 11:33:36 -0400 (EDT), Rob Sciuk
wrote:
>As you may be aware, SQLite and Tcl/Tk have an affinity which was not
>entirely accidental. There are threads which discuss compiling Tcl for
>Arm/Linux:
>
On Mon, 24 May 2010 12:28:14 +0400, Max Vlasov
wrote:
>For Delphi I successfully used files from http://www.aducom.com to
>statically link sqlite files compiled with bcc (Borland command-line c
>compiler freely available now) with Delphi. Also the components of
>aducom.com
On Tue, 1 Jun 2010 08:40:15 -0300 (BRT), Israel Lins Albuquerque
wrote:
>Look for C++ QT framework! http://qt.nokia.com/
Thanks, I'll check it out.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Tue, 1 Jun 2010 11:57:29 +0100, Simon Slavin
wrote:
>The obvious solution is to use PHP, and have it use one of the three
>avaialable sets of SQLite calls.
Can I compile a PHP script + modules into something that will run on
embedded devices? They don't have enough RAM
1 - 100 of 303 matches
Mail list logo