I have a table ASSETS with fields (Code Text, Acct1 Text, Acct2 Text).
(There are other fields, and the primary key is a combination of 5 columns)
For one code ('C0') I want to implement a rule that if I attempt to insert a
combination of 'C0'/Acct1/Acct2 it will be ignored if the first two keys
Hi, (SQLite v3.6.17, on ARM with Linux 2.6.18)
I'm currently investigating the applicability of SQLite in an embedded
application. Part of this would be to store configuration data, for
which SQLite seems like a natural fit.
I also have a requirement for exchange of realtime data between
process
´¯¯¯
>No, I meant exactly UCS-2. Because UCS-2 guarantees that all symbols
>are represented by 2 bytes when UTF-16 does not. And I had an
>understanding that Doug said about this 16-bit guarantee. Also if
>we're talking about encoding where any character can be represented by
>a single variable o
rieving local strings. If you don't use
>> the
>> wide-char (16) APIs, you would need to explicitly convert your strings
>> to
>> UTF-8 (which is not the same as ASCII) before handing to SQLite.
>>
>> Doug
>>
>>
>>> -----Original Message-
> Is there really anyone using UCS-2 now or did you mean UTF-16?
No, I meant exactly UCS-2. Because UCS-2 guarantees that all symbols
are represented by 2 bytes when UTF-16 does not. And I had an
understanding that Doug said about this 16-bit guarantee. Also if
we're talking about encoding where a
Hi Pavel,
´¯¯¯
>So conversion between wchar_t and
>UCS-2 encoding is not always as easy as you can think.
`---
Is there really anyone using UCS-2 now or did you mean UTF-16?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080
onvert your strings to
> UTF-8 (which is not the same as ASCII) before handing to SQLite.
>
> Doug
>
>
>> -Original Message-
>> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>> boun...@sqlite.org] On Behalf Of e...@sitadella.com
>> Sent: Thu
sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of e...@sitadella.com
> Sent: Thursday, August 20, 2009 4:21 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] (no subject)
>
> Hi guys,
>
> This is my first post. I am creating a simple do
Hi guys,
This is my first post. I am creating a simple document archiving program
for small businesses. I am creating it in a scripting language called
www.autohotkey.com. I intend to place the SQLite database file on a
network share and use sqlite.dll to access and manipulate it.
In general, eve
--
This message has been scanned for viruses and
dangerous content by Pinpoint, and is
believed to be clean.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
This message has been scanned for viruses and
dangerous content by Pinpoint, and is
believed to be clean.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
humm
--
ArbolOne.org specializes in Custom Web Site Design, Web Site Re Design, Web
Site Template Modifications, Web Site Maintenance, Integration of Payment
Gateways (API's), Database Applications, Custom Applications and much more.
416.838.2057
arbol...@gmail.com
"O Allah, make my love for
> Hello.
>
> I'm using SQLite with a VB wrapper (dhSQLite) for VB6.
>
> The following SQL string works fine for putting together a recordset where
> the DATE field contains only the date of the last day of each month.
>
>
> SQLString = "SELECT date(Date,'start of month','+1 month','-1 day'
Hello.
I'm using SQLite with a VB wrapper (dhSQLite) for VB6.
The following SQL string works fine for putting together a recordset where
the DATE field contains only the date of the last day of each month.
SQLString = "SELECT date(Date,'start of month','+1 month','-1 day') as
Date, " & _
Date: Fri, 19 Jun 2009 14:53:05 -0700
From: Robert Lehr
Subject: Re: [sqlite] async io and locks
To: sqlite-users@sqlite.org
In-Reply-To: <43c62cbb-57db-4d1b-af36-2facf239c...@gmail.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
I have never been able to reply to messag
On Mon, 1 Jun 2009 04:38:37 -0700 (PDT), "Manasi Save"
wrote:
>Hi,
>
>we are developing an application on android we are using SQLite Database
>and on phone we are getting SQLiteException:no such table. but, it is
>working fine on simulator.
>
>Can anyone provide any input on this?
ASCII versus
Hi,
we are developing an application on android we are using SQLite Database
and on phone we are getting SQLiteException:no such table. but, it is
working fine on simulator.
Can anyone provide any input on this?
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
manasi.s...@artific
On Tue, May 26, 2009 at 6:34 PM, John Machin wrote:
> Don't try that with your 100MB database without ensuring that your
> keyboard interrupt mechanism isn't seized up :-)
>
> Perhaps you meant
>
> .schema tablename
I did indeed. I even remember going, "oh, yeah, don't want dump in
this case", bu
On 26/05/2009 7:58 PM, Samuel Baldwin wrote:
> On Tue, May 26, 2009 at 4:45 PM, Martin.Engelschalk
> wrote:
>> select * from sqlite_master;
>
> Or:
> .dump tablename
Don't try that with your 100MB database without ensuring that your
keyboard interrupt mechanism isn't seized up :-)
Perhaps you
On Tue, May 26, 2009 at 4:45 PM, Martin.Engelschalk
wrote:
> select * from sqlite_master;
Or:
.dump tablename
--
Samuel 'Shardz' Baldwin - staticfree.info/~samuel
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mai
Thanks for the information and Sorry for not mentioning the subject.
--
Thanks and Regards,
Manasi Save
> Hi,
>
> select * from sqlite_master;
>
> Martin
>
> PS.: Please provide a subject which summarises your question.
>
> Manasi Save schrieb:
>> Hi All,
>>
>> Can anyone help me out with the co
Hi,
select * from sqlite_master;
Martin
PS.: Please provide a subject which summarises your question.
Manasi Save schrieb:
> Hi All,
>
> Can anyone help me out with the command to see the SQLite table defination
> on command-line SQLite application.
>
Hi All,
Can anyone help me out with the command to see the SQLite table defination
on command-line SQLite application.
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
manasi.s...@artificialmachines.com
Ph:- 9833537392
___
sqlite-users
Hi All,
I have the select statement as below
sqlite> select remoteId, hostName , remoteWXType from remoteWXTable order by
hostName;
and the output is below:
1|HostName1-T432|2
2|HostName2-T421|2
3|HostName3-XP|2
4|HostName3-XP|2
But I would like the sql statement to return as below:
(HostName3
: Daniel Watrous
To: General Discussion of SQLite Database
Sent: Monday, February 2, 2009 11:55:52 AM
Subject: Re: [sqlite] (no subject)
Hey Boris,
It's a bit hard to follow what you've posted here, but I'm sure that's
because it came from a complicated script. Here are a f
r closed
> until the program ends. Again the same code is used for successful and
> failed results as outlined before.
>
> Thanks,
> Boris
>
>
>
>
>
>
>
> From: Daniel Watrous
> To: General Discussion of SQLite Database
>
_
From: Daniel Watrous
To: General Discussion of SQLite Database
Sent: Saturday, January 31, 2009 5:42:40 PM
Subject: Re: [sqlite] (no subject)
why don't you send us some code. It sounds like you might have an
issue managing your connections.
On Sat, Jan 31, 2009 at 3:09
why don't you send us some code. It sounds like you might have an
issue managing your connections.
On Sat, Jan 31, 2009 at 3:09 PM, Boris Arloff wrote:
> Hi,
>
> I am having a small problem with an sqlite3 v3.5.6 database being accessed
> from within python 2.5 (import sqlite3 as sqlite).
>
> T
Hi,
I am having a small problem with an sqlite3 v3.5.6 database being accessed from
within python 2.5 (import sqlite3 as sqlite).
The database has been working correctly with the exception of the following
issue:
There are 17 tables with the first table being a dataset index table with three
c
I have problem with executing this query in sqlite. to reconstruct problem
please follow the following steps.
1. create table awal1, akhir1 and hasil1 first.
CREATE TABLE awal1(Code char(5),Level varchar(8), Category varchar(50), Product
varchar(60), Location varchar(50), "Begin" datetime);
I
me.it was bit
> confusing when iam using sqlite command prompt
>
> Regards,
> Satish
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor
> Sent: Friday, November 14, 2008 11:35 AM
> To: General Discussion of SQLite
D] On Behalf Of P Kishor
Sent: Friday, November 14, 2008 11:35 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] (no subject)
On 11/13/08, Satish <[EMAIL PROTECTED]> wrote:
> Hi!
>
> Really I am Serious about this I am very new to database and I
want
> t
Satish wrote:
> Hi!
>
> Really I am Serious about this I am very new to database and I want
> to use sqllite.so I want to know.THE Reason why asked this question is I
> have seen a video of google tech bytes in that the presenter said that
> sqllite doesn't support foreign key and alter t
t;
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Cory Nelson
> Sent: Friday, November 14, 2008 11:22 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] (no subject)
>
> On Thu, Nov 13, 2008 at 9:31 PM, Sa
rue.i want to
know based on this I can proceed further.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Cory Nelson
Sent: Friday, November 14, 2008 11:22 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] (no subject)
On Thu, Nov 13, 20
On Thu, Nov 13, 2008 at 9:31 PM, Satish <[EMAIL PROTECTED]> wrote:
> Hi!
>
>Will sqllite support Foreign Key and ALTER Table Comands .I want to know
> is there any documentation that helps me to know what are the classes that I
> can use and program.I use vc++ to connect to database.tell me if
Hi!
Will sqllite support Foreign Key and ALTER Table Comands .I want to know
is there any documentation that helps me to know what are the classes that I
can use and program.I use vc++ to connect to database.tell me if there any
wrapper classes which I can use and also provide me documentation
I am resending my transactions based on the result code that is returned.
Should I put the time out command in my loops or once set does time out apply to
each transaction despite the resends? And does the timeout command apply only
to connecting to the data base or to each request?
_
I am resending my transactions based on the result code that is returned.
Should I put the time out command in my loops or once set does time out apply to
each transaction despite the resends?
___
sqlite-users mailing list
sqlite-users@sqlite.org
h
What is the proper syntax to set a variable to the error code using
errorcode method and TCL.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
What is the proper syntax to set a variable to the error code using
errorcode method and TCL.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
What is the proper syntax to set a variable to the error code using
errorcode method and TCL.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
What I would like to do is if the data base returns a busy or locked status is
to set up my proc to retry the write. Or can I take care of this easier by
setting a long timeout? And from what I read timeout basically keeps retrying
the write for a specified amount of time. Is this correct? Or
Hi All,
I have a question related toSQLite db handle(pDb in my codes).
I have the function below to open the database connection. I have to call
sqlite3_close(sqlite3 *)(sqlite3_close(pDb) in my case)
before open another database connection( by calling openDb) for releasing the
memory which is
what do I need to do to build sqlite?
see ya
sebey
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello, sqlite-users
i want to be the user member of sqlite.please let me in ,3x so mush!
dongsheng zhang, [EMAIL PROTECTED]
2008-03-17
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
101 - 146 of 146 matches
Mail list logo