Page 1 of 1

DML REFRESH Problem

Posted: Sat 26 Mar 2016 18:44
by 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>

Re: DML REFRESH Problem

Posted: Tue 29 Mar 2016 10:24
by 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.