At 14:08 06/08/2007 +0100, "Edwin Eyan Moragas" wrote:
2) anybody ever implemented something like a single process of sqlite
doing queries for a lot of networked clients?
Am working on this, in Classic VB5: Winsock control on the server, Inet
control on the client, the client thinks it's
Hi,
I have sqlite3.exe
When I execute it, the following prompt will be displayed
sqlite>
I would like to know how to create a database?
I tried,
sqlite>sqlite3 test.db
...>^Z
It is not creating. I am getting an error like
On 8/6/07, John Stanton <[EMAIL PROTECTED]> wrote:
> >
> We use a single process server as an Sqlite server. It works well
> because it obeys certain constraints:
>o Transactions are always short
>o It has many users and many Sqlite databases, but each database
> does not have a large
On 8/6/07, Christian Smith <[EMAIL PROTECTED]> wrote:
> > 2) anybody ever implemented something like a single
> > process of sqlite doing queries for a lot of networked
> > clients?
>
>
> A few people have implemented such a solution. It loses one of the
> benefits of SQLite, however, in that
Yeah, there are significant locking issues in sqlite under Qt, in
particular if you hold a query open (either via QSqlQuery, or
QSqlTableModel et al). clear() is your friend when things start going
south. Also, another gotcha to watch out for, if the query fails, check
the queries lastError(), not
"Chase" <[EMAIL PROTECTED]> wrote:
> okay, wait sorry wrong question.
>
> here's the deal. i want this trigger to fire -- and insert valid guids
> into a table -- even outside the context of my app.
>
> using sqlite3_create_function(), i can create a sort of temporary
> function that
--- Chase <[EMAIL PROTECTED]> wrote:
> here's the deal. i want this trigger to fire -- and insert valid guids
> into a table -- even outside the context of my app.
>
> using sqlite3_create_function(), i can create a sort of temporary
> function that only works from with my app (or other
On 8/6/07, Severin Müller <[EMAIL PROTECTED]> wrote:
> I'm trying to use SQLite3 for my File, because I thinks it's a great API and
> easy to use. But I'm having trouble to use the library properly.
> When i run the Program, I get get the following Error:
> Unhandled exception… so its some kind
Dear Clay,
Is there any way to request the digest form of the mailing list? I am
flooded with e-mails, and it is too much form me to handle...
Regars: layosh
-Original Message-
From: Clay Dowling [mailto:[EMAIL PROTECTED]
Sent: Monday, August 06, 2007 4:27 PM
To:
Severin,
The "sqlite3_open( )" call is hard to break. Try breakpointing into the
sqlite3 source code to see what the failure is.
Lee Crain
__
-Original Message-
From: Severin Müller [mailto:[EMAIL PROTECTED]
Sent: Monday, August 06, 2007 4:42 PM
To:
I think you'd have to actually add your function into the SQLite source, and
recompile. My guess, not being a C guy, would be for you to have a look at the
SQLite source (maybe in func.c?). Since you already have a C function to do
what you want, it seems pretty straightforward :-))
-Clark
Hey
I don't even get to call the sqlite3_errmsg() function. My Program crashes
with the call sqlite3_open(filename,);
I'm been spending hours now, to figure out, what may cause that crap :) I
really have no idea...
-Original Message-
From: Clay Dowling [mailto:[EMAIL PROTECTED]
Sent:
okay, wait sorry wrong question.
here's the deal. i want this trigger to fire -- and insert valid guids
into a table -- even outside the context of my app.
using sqlite3_create_function(), i can create a sort of temporary
function that only works from with my app (or other running
You are probably looking for sqlite3_create_function:
http://www.sqlite.org/capi3ref.html#sqlite3_create_function
Regards,
Eugene Wee
Chase wrote:
i need a trigger to create and insert a new guid into a table, but
apparently there is no built-in function for creating guids in sqlite.
i can
Yes, thanks, I just found out.
It can work without the WHERE clauses.
RBS
-Original Message-
From: Gerry Snyder [mailto:[EMAIL PROTECTED]
Sent: 06 August 2007 21:59
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Multiple fields update
RB Smissaert wrote:
> I am sure this SQL used
RB Smissaert wrote:
I am sure this SQL used to be fine with SQLite:
update table1
set
field1 = 0 where field1 = 2,
field2 = 3 where field2 = 2
Now however I get a syntax error near ,
Has this changed?
RBS
Does the thread below ring a bell? Does it help?
Gerry
i need a trigger to create and insert a new guid into a table, but
apparently there is no built-in function for creating guids in sqlite.
i can create the guid in C using uuid_generate() and then
uuid_unparse() to get it into a string format.
but how can i call that c code from a trigger?
I am sure this SQL used to be fine with SQLite:
update table1
set
field1 = 0 where field1 = 2,
field2 = 3 where field2 = 2
Now however I get a syntax error near ,
Has this changed?
RBS
-
To unsubscribe, send email
Check the result code of sqlite3_open and use the error message from
sqlite3_errmsg as the message in your exception. Then you'll know what's
wrong.
Clay
Severin Müller wrote:
> Hi
>
>
>
> Im trying to use SQLite3 for my File, but Im having trouble to use the
> library properly.
>
>
>
> I
Hi
Im trying to use SQLite3 for my File, but Im having trouble to use the
library properly.
I Have to following Code:
void Nickserv::write_nickname(std::string nick,std::string pass,std::string
email,User user)
{
#ifdef _WIN32
const char *filename = "db\\Nickserv.db";
Hello
Im trying to use SQLite3 for my File, because I thinks its a great API and
easy to use. But Im having trouble to use the library properly.
I Have to following Code:
void Nickserv::write_nickname(std::string nick,std::string pass,std::string
email,User user)
{
#ifdef _WIN32
Does anyone have any experience compiling SQLite to run in the Micrium
operating system on an ARM9 platform?
http://www.micrium.com/
Thank you.
Shawn M. Downey
MPR Associates
10 Maxwell Drive, Suite 204
Clifton Park, New York 12065
518-831-7544 (work)
860-508-5015 (cell)
Does anyone have any experience compiling SQLite to run in the Micrium
operating system on an ARM9 platform?
http://www.micrium.com/
Thank you.
Shawn M. Downey
MPR Associates
10 Maxwell Drive, Suite 204
Clifton Park, New York 12065
518-831-7544 (work)
860-508-5015 (cell)
How can I do the same with prepare statements ?
Is it possible for me to prepare 10,000 in a loop and then surround them with BEGIN TRANSACTCION AND END TRANSACTION ?
Yes. As an added benefit the preparation would mean that the SQL
statement does not have to be parsed on each iteration of
Everyone has suggested the use of prepared statements.
I was actually inserting ~10,000 records with great results using BEGIN
TRANSACTION; and END TRANSACTION; I was making 1 big string of insert
statements and executing them all at once.
It was extremely fast.
How can I do
Now you can take comparisons too far and then they won't be useful
anymore. If you want I will explain
the setup here and you will see.
RBS
> On 8/6/07, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
>> Yes, sure if it fails you might get wet, but I would try the few planks
>> I
>> got and see
Very true, so I will give up on you then.
RBS
> You can lead a horse to water but you cannot make it drink.
>
> [EMAIL PROTECTED] wrote:
>> Yes, sure if it fails you might get wet, but I would try the few planks
>> I
>> got and see which one fits best and not bother with a mathematical
>>
On 8/6/07, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Yes, sure if it fails you might get wet, but I would try the few planks I
> got and see which one fits best and not bother with a mathematical model.
> All a bit academic as you don't know the situation
> I am dealing with.
Even in the
You can lead a horse to water but you cannot make it drink.
[EMAIL PROTECTED] wrote:
Yes, sure if it fails you might get wet, but I would try the few planks I
got and see which one fits best and not bother with a mathematical model.
All a bit academic as you don't know the situation
I am
Igor Mironchick wrote:
Hi.
How can I improve productivity of this code:
a_messenger_t::data_buff_t --> std::deque< some_struct >
//
char * errors = 0;
for(
Chris Cole wrote:
Hello,
I was wondering what would be an example sql command that would allow
you to return the check constraints on a specific column in a database?
Thanks,
--Chris
I've found that the
.schema {table}
command will list the checks being performed but I can't find a
way
Yes, sure if it fails you might get wet, but I would try the few planks I
got and see which one fits best and not bother with a mathematical model.
All a bit academic as you don't know the situation
I am dealing with.
RBS
> Absolutely. Big bridge or small bridge, if it fails you fall in the
>
Edwin Eyan Moragas wrote:
hi group,
i have several small questions for the group any
experiences or thoughts shared would be greatly
appreciated.
1) anybody used sqlite as a sql server? i'm thinking
of say using the embedded sqlite in PHP5 or similar.
2) anybody ever implemented something
Absolutely. Big bridge or small bridge, if it fails you fall in the water.
It looks as if the bridge in Minneapolis failed because construction
workers moved tons of repaving material onto part of it and overstressed
that section. A few calculations could have saved the catastrophe.
I saw
Updates during a SELECT work fine once you correct these mistakes:
You shouldn't be using SQLITE_STATIC as buf is temporary - use
SQLITE_TRANSIENT instead.
The two different ways you populate the table are different.
If createUsingExec is 1, your are inserting strings beginning with
'name is
or with a "like" operator
sqlite> create table x (t);
sqlite> insert into x values (442);
sqlite> insert into x values (44);
sqlite> insert into x values (4454);
select * from x where 4429845 like t||"%" order by length(t) desc limit 1;
442
Quoting RaghavendraK 70574 <[EMAIL PROTECTED]>:
Igor Mironchick uttered:
Thx, very helpfull reply. One more question: is it need to do "END" after
"BEGIN" or enought "COMMIT"?
You can use "COMMIT". Probably should do, as it is more descriptive about
what is happening. Check the docs for transaction commands:
Edwin Eyan Moragas uttered:
hi group,
i have several small questions for the group any
experiences or thoughts shared would be greatly
appreciated.
1) anybody used sqlite as a sql server? i'm thinking
of say using the embedded sqlite in PHP5 or similar.
2) anybody ever implemented something
Thanks .
I found similar one in the mailing list archive.
create table test (t text);
insert into test values ('9');
insert into test values ('98');
insert into test values ('986');
insert into test values ('9867');
select * from test where '98555' like t || '%' order by t desc limit 1;
Hello,
I was wondering what would be an example sql command that would allow
you to return the check constraints on a specific column in a database?
Thanks,
--Chris
-
To unsubscribe, send email to [EMAIL PROTECTED]
Hi Ragha,
C:\Joinerysoft\JMS\TestArea>sqlite3 tst.db
SQLite version 3.4.0
Enter ".help" for instructions
sqlite>
sqlite> create table tst( c1 integer, c2 test );
sqlite> insert into tst values( 1, '44' );
sqlite> insert into tst values( 2, '442' );
sqlite> insert into tst values( 3, '4454' );
Hi,
How to form the SQL query(in SQLite) for the following problem below
table:
44
442
4454
Input String: 4429845
Expected output from SQL query: 442
regards
ragha
**
This email and its attachments
Hi Stev,
Prepared statements are best option, however try sqlite3_mprintf() with
'%q' as format specifier which escapes every '\' character.
Find more info in http://sqlite.org/capi3ref.html.
Bharath Booshan L.
On 8/6/07 11:50 AM, "Stephen Sutherland" <[EMAIL PROTECTED]>
wrote:
> Hi ;
>
Hi Stev,
Why not just use prepared statements?
Regards,
Eugene Wee
Stephen Sutherland wrote:
Hi ;
I am trying to treat a string before passing it through my SQL statement into the database.
I know that a single apostrophe will break the SQL statement.
So I have to replace them
On 8/5/07, Stephen Sutherland <[EMAIL PROTECTED]> wrote:
> I am trying to treat a string before passing it through my SQL statement
> into the database.
>
> I know that a single apostrophe will break the SQL statement.
> So I have to replace them all to double apostrophes.
> But are
Hi ;
I am trying to treat a string before passing it through my SQL statement into
the database.
I know that a single apostrophe will break the SQL statement.
So I have to replace them all to double apostrophes.
Question #1:
What may I ask is the c or C++ code to accomplish
46 matches
Mail list logo