delete

Finance and Operations/AX Technical Forum
1

Hi frinds,

i want delete no of records in a table throufh code

for example,test-01,test-02…test-100 like this

i want delete from test-01 to test100

please tell me

Thanks

2

Hi Murali,

write the sql statement like,

void deleteLookupData(Guid formInstanceId)
{
AifAdapterLookup adapterLookup;

delete_from adapterLookup

where adapterLookup.FormInstanceId == formInstanceId;
}

in where condition Table.field >= test-01 && Table.field <= test-100

Thanks,

valeru.

3

Hi Murali,

I have not tried this. Perhaps this may work -

delete_from
where <table.field name> like ‘test*’