Re: [sqlite] how can we solve IF EXIST in SQLite

Sorry, I don't see EXISTS in SQLite documentation. On 8/20/09, Asif Lodhi <asif.lo...@gmail.com> wrote: > Hi, > > Perhaps you can do this in TWO SQL STATEMENTS - see below. However, > this way you inefficiently check the existence twice: > > On 6/2/09, robinsmathew &

Re: [sqlite] how can we solve IF EXIST in SQLite

Hi, Perhaps you can do this in TWO SQL STATEMENTS - see below. However, this way you inefficiently check the existence twice: On 6/2/09, robinsmathew wrote: > IF EXISTS (SELECT prod_batch_code FROM stock_tab WHERE prod_batch_code=1000) > UPDATE stock_tab >

Re: [sqlite] What is a Group By, having clause?

Hi Christophe, On 12/9/08, Christophe Leske <[EMAIL PROTECTED]> wrote: > the difference between a normal "where"-clause and the "Group by", and > "having" I used www.sqlcourse.com and sqlcourse2.com probably in the year 2000. They had very good tutorials and also let your actually practice the

Re: [sqlite] strcpy and sqlite3_column_text

Hi All, On 10/10/08, Jay A. Kreibich <[EMAIL PROTECTED]> wrote: > On Fri, Oct 10, 2008 at 12:59:31PM -0400, Igor Tandetnik scratched on the > wall: >> Shaun R. <[EMAIL PROTECTED]> wrote: > It is true that on most systems "char" is signed, but it is worth > remembering that this is not

Re: [sqlite] System function with Sqlite

Hi Chris, On 8/15/08, Chris Brown <[EMAIL PROTECTED]> wrote: > > Can you offer any further help/suggestions? > AFAIK, how the system() passes the command-string to the command-processor is implementation defined. I would suggest that you also pass the shell (e.g. /bin/sh) to system() in addition

Re: [sqlite] What is quicker?

Hi Ken, On 6/6/08, Ken <[EMAIL PROTECTED]> wrote: > Some numbers can be represented exactly using the > floating point type. . Here is a reference from "The C++ Programming Language, 3rd Edition" by Bjarne Stroustrup, Page 835, section - C.6.2.6:

Re: [sqlite] What is quicker?

Hi Christophe, On 6/4/08, Christophe Leske <[EMAIL PROTECTED]> wrote: > .. > AND (latitude_DDS BETWEEN 44.261771 and 44.424779) You might want to check if you can somehow store this data *without* the decimal point (with the point implied - counting six digits from right to left)

Re: [sqlite] Resetting a Primary Key

Hi Vincent, On 11/21/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: > I have a primary key that auto increments and has apparently > overlapped back on to itself. > > INSERT into mytable(id,name) values(NULL,'test'); > > .. is giving me "primary key must be unique" errors. > > How can I reset

Re: [sqlite] BLOB data performance?

Hi, On 11/15/07, Andreas Volz <[EMAIL PROTECTED]> wrote: > Am Tue, 13 Nov 2007 12:46:11 -0800 (PST) schrieb Ken: > > > I think your blob file performance may greatly depend upon the file > > system that it used and the workload. > > > > I found this article: > > > >

Re: [sqlite] How many virtual table implemenations are there out there?

Hi Darren, On 11/3/07, Darren Duncan <[EMAIL PROTECTED]> wrote: > At 9:42 AM -0400 11/2/07, Samuel R. Neff wrote: > I think the real problem here is "virtual" is a broad enough term ... I immediately think about MySQL when you use terms like "federated" and "data engine". With the word

[sqlite] Unicode Capabilities in Simple Terms

Hi, I've been just glancing over the Unicode related posts. However, I would like to know how it's possible for me to insert text in different languages in an Sqlite database. Can you fixate the "type" of the language for any particular database? I would be thankful if any of you guys could

Re: [sqlite] sqlite db portability

Hi Shilpa, On 8/28/07, Shilpa Sheoran <[EMAIL PROTECTED]> wrote: > Eg. I create sqlite db file say "mysqlitedb.db" and now I have MySQL > installed. Can it access "mysqlitedb.db" IIRC, I did read about "Linked Servers" in MS-SQL-Server documentation where, if your SQL Server is being used in

Re: [sqlite] Replicating table data from sqlite to ms sql server

Hi maitong, On 7/16/07, maitong uy <[EMAIL PROTECTED]> wrote: The scenario would be the sqlite database is managed using CGI C, resides in Linux environment, and accessed through the web. Then the sql server would be replicating whatever changes would occur in the sqlite database (both sqlite

Re: [sqlite] Sharing an in-memory database between applications

Hi Rob, On 7/13/07, Rob Richardson <[EMAIL PROTECTED]> wrote: Greetings! But I'm wondering if I can use an in-memory database to improve this dramatically. The data is collected by a Windows service that collects data and adds it to the database once a minute. If the service would also

Re: [sqlite] Replicating table data from sqlite to ms sql server

Hi maitong, On 7/11/07, maitong uy <[EMAIL PROTECTED]> wrote: I see...any idea as to how exactly? I really am out of ideas regarding this... :( I think I did see some UnixODBC files on a Linux environment (Fedora Core 6, to be exact) and if you have the same kind of UnixODBC files on your

Re: [sqlite] Recommend server for Windows?

Hi Gilles, On 6/20/07, Gilles Ganault <[EMAIL PROTECTED]> wrote: At 16:49 19/06/2007 -0700, Medi Montaseri wrote: The context is that, until now, our apps were almost used on stand-alone hosts with only a few customers hosting the (small) SQLite database file on a shared drive on the LAN, so

Re: [sqlite] Recovery After Crash

Hi Kees, Thanks for replying. On 6/17/07, Kees Nuyt <[EMAIL PROTECTED]> wrote: >... thankful if you experts would give me an "accurate" and fair >picture of the crash-recovery aspects of SQLite - without any hype. I'm not sure if you would qualify this as hype, but sqlite is used in many

[sqlite] Recovery After Crash

Hi Everybody, I have just joined this mailing list as Sqlite looks like a good software solution to my needs. What I need right now is RE-assurance of "crash-recovery" that is mentioned on your front page. So, I would be thankful if you experts would give me an "accurate" and fair picture of the