Microsoft Dynamics AX (Archived)

Delete field - value(record) from table with X++

(0) Share

Report

Posted on by Vladislav

159

Hi everyone,

I want to delete one record in custom table with name ImportSalesPRiceParameters and filed Journalname.

This is my classDeclaration:

public class Test
{
 ImportSalesPRiceParameters    ispp;
       
}

Here is get method:

[
    SRSReportDataSetAttribute(tableStr(ImportSalesPRiceParameters))
]
public ImportSalesPRiceParameters getISPP()
{
    select ispp;
    return ispp;
}

Delete method:

public void deleteFromISPP()
{
    select pda where ispp.JournalName == 'SalesCRM' && ispp.dataAreaId == '110';
    ispp.delete();
    
}

This is field in SQL:
0250.s1.JPG

In other languages like C# I can write

if(ImportSalesPRiceParameters.Any())

{

//delete record or make it null value;

}

I want Journalname to assigned null value.How to make it with X++

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Amir Nazim 5,994 on at

Like (1)

Report

you can select the record for update using selectForUpdate(true)

set ispp.JournalName = "";

then call ispp.update();

Please check

docs.microsoft.com/.../xpp-data-query

Was this reply helpful? Yes No
Suggested answer

Pradeep_Prakash 717 on at

Like (0)

Report

HI,

You have selected pda its should be

select ispp where ispp.JournalName == 'SalesCRM' && ispp.dataAreaId == '110';

ispp.delete();

Was this reply helpful? Yes No
Martin Dráb 237,908 Most Valuable Professional on at

Like (0)

Report

Vladislav, please separate tags with comma and don't prefix them with #. You attached a single tag #sql #ax2012R3 #delete instead of three tags.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,908 Most Valuable Professional on at

Like (1)

Report
Assing NULL to a field is a completely different thing than deleting a record.

Your code is almost correct, you just select from a wrong variable and you need a few more pieces.

Try this:

ttsBegin;

select forUpdate issp where ispp.JournalName == 'SalesCRM' && ispp.dataAreaId == '110'; if (ispp) { ispp.delete(); }

ttsCommit;

Was this reply helpful? Yes No

Community site session details

Delete field - value(record) from table with X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Delete field - value(record) from table with X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates