I have created a temporary table .I need to insert the count of another field in to the newly created temporry table.
I wrote following job to do that. But it was throwing an error.
static void updateLoa(Args _args)
/insert into #LocalTempTable( loa,cnt) select caeloa,COUNT(caeloa) from CAESECURITYPROJ
group by caeloa in sql/
while select caeloa,COUNT(caeloa) from _caeSecurityProj
group by caeloa
loa.caeLoa = _caeSecurityProj.caeLoa;
loa.cnt = _caeSecurityProj.COUNT(_caeSecurityProj.caeloa);
Kindly let me know how to write the above statement in X++.