Re: [sqlite] (no subject)

2009-08-21 Thread Jean-Christophe Deschamps
´¯¯¯ >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

Re: [sqlite] (no subject)

2009-08-21 Thread erik
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

Re: [sqlite] (no subject)

2009-08-21 Thread Pavel Ivanov
> 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

Re: [sqlite] (no subject)

2009-08-21 Thread Jean-Christophe Deschamps
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

Re: [sqlite] (no subject)

2009-08-21 Thread Pavel Ivanov
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,

Re: [sqlite] (no subject)

2009-08-21 Thread Doug
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

[sqlite] (no subject)

2009-08-20 Thread erik
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,

[sqlite] (no subject)

2009-07-13 Thread Frank
-- 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

[sqlite] (no subject)

2009-07-13 Thread Frank
-- 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

[sqlite] (no subject)

2009-06-28 Thread ArbolOne
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

Re: [sqlite] (no subject)

2009-06-26 Thread Miroslav Zagorac
> 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

[sqlite] (no subject)

2009-06-26 Thread Rick Ratchford
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, " & _

[sqlite] (no subject)

2009-06-19 Thread Robert Lehr
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

Re: [sqlite] (no subject)

2009-06-01 Thread Kees Nuyt
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

[sqlite] (no subject)

2009-06-01 Thread Manasi Save
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.

Re: [sqlite] (no subject)

2009-05-26 Thread Samuel Baldwin
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

Re: [sqlite] (no subject)

2009-05-26 Thread John Machin
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

Re: [sqlite] (no subject)

2009-05-26 Thread Samuel Baldwin
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

Re: [sqlite] (no subject)

2009-05-26 Thread Martin.Engelschalk
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. >

[sqlite] (no subject)

2009-05-26 Thread Manasi Save
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] (no subject)

2009-02-17 Thread Joanne Pham
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:

Re: [sqlite] (no subject)

2009-02-02 Thread Boris Arloff
: 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

Re: [sqlite] (no subject)

2009-02-02 Thread Daniel Watrous
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

Re: [sqlite] (no subject)

2009-01-31 Thread Boris Arloff
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.

Re: [sqlite] (no subject)

2009-01-31 Thread Daniel Watrous
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

[sqlite] (no subject)

2009-01-31 Thread Boris Arloff
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

[sqlite] (no subject)

2008-12-19 Thread Rachmat Febfauza
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);

Re: [sqlite] (no subject)

2008-11-14 Thread John Stanton
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

Re: [sqlite] (no subject)

2008-11-13 Thread Satish
] 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

Re: [sqlite] (no subject)

2008-11-13 Thread Ian Walters
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

Re: [sqlite] (no subject)

2008-11-13 Thread P Kishor
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

Re: [sqlite] (no subject)

2008-11-13 Thread 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

Re: [sqlite] (no subject)

2008-11-13 Thread Cory Nelson
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

[sqlite] (no subject)

2008-11-13 Thread Satish
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

[sqlite] (no subject)

2008-11-13 Thread Rick Pritchett
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?

[sqlite] (no subject)

2008-11-12 Thread Rick Pritchett
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

[sqlite] (no subject)

2008-11-10 Thread Rick Pritchett
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

[sqlite] (no subject)

2008-11-10 Thread Rick Pritchett
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

[sqlite] (no subject)

2008-11-10 Thread Rick Pritchett
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

[sqlite] (no subject)

2008-11-07 Thread Rick Pritchett
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

[sqlite] (no subject)

2008-08-21 Thread Joanne Pham
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

[sqlite] (no subject)

2008-05-08 Thread sebastian stephenson
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

[sqlite] (no subject)

2008-03-17 Thread dongsheng zhang
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

[sqlite] Problem with crosscompiler and sqlite - was subject mismatch Re: [sqlite] sqlite ebuild - my problem, i have half year ago, is still here.

2007-02-24 Thread Jakub Ladman
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. >

<    1   2