Devart Forums

Hello all,
I tried to use the RefreshOption roBeforeEdit due to the problem like "Update failed found 0 record". If I refresh before I will not get the error. So I tried the RefreshOption.

The statement is this
SELECT vnr.*, IF(d_fertig IS NULL, 0, 1) AS n_fertig
FROM t_verpackung_nr_list vnr, v_verpackung_no_ref va
WHERE vnr.n_verp_id = va.verp_id
AND vnr.n_verptyp_id = va.verp_typ
AND va.verp_kunde_id = :kundeId
ORDER BY n_verp_id, n_verptyp_id, CAST(vnr.c_nr AS SIGNED) ASC

I tried to edit the record and the following statement is generated with the error "column n_fertig not found". This is true! This column is not existing.

SELECT vnr.n_verptyp_id AS _0, vnr.n_verp_id AS _1,
vnr.n_verp_sub_id AS _2, vnr.c_nr AS _3, vnr.n_geliefert AS _4,
vnr.n_verrechnet AS _5, vnr.n_auftragbestaet AS _6, vnr.n_angeboten AS _7,
vnr.n_gestaut AS _8, vnr.n_bruttogewicht AS _9, vnr.c_kunden_verp_nr AS _10,
vnr.c_warenabhol_termin AS _11, vnr.c_montage_termin AS _12, vnr.c_verpack_termin AS _13,
vnr.c_abhollief_termin AS _14, vnr.c_abnahme_termin AS _15, vnr.m_warenabhol_termin_bem AS _16,
vnr.m_montage_termin_bem AS _17, vnr.m_verpack_termin_bem AS _18, vnr.m_abhollief_termin_bem AS _19,
vnr.m_abnahme_termin_bem AS _20, vnr.d_warenabhol_termin AS _21, vnr.d_montage_termin AS _22,
vnr.d_verpack_termin AS _23, vnr.d_abhollief_termin AS _24, vnr.n_wir_liefern AS _25,
vnr.d_abnahme_termin AS _26, vnr.n_status AS _27, vnr.n_bewertung AS _28, vnr.m_bewertung AS _29,
vnr.n_einzelpreis AS _30, vnr.d_fertig AS _31, n_fertig AS _32
FROM t_verpackung_nr_list vnr
WHERE
vnr.n_verptyp_id = :n_verptyp_id AND vnr.n_verp_id = :n_verp_id AND
vnr.n_verp_sub_id = :n_verp_sub_id AND vnr.c_nr = :c_nr AND
vnr.n_geliefert = :n_geliefert AND vnr.n_verrechnet = :n_verrechnet AND
vnr.n_auftragbestaet = :n_auftragbestaet AND vnr.n_angeboten = :n_angeboten AND
vnr.n_gestaut = :n_gestaut AND vnr.n_bruttogewicht = :n_bruttogewicht AND
vnr.c_kunden_verp_nr IS NULL AND vnr.c_warenabhol_termin IS NULL AND
vnr.c_montage_termin IS NULL AND vnr.c_verpack_termin IS NULL AND
vnr.c_abhollief_termin IS NULL AND vnr.c_abnahme_termin IS NULL AND
vnr.d_warenabhol_termin IS NULL AND vnr.d_montage_termin IS NULL AND
vnr.d_verpack_termin IS NULL AND vnr.d_abhollief_termin IS NULL AND
vnr.n_wir_liefern = :n_wir_liefern AND vnr.d_abnahme_termin IS NULL AND
vnr.n_status = :n_status AND vnr.n_bewertung IS NULL AND
vnr.n_einzelpreis IS NULL AND vnr.d_fertig IS NULL


So I tried to use the SQLRefresh

SELECT vnr.*, IF(d_fertig IS NULL, 0, 1) AS n_fetig
FROM t_verpackung_nr_list vnr, v_verpackung_no_ref va
WHERE vnr.n_verp_id = va.verp_id
AND vnr.n_verptyp_id = va.verp_typ
AND vnr.n_verptyp_id = :n_verptyp_id
AND vnr.n_verp_id = :n_verp_id
AND vnr.n_verp_sub_id = :n_verp_sub_id
AND vnr.c_nr = :c_nr

But this was also not working. Error "Cannot convert type". After this the app chrashed with cannot free blob .... in file my....pas
So I removed the AS n_fetig and it worked. But the column in my grid which corresponds to n_fertig was not refresh.

What can I do?

New build of MyDAC version 5.20.1.14 has been released. This build must solve the problem.