Re: [sqlite] Re: sqlite3_exec causing locked table

2005-11-23 Thread Mark Anderson
Igor Tandetnik wrote: Mark Anderson wrote: The following code seems to cause the 'template' table to become locked. CString querystr; querystr.Format ("insert into templates values (NULL, '%s', '%s', '%s', '%s', '%s', 

[sqlite] sqlite3_exec causing locked table

2005-11-23 Thread Mark Anderson
ckType, UnitsPerPack, Length, Width, Height, WeightGross, WeightNet, UnitPrice, LabelsFlag, WarrantyFlag); i = querystr.GetLength(); querystr2 = (char *) malloc (i); querystr2 = querystr.GetBuffer (i); sqlite3_exec (db, querystr2, NULL, 0, NULL); The sqlite3_exec() call returns with a value of 5 (SQLITE_BUSY). Am I doing something wrong? I'd appreciate any light you guys/gals could shed on my problem. Best regards, Mark Anderson.

[sqlite] Compile Problem - 'sqlite_compile' : undeclared identifier

2005-10-13 Thread Mark Anderson
Hello All - I'm trying to incorporate sqlite3 into a Visual C++ project but am having some problems compiling the project. I'm made sure to include the sqlite3.h header and I created a .lib file which is being linked in, but the compiler still complains with the following: c:\data\work\3pl\d