InsertCommittedVersionAsNew

These should be insert selects.

 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))

for each record there:

 INSERT INTO %(data)s
                 (z_oid, z_serial, z_pre, z_status, z_datalen, z_version, z_nv,
                 z_dataserial) values (?, ?, ?, ?, ?, ?, ?, ?)

then (interbase has no if)

 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))

for each record returned:

 INSERT INTO %(data)s
                 (z_oid, z_serial, z_pre, z_status, z_datalen, z_version, z_nv,
                 z_dataserial) values (?, ?, ?, ?, ?, ?, ?, ?)