Re: [sqlite] Re: How to check if the table has some specific values

2007-12-13 Thread Trevor Talbot
I think Joanne's example may be simplified, and the question was really more general... On 12/12/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > Basiclly there is no SQL logic in SQLite. Right, there's nothing like T-SQL. Even in other databases, most procedural logic along IF..THEN lines is done

Re: [sqlite] Re: How to check if the table has some specific values

2007-12-13 Thread Kees Nuyt
Hi Joanne, On Wed, 12 Dec 2007 16:20:17 -0800 (PST), Joanne Pham <[EMAIL PROTECTED]> wrote: >Hi Igor, >Thanks for the response. >Basiclly there is no SQL logic in SQLite. I'm not sure what you mean here. >I would like to check if the database version is xyz >then I will have different action

Re: [sqlite] Re: How to check if the table has some specific values

2007-12-12 Thread Joanne Pham
- Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To: SQLite <sqlite-users@sqlite.org> Sent: Wednesday, December 12, 2007 4:14:08 PM Subject: [sqlite] Re: How to check if the table has some specific values Joanne Pham wrote: > I have been working on MSSQL server and SQLite

[sqlite] Re: How to check if the table has some specific values

2007-12-12 Thread Igor Tandetnik
Joanne Pham wrote: I have been working on MSSQL server and SQLite is new to me. I usually did the following in MSQL server to check of the specific row is existed in the table and have different action depending on the result of the check. For example: Create table versionTable (dbVersion