I am to try to use the HPrepareSQLQuery with SQLSERVER native access but I always get and same error in the HExecuteSqlQuery.
Error:
native SQLSERVER access error.
Error Number = 100
Message SQL Server 2812, état 62, sévérité 16 :
Could not find stored procedure 'select empresa,empregado from rel_emp_pes_gpv where empresa='.
SQLServer a renvoyé l'erreur suivante :
General SQL Server error: Check messages from the SQL Server., n° : 10007, sévérité : 5
Code:
wqry is Data Source
IF NOT HPrepareSQLQuery(wqry, "MYCON", hQueryWithoutCorrection, "select empresa,empregado from rel_emp_pes_gpv where empresa=@empr and empregado=@ente") THEN
Error("hprepare",ErrorInfo())
END
wqry.empr=1
wqry.ente=853
IF NOT HExecuteSQLQuery(wqry) THEN
Error("hexecute",ErrorInfo())
END
HCancelDeclaration(wqry)