´¯¯¯
>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
u 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-
>>> From: sqlite-use
> 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
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
nvert 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: Thursday,
te.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 document archiving
> pro
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,
--
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
> 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
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 <rl...@cadence.com>
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 hav
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
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.
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
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
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
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
___
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:
: Daniel Watrous <dwmaill...@gmail.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
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
program ends. Again the same code is used for successful and
> failed results as outlined before.
>
> Thanks,
> Boris
>
>
>
>
>
>
>
> From: Daniel Watrous <dwmaill...@gmail.com>
> To: General Discussion of SQLite Database <sql
iel Watrous <dwmaill...@gmail.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
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.
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
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
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);
t 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 Datab
] 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
> to use
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; -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, Satish
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, 2008
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
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
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
Dne sobota 24 únor 2007 18:33 Jakub Ladman napsal(a):
> Hi Friends
> Please help me
> I need crosscompile sqlite for my sh4 cpu based linux system, but configure
> script (any version of sqlite i have tryed, even the actual one from sqlite
> homepage) fails if crosscompilation is selected.
>
101 - 144 of 144 matches
Mail list logo