Skip to main content

Posts

Showing posts with the label show

Debug queries and show sql

Sometimes you want to see the query with has been executed to the database. Solution: Try to find the query in the code, and add info(query.dataSourceNo(1).toString()); The word query has to be replaced with the object name of the query at that time. This will result in this kind of message in the info log: SELECT * FROM LedgerTrans ORDER BY LedgerTrans.TransDate ASC, LedgerTrans.Voucher ASC WHERE ((AccountNum = 21240 OR AccountNum = 21240 OR AccountNum = 21230 OR AccountNum = 21230 OR AccountNum = 21205 OR AccountNum = 21205)) AND ((TransDate>=12/01/2002 AND TransDate<=12/31/2002)) AND ((PeriodCode = Normal))