Что-то не так
Результат компиляции:
SetEval(ReTranMacro([Trim(BK:GetLanAddress(doc.CLEANOBJ))]))
Но получаю ошибку:
Error 7200: AQE Error: State = 42000;
NativeError = 2115;
[iAny
where Solutions]
[Advantage SQL Engine]
Expected lexical element not found: AS [Parsing Expression (column 7 in the
SELECT clause)]
-- Location of error in the SQL statement is: 233
Query text :
INSERT
INTO #sodcontrol(id,type,koddoc,uniquesod,fieldname,parentvalue,childvalue,comment)
SELECT 2 as id, 1 as type, doc.koddoc,0 as uniquesod,'ADDRESS' as fieldname, CAST(doc."ADDRESS" AS SQL_CHAR) as parentvalue,/*!*/ CAST(Trim(BK.GetLanAddress(doc.CLEANOBJ)) AS SQL_CHAR) as childvalue, 'Trim(BK.GetLanAddress(parent.CLEANOBJ))'
FROM dc000027 doc
WHERE doc.priznak= 109 AND doc."ADDRESS" <> Trim(BK.GetLanAddress(doc.CLEANOBJ))
Поле "ADDRESS" Строка(200), если важно
Post's attachmentssave.formula 273 b, file has never been downloaded.
You don't have the permssions to download the attachments of this post.