The "get first table" throws an error even after I set Table_DisableErrorChecks(true). But only when I create chunk file with Dexterity for Dynamics GP 2015. Worked ok in prior versions.
Any idea's what i can do?
Sample of the code:
local boolean lresult;
local boolean lresult2;
lresult2 = Table_SetCreateMode(false); { do not automatically create table when accessed }
lresult = Table_DisableErrorChecks(true); { do not error if table not found }
get first table AIM_Vendor;
if err() = 9 then {table does not exist }
close table AIM_Vendor;
lresult = Table_FlushCache();
if 'SQL Server' of globals > 0 then
{If system administrator logged in then create tables }
if ('User ID' of globals = "sa") or ('User ID' of globals = "DYNSA") then
call AIM_Register_Triggers;
call AIM_New_Company;
else
AIM_Active of globals = false;
end if;
else
AIM_Active of globals = false;
end if;
else
call AIM_Register_Triggers;
call AIM_New_Company;
end if;
lresult2 = Table_SetCreateMode(true); { turn table create back on }
lresult = Table_DisableErrorChecks(false); { turn table error checking back on }
*This post is locked for comments