Загрузка данных


UPDATE dev.model_file_to_verification
SET fbytes = convert_to(
    replace(
        convert_from(fbytes, 'UTF8'),
        'НомерЗапр="' || (
            SELECT "number"::text
            FROM report.smev_register 
            WHERE id = :smevRegisterId
        ) || '"',
        'НомерЗапр="' || :new_number || '"'
    ),
    'UTF8'
)
WHERE id = (
    SELECT model_file_to_verification_id
    FROM report.fns_reference_request_journal
    WHERE smevregisterid = :smevRegisterId
    LIMIT 1
)



#if ($db.eval("select count(1) from report.smev_register 
    where ""number"" = ':new_number' 
    and id != :smevRegisterId") > 0)
    $messages.error("Запрос с таким номером уже существует")
#end