DML REFRESH Problem

[auditplus]

Hi Devart Team
I use IDBAC 5.6.19. With IBCQuery when DMLRefresh is true there is a problem with strings inserted to database (FB.2.5.1) It looks like encoding problem: (���x#)
When the DMLRefresh option is off, everything works OK.

Code: Select all

IBCQuery settings:
  object QueryRejestr: TIBCQuery
    UpdatingTable = 'REJESTR'
    KeyFields = 'ID'
    KeyGenerator = 'GEN_REJESTR_ID'
    GeneratorMode = gmInsert
    DMLRefresh = True
    SQLInsert.Strings = (...)
    Connection = IBFirma
    Transaction = IBTransFirma
    UpdateTransaction = IBTransUpdateFirma
    SQL.Strings = (...)
    FetchAll = True
    CachedUpdates = True
    LockMode = lmLockImmediate
    Options.ComplexArrayFields = False
    AutoCalcFields = False
    Filtered = True
    FilterOptions = [foCaseInsensitive]
    Left = 56
    Top = 392
    ParamData = <
      item
        DataType = ftInteger
        Name = 'ID'
        Value = nil
      end>

[ViktorV]

Unfortunately, we can't reproduce the problem. Please check whether the problem is reproduced on the latest IBDAC version (5.6.21). If the error still occurs on the latest IBDAC version, please send to viktorv*devart*com a small sample demonstrating the issue, including scripts for creating database objects.