[sqlite] Segmentation Fault With Trigger

[techi eth]

Hi,

I am getting segmentation fault while executing query in sqlite3. [Linux
OS].

Find below sequence.

// Getting SQLiteHandler

OpenConnection ();

//Creating user defined function “Test”

sqlite3_create_function(SQLiteHandler, "Test",1, SQLITE_UTF8, NULL, &Test,
NULL, NULL)

//Creating table,Below is DDL

CREATE TABLE dbTestTbl (

    RowID           INTEGER PRIMARY KEY AUTOINCREMENT,

    ParamaterID     INTEGER,

    ParamaterValue  TEXT

);

//Createatd Trigger,Below is DDL

CREATE TRIGGER TestTrigger

       AFTER INSERT ON dbTestTbl

       FOR EACH ROW

BEGIN

    SELECT Test( RowID )

      FROM dbTestTbl;

END;

// INSERT INTO dbTestTbl

Please suggest what is wrong defined here.

Thanks
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users