Egbert Eissing a écrit : > I have done some additional research on > SELECT LAST_INSERT_ID(); > When I execute the select not from within Knoda, but from > a mysql command line prompt it returns 11000+ '0's, i.e. > a 0 for every record in the table. The problem is obviously with > the mysql background database, and not with Knoda. > > Thanks for your answer. > Egbert Well, I only see this behaviour on tables without an integer auto increment primary key. With MySQL, as well as with SQLite3, only tables with an integer auto increment primary key return a valid result. Wgen using PostgreSQL, only tables with a serial integer type or with a sequence attached can be queried to return equivalent results. (This is what makes datanase abstractor authors have some headaches) :)
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Hk-classes-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
