On 30-8-2011 21:18, 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
set the logging level in the configuration file higher than zero
-- Original Message ---
From: fvegaf
To: gambas-user@lists.sourceforge.net
Sent: Tue, 30 Aug 2011 11:12:18 -0700 (PDT)
Subject: [Gambas-user] Gambas 2 and mysql bin-log
> I turned on the mysql binary log, but
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
> 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î
I need that the "insert" statement to be logged in the binary log.
fvegaf wrote:
>
> I turned on the mysql binary log, but my gambas inserts, updates and
> deletes are not showing in the binary log (MySQL)
>
> Example:
>
> strQ = "Insert into tabletest(field1) values('test')"
> rs = db.Exec
> I turned on the mysql binary log, but my gambas inserts, updates and
> deletes are not showing in the binary log (MySQL)
>
> Example:
>
> strQ = "Insert into tabletest(field1) values('test')"
> rs = db.Exec(strQ)
>
>
> I tried the following, and works, but it implies that I will need to
> rew
I turned on the mysql binary log, but my gambas inserts, updates and deletes
are not showing in the binary log (MySQL)
Example:
strQ = "Insert into tabletest(field1) values('test')"
rs = db.Exec(strQ)
I tried the following, and works, but it implies that I will need to rewrite
my entire applic