RE: [sqlite] Is this SQL command supported?

2007-07-24 Thread Ahmed Sulaiman
That's a real pumper. How do you alter constraints on existing tables ??! -Original Message- From: Trevor Talbot [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 24, 2007 4:39 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is this SQL command supported? On 7/24/07, Ahmed Sulaiman

RE: [sqlite] Re: Is this SQL command supported?

2007-07-24 Thread Ahmed Sulaiman
:[EMAIL PROTECTED] Sent: Tuesday, July 24, 2007 4:29 PM To: SQLite Subject: [sqlite] Re: Is this SQL command supported? Ahmed Sulaiman <[EMAIL PROTECTED]> wrote: > I wonder if there any SQL commands that are not supported by SQLite. Yes. See http://sqlite.org/lang.html for a complete docu

[sqlite] Is this SQL command supported?

2007-07-24 Thread Ahmed Sulaiman
I wonder if there any SQL commands that are not supported by SQLite. I am trying to read an entire DDL script file as a string and pass it as one SQL command to SQLite. The same script worked fine in Firebird batch execution. But with SQLite I get an SQLite exception: {"SQLite error\r\nnear

RE: [sqlite] SQLite on Mac

2007-07-20 Thread Ahmed Sulaiman
"Ahmed Sulaiman" <[EMAIL PROTECTED]> wrote: > > We are now just making strategic decision as of which database engine to > choose that would give us better cross platform support. > Be sure to visit http://www.sqlite.org/whentouse.html to make sure the SQLite is s

RE: [sqlite] SQLite on Mac

2007-07-20 Thread Ahmed Sulaiman
Thanks guys for the informative replies :) We are now just making strategic decision as of which database engine to choose that would give us better cross platform support. And with such a wonderful tech/community support, I believe SQLite is the right answer :) Cheers -Original

[sqlite] SQLite on Mac

2007-07-19 Thread Ahmed Sulaiman
Hi all, Does SQLite work on Mac, and if yes, is there any Mac enabled version that I could download? Cheers - To unsubscribe, send email to [EMAIL PROTECTED]

RE: [sqlite] Does Transaction object roll back automatically on exceptions?

2007-07-16 Thread Ahmed Sulaiman
Hi all, Is it necessary to run a "SELECT" command in between a transaction? I have few places in my code where I have a command that reads some data from a table, and I wonder if I should begin/commit a transaction? Is there any performance issues if I did or didn't do that? Regards

RE: [sqlite] Does Transaction object roll back automatically on exceptions?

2007-07-16 Thread Ahmed Sulaiman
: [sqlite] Does Transaction object roll back automatically on exceptions? "Ahmed Sulaiman" <[EMAIL PROTECTED]> wrote: > Hi all, > > I have tried this question in the forum with no answer, so I decide to > give it a try here :) > > I am using the "Using" stat

[sqlite] Does Transaction object roll back automatically on exceptions?

2007-07-16 Thread Ahmed Sulaiman
Hi all, I have tried this question in the forum with no answer, so I decide to give it a try here :) I am using the "Using" statements in C# to handle the closing of SQLite connection, transaction and command objects. I have this setup in different places in my code (Generic methods returning

RE: [sqlite] Using SQlite with .NET

2007-07-09 Thread Ahmed Sulaiman
contact [EMAIL PROTECTED] -Original Message- From: Ahmed Sulaiman [mailto:[EMAIL PROTECTED] Sent: Friday, July 06, 2007 2:02 PM To: sqlite-users@sqlite.org Subject: [sqlite] Using SQlite with .NET Hi, I am trying to evaluate the use of SQLite with .NET in out project. I have downloaded

[sqlite] Using SQlite with .NET

2007-07-06 Thread Ahmed Sulaiman
Hi, I am trying to evaluate the use of SQLite with .NET in out project. I have downloaded the ADO.NET 2 adaptor for SQLite from source forge. But I was not sure which version do I need to download (if any) from the download page to get myself started. Could you please give me some direction,

RE: [sqlite] SQLite 64-Bit

2007-07-04 Thread Ahmed Sulaiman
/07, Ahmed Sulaiman <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > We are interested in using the SQLite in our project. I wonder if there > a version that works in 64-Bit machine? I have looked in the download > page and noticed that only Win32 (x86) builds

[sqlite] SQLite 64-Bit

2007-07-04 Thread Ahmed Sulaiman
Hi all, We are interested in using the SQLite in our project. I wonder if there a version that works in 64-Bit machine? I have looked in the download page and noticed that only Win32 (x86) builds are available. Regards Ahmed