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>