How to generate RECID through SQL Server database in AX

Insert the data in AX from other sql server database through SP.

ALTER procedure [dbo].[SP_GetAXRecID](@axRecid bigint output)
as
begin
update [Server].Databse.dbo.systemsequences
set @axRecid = nextVal = nextVal + 1
from [Server].Databse.dbo.systemsequences where
dataareaid = 'dat' and name = 'SEQNO'
end

Display all AOT Table in lookup / get all table ids in lookup / List of table ids in lookup

static void lookupAOTTables(FormStringControl _ctrl)
{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(UtilidElements), _ctrl);
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange nameQBR, typeQBR;
;
sysTableLookup.addLookupfield(fieldnum(UtilidElements, Id));
sysTableLookup.addLookupfield(fieldnum(UtilidElements, Name));

queryBuildDataSource = query.addDataSource(tablenum(UtilidElements));


//nameQBR = queryBuildDataSource.addRange(fieldnum(UtilidElements, name));
//nameQBR.value('Cust*');


typeQBR = queryBuildDataSource.addRange(fieldnum(UtilidElements, recordType));
typeQBR.value(SysQuery::value(UtilElementType::Table));


sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}

Microsoft Dynamics AX 2012 Reporting Cookbook

Hi,
Please click here to buy Microsoft Dynamics AX 2012 Reporting Cookbook

Thanks

AOT AX 2012 and 2009

Dynamics AX Trace Collection / AX X++ coding and tracing with performance

Click here part 1
Click here part 2
Click here part 3