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 and if then database >version is abc then I will have different action. >So SQLite doesn't allow this luxury. Sure it does, it even gives you a choice: - use the schema version SQLite automatically maintains. - set and use your own version number; The only thing you can't do is use the version directly in SQL, that is: SELECT * FROM test1 WHERE ID = (PRAGMA schema_version); is not a valid statement. Both techniques are demonstrated below. sqlite_version():3.5.3 CREATE TABLE test1 ( ID INTEGER PRIMARY KEY NOT NULL, t1_name text ); PRAGMA schema_version; : 1 PRAGMA user_version; : 0 PRAGMA user_version = 6001; CREATE INDEX idx_t1_name ON test1 (t1_name); PRAGMA schema_version; : 2 PRAGMA user_version; : 6001 CREATE TABLE test2 ( ID INTEGER PRIMARY KEY NOT NULL, t2_name text ); PRAGMA schema_version; : 3 PRAGMA user_version; : 6001 PRAGMA user_version = 6002; INSERT INTO test1 VALUES (1,'alpha'); INSERT INTO test2 VALUES (2,'beta'); PRAGMA schema_version; : 3 PRAGMA user_version; : 6002 >Thanks, >JP I hope this helps, -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------