On Tue, Jul 20, 2010 at 10:41:04PM +0100, Simon Slavin scratched on the wall:
> 
> On 20 Jul 2010, at 7:42pm, dmsmsm wrote:

> > if (sqlite3_exec(db, [rowcount UTF8String], NULL, NULL, &err) != SQLITE_OK)

> Second, I see no reason why your code wouldn't work.  Did you try it ? 
> What happened ?  Below I'm just suggesting some changes.

  The lack of a callback to actually extract the results might have
  something to do with it.  I'm sure the code is running just fine, but
  since the callback is NULL (3rd param), the results are being discarded.
  
  Where exactly were you expecting the result to show up?

> It should be faster to name a specific column rather than use '*':

  Definitely not, for many reasons.  It may not even provide the
  same answer.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to