Thanks for your help, Setting the DB.Debug=True help me to figure it out. Turns that cQuery = " Insert into test.StatusCodes() values (19, '19')" does not save in the sentence in the bin-log
and db2.name="test" cQuery = " Insert into StatusCodes() values (19, '19')" saves in the sentence in the bin-log I beleive this is more related to mysql identifying the database to be logging. Thank you! Benoît Minisini wrote: > >> I need that the "insert" statement to be logged in the binary log. >> > > I have no idea why it is not logged. I didn't know there was a "mysql > binary > log", and I don't know how it works. > > Try to set 'DB.Debug = True' to see what SQL queries are sent to the SQL > client library. > > Regards, > > -- > Benoît Minisini > > ------------------------------------------------------------------------------ > Special Offer -- Download ArcSight Logger for FREE! > Finally, a world-class log management solution at an even better > price-free! And you'll get a free "Love Thy Logs" t-shirt when you > download Logger. Secure your free ArcSight Logger TODAY! > http://p.sf.net/sfu/arcsisghtdev2dev > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > > -- View this message in context: http://old.nabble.com/Gambas-2-and-mysql-bin-log-tp32334095p32367839.html Sent from the gambas-user mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Special Offer -- Download ArcSight Logger for FREE! Finally, a world-class log management solution at an even better price-free! And you'll get a free "Love Thy Logs" t-shirt when you download Logger. Secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsisghtdev2dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user