close it. that is for my reason. the relloc memory error!
"Mohd Radzi Ibrahim" <[EMAIL PROTECTED]> 2007-05-10 16:44 Please respond to [email protected] To <[email protected]> cc Subject Re: [sqlite] create table error Could it be that the data where *sql is pointing to is being re-used somewhere? --radzi. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, May 10, 2007 3:54 PM Subject: [sqlite] create table error > 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 > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------

