Hello,

can any body tell me how to know the SQL statement that is being executed by the DB driver when we execute a query in Baan 4GL?

I mean..we write one SQL query and the drivers will convert our SQL statements to Database specific SQL statement and then execute them. So I would like to know that converted SQL statement. I hope there would be a log file which stores these things. ???

Please tell me if any body knows this.

Thank You, Babu.

Search the forum and the Baan help fro DBSLOG. Setting this variable you can get all the information you need and more.

Hi,

In DBSLOG file you will get SQL query compatible to baan. If you are looking compatible to database. Than you have to use sql tracer of any database. There you will easily get driver compatible SQL.

Regards,
Sanjay