Hi,
Thanks to you to help me with this problem.
As I do not require special features (only insert/select/order by/delete),
I think it is maybe easier to use an old version of SQLite. I will try
with 3.6.10 as said by Max. If it does not work I will try an older one.
Regards,
Joel
I will be out of the office starting 21/12/2010 and will not return until
05/01/2011.
For urgent matter you can directly contact me on following number :
+32 476962721
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 21 Dec 2010, at 14:19, Simon Slavin wrote:
>
> On 21 Dec 2010, at 1:44pm, Philip Graham Willoughby wrote:
>
>> Implementing an SQLite-based server does not obviously enable this in and of
>> itself. If you could open a database on a remote machine using its filename
>> as the OP was
Recent changes to FTS3 apparently require that SQLite must be compiled
with pager pragmas, otherwise FTS3 will cause a division by zero
exception as I have experienced right now.
This means that the FTS3 extension can crash an application if the core
SQLite library is compiled with
Wednesday, December 22, 2010, 1:19:25 AM, you wrote:
SS> On 21 Dec 2010, at 1:44pm, Philip Graham Willoughby wrote:
>> Implementing an SQLite-based server does not obviously enable this in and of
>> itself. If you could open a database on a remote machine using its filename
>> as the OP was
and what about using a DCOM like technology to open a distant database?
the sqlite API will stay the same but behind the scene, it will access your
server using a DCOM like technology?
___
sqlite-users mailing list
sqlite-users@sqlite.org
Just my two cents...
A SQLite Server would be userful. I have considered creating this myself. I
have thought that it would need to be kept zero config and it should be
provided
in amalgamation form to keep simple to embed in applications. Wouldn't need
incredible throughput as it is a
Hi, erveryone
I'm a beginner.
I think sqlite can automatically do commit or rollback when sql
statments(insert,update,or delete) are finished.
Is it correct? Or it must use "Begin transation"?
Anybody can give me some examples?
Thanks.
On 22 Dec 2010, at 12:45am, Jeff Archer wrote:
> A SQLite Server would be userful. I have considered creating this myself. I
> have thought that it would need to be kept zero config and it should be
> provided
> in amalgamation form to keep simple to embed in applications. Wouldn't need
>
From: Simon Slavin Date: Tue, 21 Dec 2010 14:19:25 +
>This was my first thought when I considered implementing an SQLite-over-IP
>protocol: that there was no user model and therefore no need for passwords.
>Mounting a >database on the server would mean that anyone who
zhaoyinghuan wrote:
> I think sqlite can automatically do commit or rollback when sql
> statments(insert,update,or delete) are finished.
> Is it correct? Or it must use "Begin transation"?
> Anybody can give me some examples?
You can start an explicit transaction by
On 22 Dec 2010, at 13:12, Simon Slavin wrote:
>
> You do mention something worthwhile: if you had a server/client version of
> SQLite you could get rid of all the code to do with file sharing and locking.
> That's quite a lot of code, if you include all the PRAGMAs and related
> programming
On 22 Dec 2010, at 2:41pm, Philip Graham Willoughby wrote:
> You would need to reintroduce practically everything you think you can get
> rid of if you wish to ensure that there is only one process and you are
> intending to provide a facility for two transactions to be active
> concurrently.
Why not doing it with DCOM or Corba or what ever even the sockets?
but hidden behind the same API of SQLite. The "real" sqlite lib will be on
the server.
is it called "remote procedure call"?
___
sqlite-users mailing list
sqlite-users@sqlite.org
If I define a custom SQL function in Tcl using the SQLite "$db function"
command, is there any way to make the function return NULL? I'm guessing not.
Thanks!
--
Will Duquette -- william.h.duque...@jpl.nasa.gov
Athena Development Lead -- Jet Propulsion Laboratory
"It's amazing what you can do
On Wed, Dec 22, 2010 at 1:16 PM, Duquette, William H (318K) <
william.h.duque...@jpl.nasa.gov> wrote:
> If I define a custom SQL function in Tcl using the SQLite "$db function"
> command, is there any way to make the function return NULL? I'm guessing
> not.
>
There is no way to get a Tcl
On 12/22/10 10:35 AM, "Richard Hipp" wrote:
On Wed, Dec 22, 2010 at 1:16 PM, Duquette, William H (318K) <
william.h.duque...@jpl.nasa.gov> wrote:
> If I define a custom SQL function in Tcl using the SQLite "$db function"
> command, is there any way to make the function return
On 22 Dec 2010, at 6:35pm, Richard Hipp wrote:
> On Wed, Dec 22, 2010 at 1:16 PM, Duquette, William H (318K) <
> william.h.duque...@jpl.nasa.gov> wrote:
>
>> If I define a custom SQL function in Tcl using the SQLite "$db function"
>> command, is there any way to make the function return NULL?
Paradigma Software's Valentina Studio Pro is a powerful creation, analysis
and reporting tool for database developers. With Valentina Studio 4.8, we
added support for SQLite databases. This means the built in features like
Visual SQL Builder, Diagrams, Report printing, and more are available for
On 12/22/10 10:52 AM, "Simon Slavin" wrote:
>> There is no way to get a Tcl function to return NULL, since TCL has no
>> concept of NULL. So, no, sadly, you cannot get an SQLite function
>> implemented in Tcl to return NULL.
>
> ... but you might find reading this useful:
On Wed, Dec 22, 2010 at 1:41 PM, Duquette, William H (318K) <
william.h.duque...@jpl.nasa.gov> wrote:
> On 12/22/10 10:35 AM, "Richard Hipp" wrote:
>
> On Wed, Dec 22, 2010 at 1:16 PM, Duquette, William H (318K) <
> william.h.duque...@jpl.nasa.gov> wrote:
>
> > If I define a
This is where I think the problems will crop up. Can you imagine making a
network round trip for each row fetch,
and then for each column fetch of each row (sqlite3_column_type,
sqlite3_column_double, etc).
To avoid that, you would need to fetch a lot (buffer) of data and bring it
back to the
At first I was like "awe, I don't wanna do my homework". I'd have to
recompile all my little utilities and distribute them rather than just
distribute a new DLL and it would be nice to keep our local program
maintainers from "helping" instead of keeping to the officially released
code.
I think you can hide those details,
you can perfectly retrieve all rows (or bunch of rows) and then do not make
any network access, but still simulate the sqlite API.
I would keep the connection open, it doesn't block other clients to connect
as well, just the server has to be multi-process.
the
Hi,
looking for help please. Database is a db3, fields are varchar. The problem
is that a necessary updating service for this database looks for 'blank'
fields, of which there are many, and if there are any, updates ALL the info for
that record. The problem is that I want to update with
On 22 Dec 2010, at 11:55pm, CDN Mark wrote:
> I tried using a statement
> UPDATE Aircraft SET CN = "*" where CN = "";
> as a test which worked, but not for all records. I don't know if the blank
> fields are empty or null
Do a
SELECT length(CN),hex(CN) FROM Aircraft
if that produces too
On 12/22/2010 6:55 PM, CDN Mark wrote:
> I tried using a statement
> UPDATE Aircraft SET CN = "*" where CN = "";
> as a test which worked, but not for all records. I don't know if the blank
> fields are empty or null
I'm not sure I understand the problem. If you are asking how to check
both
Hi Simon,
ran the first example, came back with lots of lines, second test with the just
the 10 returned
9 lines as 0: the second line as 2:3832, don't understand the purpose/meaning
of this
Hi Igor,
not checking for, want to fill in/replace blank or null fields with at least
one character
On 12/22/2010 7:25 PM, CDN Mark wrote:
> Hi Igor,
>
> not checking for, want to fill in/replace blank or null fields with at least
> one character
So, does the statement I've shown not do this? Here it is again:
UPDATE Aircraft SET CN = '*' where CN = '' or CN is null;
In what way does it fail
Hi Igor,
worked using SQLite Database browser/execute SQL but didn't work using an .sql
file which is the way I would be doing it. Tried it again and it did work
using sql file, thanks for your help
___
sqlite-users mailing list
Hi all,
I want to dynamically construct SQL queries that rollback if any part of the
transaction fails. For instance, my app constructs the SQL needed to replace a
trigger definition, such as:
begin immediate;
drop trigger if exists "My Trigger";
create trigger "My Trigger"
... new definition
Quoth BareFeetWare , on 2010-12-23 15:10:30 +1100:
> Is there a way to do this in pure SQL, without my application code
> having to check for errors along the way and then interrogate the
> SQL to look for a "commit" type line and replace it? This seems
> pretty error
On 23/12/2010, at 5:38 PM, Drake Wilson wrote:
> Quoth BareFeetWare , on 2010-12-23 15:10:30 +1100:
>> Is there a way to do this in pure SQL, without my application code
>> having to check for errors along the way and then interrogate the
>> SQL to look for a "commit"
On Thu, Dec 23, 2010 at 9:52 AM, BareFeetWare wrote:
>
> I want to be able to just send a series of SQL commands in a transaction as
> a one block of text and have SQLite tell me either that it succeeded so
> committed, or that it failed so everything has been rolled
34 matches
Mail list logo