If i run this code in WD22 everything is ok but in WD27 the error is always Error in the SQL code of the <_SOURCE_wqry_2> query. Unable to initialize the query.
Sample code:
g_equipamento is Data Source
H_FiCH is string=CompleteDir(fExeDir())
HCancelDeclaration(g_equipamento)
IF NOT HDeclareExternal(H_FiCH+"Equipamento.FIC",g_equipamento) THEN
Error("error hdeclare external "+H_FiCH,ErrorInfo())
RETURN
END
HMode(g_equipamento,hModeMulti)
HClose(g_equipamento)
HOpen(g_equipamento,hORead)
wsql is string
wqry is Data Source
wsql="select eqp_mac1,eqp_mac2,eqp_mac3,eqp_mac4 from g_equipamento"
IF NOT HExecuteSQLQuery(wqry,hQueryDefault,wsql) THEN
Error("error in HExecuteSQLQuery",ErrorInfo(errFullDetails))
RETURN
END
HReadFirst(wqry)
WHILE NOT HOut(wqry)
Trace(wqry.eqp_mac1)
HReadNext(wqry)
END
HCancelDeclaration(wqry)
HCancelDeclaration(g_equipamento)
Regards
Paulo Oliveira