[sqlite] create table error

[allen . zhang]

the following is my test code. just create table.


 rc = sqlite3_open("zieckey.db", &db); 
 char *sql = " CREATE TABLE SensorData(ID INTEGER PRIMARY KEY,SensorID 
INTEGER,SiteNum INTEGER,Time VARCHAR(12),SensorParameter REAL);" ;
 sqlite3_exec( db , sql , 0 , 0 , &zErrMsg );
 sqlite3_close(db); 



when execute the sqlite3_exec function,

it corrupt at line 189, sqlite3StrICmp(pTab->aCol[j].zName, 
pChanges->a[i].zName)==0 )

pChanges->a[i].zName is NULL;

anybody know the reason ?


how to trace the error? there is no clue for me to analyze the error.

thanks a lot

allen.zhang