The course of action I thought you implied was to change it from "hexion" to "Hexion", and so I hoped that would return the results, but it still doesn't.
"Still" meaning, just like the small 'h', 'H' doesn't work either. Dan also mentioned the capital letter thing so it was a reply to him as well. > You get the number of columns with sqlite3_column_count. The only way to > get the number of rows is to retrieve all of them (e.g. by calling > sqlite3_step in a loop). Thanks. I'm guessing the inability to obtain the number of rows is an SQL design compromise rather than a fault with sqlite or SQL in general. Dan On Sat, 14 Jun 2008 14:34:12 +0100, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > "Daniel White" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> Funny you should mention the capital at the start >> to make "Hexion". I thought of that just after I >> posted. But it doesn't solve the problem unfortunately. >> Zero results are still returned. > > What do you mean, "still" returned? I stated a fact, but didn't suggest > any action. What exactly did you do that you hoped would remedy the > situation, but failed to? > >> Oh one other quick question: Any way to get the number >> of rows/columns after preperation without using >> ssomething like sqlite3_get_table? > > You get the number of columns with sqlite3_column_count. The only way to > get the number of rows is to retrieve all of them (e.g. by calling > sqlite3_step in a loop). > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- www.skytopia.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users