<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Enhanced sql_trail reporting]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=6384&amp;type=atom" />
	<updated>2016-07-29T07:44:53Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=6384</id>
		<entry>
			<title type="html"><![CDATA[Enhanced sql_trail reporting]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=25884#p25884" />
			<content type="html"><![CDATA[<p>The standard <em>sql_trail</em> reports the sql error message if any.</p><p>Using this commit in <a href="https://github.com/apmuthu/frontaccounting/commit/55b01a357df0a1749113d96da6cb93a6139a0ef9">my GtHub repo</a>, the following will appear prefixed to the message in the <em>msg</em> field. <br /></p><ul><li><p>For <strong>INSERT</strong> statements, the <strong>AUTO_INCREMENT</strong> field&#039;s <strong>last inserted id</strong> value prefixed with an <strong>I</strong></p></li><li><p>For <strong>UPDATE / REPLACE</strong> statements, the number of <strong>affected rows</strong> prefixed with <strong>M</strong></p></li></ul><p><a href="https://frontaccounting.com/fawiki/index.php?n=Devel.TrobleshootingFrontAccounting">Wiki</a>-ed.</p><p>@joe: want to include in the core or extend the table with another field for it in FA 2.4?</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2016-07-29T07:44:53Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=25884#p25884</id>
		</entry>
</feed>
