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

2007-12-12 Thread T
Hi Joanne, 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

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

2007-12-12 Thread Joanne Pham
Hi All, 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 varchar(20)