History for InsertCommittedVersionAsNew
??changed:
-
These should be insert selects.
<pre>
SELECT z_oid, %s, z_serial, 'c', 0, '', '',
z_dataserial
FROM %s
WHERE z_version = %s
AND z_status = 'c'
AND z_dataserial != '' """ % (_sql_quote(s_serial),
tables!['data'],
_sql_quote(version))
</pre>
<br>
for each record there:
<pre>
INSERT INTO %(data)s
(z_oid, z_serial, z_pre, z_status, z_datalen, z_version, z_nv,
z_dataserial) values (?, ?, ?, ?, ?, ?, ?, ?)
</pre>
<br>
then (interbase has no if)
<pre>
SELECT z_oid, %s, z_serial, 'c', 0, '', '',
z_serial
FROM %s
WHERE z_version = %s
AND z_status = 'c'
AND z_data IS NOT NULL
AND z_dataserial = '' """ % (_sql_quote(s_serial),
tables!['data'],
_sql_quote(version))
</pre>
<br>
for each record returned:
<br>
<pre>
INSERT INTO %(data)s
(z_oid, z_serial, z_pre, z_status, z_datalen, z_version, z_nv,
z_dataserial) values (?, ?, ?, ?, ?, ?, ?, ?)
</pre>