Re: [sqlite] (no subject)

Hi! Can I get some samples to work on sqlite that is how to create a database and inserting ... don' t think again I am joking plz help me.it was bit confusing when iam using sqlite command prompt Regards, Satish -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

Re: [sqlite] (no subject)

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)

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 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

Re: [sqlite] (no subject)

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 table.is this True.i

Re: [sqlite] (no subject)

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)

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

Re: [sqlite] process blocks on sqlite3_close?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 RanRan wrote: > In the child process, I closed the database and opened a new one for the > child process to use. Won't it fix the problem? Thank you so much again. No, because after the fork both the parent and the child have the database open.

Re: [sqlite] How to run the test cases (Roger Binns)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Avinash Mittal wrote: > I think compiler is not getting tcl.h file > > Now what should be done to debug these errors Make sure the TCL development files (headers and libraries) are available. If you don't know how to do that then you need to

Re: [sqlite] How to run the test cases (Roger Binns)

Hi , As suggested i did make test but it is showing errors like: test1.c:(.text+0x390): undefined reference to `Tcl_CreateCommand' test1.c:(.text+0x3b8): undefined reference to `Tcl_CreateObjCommand' test1.c:(.text+0x3d4): undefined reference to `Tcl_LinkVar' test1.c:(.text+0x3e8): undefined

Re: [sqlite] process blocks on sqlite3_close?

Roger Binns wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > RanRan wrote: >> I have a program that would create a child process. > > http://www.sqlite.org/faq.html > > Question 6, last paragraph. > > Roger > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.9 (GNU/Linux)

[sqlite] Mailing Request

[EMAIL PROTECTED] Regards, G.Satish ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] process blocks on sqlite3_close?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 RanRan wrote: > I have a program that would create a child process. http://www.sqlite.org/faq.html Question 6, last paragraph. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux)

[sqlite] Unicode Character

Hi All, We have a field of datatype nvarchar in SQL Server 2005, which stores the data in unicode. When I export the data into SQLite, it is storing as ascii, even if I change the datatype as nvarchar when the table is created. I am using SQL Maestro tool to export the data from SQL

Re: [sqlite] How to Modify Table

Slater, Chad wrote: > > Sqlite does not support modifying the unique constraints on a table: > > http://www.sqlite.org/lang_altertable.html > > So you probably need to do it the 'ol fashioned way: > Perfect--Just what I figured I'd need to do! Thanks! -- View this message in context:

Re: [sqlite] How to Modify Table

Sqlite does not support modifying the unique constraints on a table: http://www.sqlite.org/lang_altertable.html So you probably need to do it the 'ol fashioned way: BEGIN; CREATE TABLE Vehicles_new ( VehicleID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, FK_CustomerID INTEGER NOT NULL,

Re: [sqlite] SQLite Import Tool

Thanks you all for your support. Finally, I was able to make SQLMaestro work. Thanks once again Baskaran> Date: Thu, 13 Nov 2008 10:14:14 -0500> From: [EMAIL PROTECTED]> To: sqlite-users@sqlite.org> Subject: Re: [sqlite] SQLite Import Tool> > Here is a link to the application and source:>

[sqlite] UPDATE - to simplify the code...

Hello , Is it possible to simplify the code? I have ten fields to UPDATE. (STATUS, Responsavel, Country,..) Thanks, Ernany ** UPDATE Bens SET *STATUS *= CASE (SELECT

Re: [sqlite] sqlite insert and delete statements not succeed

hi, Doug, Thanks for your reply, I have just fixed that bug, the issue caused by not closing database correctly, so next time I opened the database, all things rolling back. Thanks for your patience and passion. best regards On Thu, 2008-11-13 at 09:48 -0500, Doug Currie wrote: > On Nov

[sqlite] ANN: SQLite Maestro 8.11 released (database encryption support and other features)

Hi! SQL Maestro Group announces the release of SQLite Maestro 8.11, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ What's new in this version === 1. Support

Re: [sqlite] FTS 3 Crash in 3.6.5

Shawn Wilsher wrote: >I seem to have found a crash that is 100% reproducible in SQLite 3.6.5. I'm >managed to make a reduced test case in a C file that can be found here: >http://files.shawnwilsher.com/2008/11/12/test.c I could reproduce the problem and opened this ticket to make sure it does

Re: [sqlite] SQLite Import Tool

Here is a link to the application and source: http://www.proghack.net/?p=40 On Wed, Nov 12, 2008 at 3:20 PM, Baskaran Selvaraj < [EMAIL PROTECTED]> wrote: > > Thanks roosevelt. I will try to use the c# command. > > > Date: Wed, 12 Nov 2008 15:03:41 -0500> From: > [EMAIL PROTECTED]> To:

[sqlite] Problems using AUTOINCREMENT row IDs in indexes

I'm having problems getting good index choice in SQLite 3.6.4 for a field which is INTEGER PRIMARY KEY AUTOINCREMENT. I've got the following table: CREATE TABLE Signals (sSignalID Text DEFAULT '',sText Text DEFAULT '',sTime Text DEFAULT '',sUserID Text DEFAULT '',nRowID INTEGER PRIMARY KEY

[sqlite] (no subject)

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?

Re: [sqlite] sqlite insert and delete statements not succeed

On Nov 12, 2008, at 10:31 PM, henry wrote: > my app, I opened a database handler, insert some records, delete some > records, then closed the database handler. The problem is the next > time > when I connect the Sqlite, the actions I did last time has all gone > away, it did not take any

Re: [sqlite] Program crashes when delete a row in SQLite db table

Hello Nithin, Thursday, November 13, 2008, 12:15:57 AM, you wrote: NJ> Hi, NJ> The problem is that the process is crashing without giving me a NJ> chance to detect the error and recover from the situation. How can I NJ> prevent that? NJ> How can I programatically find out the the corrupted

Re: [sqlite] Query Sqlite lock state

Igor Tandetnik wrote: > "Marcus Grimm" <[EMAIL PROTECTED]> wrote > in message news:[EMAIL PROTECTED] >> is there a way to query if the database file is currently locked ? > > How would it help? Between the time you would obtain this information, > and the time you could act on it, the answer

Re: [sqlite] Query Sqlite lock state

John Stanton wrote: > How about performing your backup inside an exlclusive transaction? hm, good idea! ;) Probably that will lock the file (i.e. the database) and protect from a FileCopy, anyway: I'll try that. Thanks for the reply Marcus > > Marcus Grimm wrote: >> Hello all, >> >> is

Re: [sqlite] Query Sqlite lock state

"Marcus Grimm" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > is there a way to query if the database file is currently locked ? How would it help? Between the time you would obtain this information, and the time you could act on it, the answer may very well change. Just try

Re: [sqlite] Query Sqlite lock state

How about performing your backup inside an exlclusive transaction? Marcus Grimm wrote: > Hello all, > > is there a way to query if the database file is currently locked ? > > Background: > My application may run for weeks (hopefully) and uses EXCLUSIVE > transactions in some threads. On a daily

Re: [sqlite] SQLite Import Tool

has any one expressed an interest to help out? it does not seem to be all that difficult, notwithstanding your mention of time-out issues. please let me know a bit ore detail about the db you are exporting, and we can see if it is a project we can do quickly for you. thanks- Keith T the SLK

[sqlite] Query Sqlite lock state

Hello all, is there a way to query if the database file is currently locked ? Background: My application may run for weeks (hopefully) and uses EXCLUSIVE transactions in some threads. On a daily basis I would like to copy the database file for backup purpose. I assume that this will fail when