Dynamics Community Forum Thread Details

get first table giving: Error Registering Table [Not Found]

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 }