В последната версия при опит за зареждане на продуктите излиза грешка. С версия 1.2.1645.1955 нямаше проблем
Product: AtonS3
Version: 1.2.1648.1958
GDS32: WI-V2.5.1.26351
----------------------------------------
DateTime: 2014-02-05 16:47:57.414
Error: Системна грешка IBErrorCode: 335544569
Dynamic SQL Error
Control: OprDostZForm.Panel1.dblcomboDostavchici
Class: EIBInterBaseError
Details: Dynamic SQL Error
SQL error code = -206
Column unknown
GET_LAST_DOSTKLI.R_KOL_RZV
At line 20, column 18
------------- SQL text -------------
SELECT get_last_dostkli.r_simpleid AS ID,
GET_LAST_DOSTKLI.r_simplename AS NAME,
GET_LAST_DOSTKLI.r_code AS CODE,
GET_LAST_DOSTKLI.r_kolkrimin AS KOL_KRI_MIN,
GET_LAST_DOSTKLI.r_kolkrimax AS KOL_KRI_MAX,
GET_LAST_DOSTKLI.r_me AS ME,
GET_LAST_DOSTKLI.r_meid AS ME_ID,
GET_LAST_DOSTKLI.r_cena_cl AS cena_cl,
GET_LAST_DOSTKLI.r_dds AS D_D_S,
GET_LAST_DOSTKLI.r_last_cena cena_last,
GET_LAST_DOSTKLI.r_kolnal AS KOL_NAL,
GET_LAST_DOSTKLI.r_grname AS GR_NAME,
GET_LAST_DOSTKLI.r_mekoef AS ME_KOEF,
GET_LAST_DOSTKLI.r_bar_code AS BAR_CODE,
get_last_dostkli.r_kliname AS KLI_NAME,
get_last_dostkli.r_skladid as sklad_id,
get_last_dostkli.r_sklad_name AS SKLAD_NAME,
get_last_dostkli.r_kli_id AS kli_id,
GET_LAST_DOSTKLI.R_CODE2 AS CODE_2,
GET_LAST_DOSTKLI.R_KOL_RZV AS KOL_RZV,
RAZ_ELEMENT.NAME AS RAZ_NAME,
CASE WHEN COALESCE(RAZFASOVKA.KOL,0) <> 0 THEN (GET_LAST_DOSTKLI.r_kolnal / RAZFASOVKA.KOL) ELSE NULL END AS RAZ_KOL,
COALESCE(RAZFASOVKA.KOL, 0) AS KOL_V_RAZ,
COALESCE(DEF_RAZ_SIMPLE.RAZFASOVKA_ID, 0) AS DEF_RAZ_EL
FROM GET_LAST_DOSTKLI(:KLI,:Opr_id, :SHOW_IZL)
LEFT JOIN DEF_RAZ_SIMPLE ON DEF_RAZ_SIMPLE.SIMPLE_ID = get_last_dostkli.r_simpleid
LEFT JOIN RAZFASOVKA ON RAZFASOVKA.ID = DEF_RAZ_SIMPLE.RAZFASOVKA_ID
LEFT JOIN RAZ_ELEMENT ON RAZ_ELEMENT.ID = RAZFASOVKA.RAZ_ELEMENT_ID
WHERE
/*FILTER*/ (1=1)
/*AND_MY_FILTER*/ and ((R_SKLADID IS NULL OR R_SKLADID in (4,1)))
ORDER BY 2
