On Tue, 2005-06-07 at 16:53 -0700, Kiel W. wrote: > size = sprintf( buf, "CREATE TABLE People( fname varchar(25), fname > varchar(25) );" ); > rc = sqlite3_prepare( database, buf, -1, &statement, 0 ); >
sqlite3_prepare only processes the first statement in your list of SQL statements. It then returns a pointer to the beginning of the second statement so that you can process them all in a loop. But your code appears to omit this loop and thus is processing only the first one. It never reaches the SELECT. -- D. Richard Hipp <[EMAIL PROTECTED]>
