How can i return the RECID from a selected record

(0) Share

Report

Posted on by Community Member

Hey,

how can i return the RECID from a selectede record.
I try it with this code but it does not work.

  int64 stiRecId;
     str stiRecIdStr;
    ;

    //TODO Anfrage um bestellt durch erweitern mund ggf. Status != Übernommen
    select salesTableImport
        where salesTableImport.CustAccount == account
            && salesTableImport.OrderedBy == orderedBy;
        
  
    stiRecId        = salesTableImport.RecId;
    stiRecIdStr     = int642str(stiRecId);

    if(salesTableImport.RecId != 0)
    {
     //   return salesTableImport;
        //Info('Kopf ist bereits vorhanden');
    }

Thanks for help.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (2)

Sort by

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

The simplest AX syntax is more or less this: select FIELDLIST from TABLE where CRITERIA.

If you do not provide a FIELDLIST, it pulls back all fields, including RecId.

If you do not have a value, it means that either your table is empty, or you do not have a value matching your selection CRITERIA in the statement.

Or you may be in the wrong company account, probably forgot to switch from the default DAT legal entity in your dev workspace.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

The if() statement works fine.

My only problem is that i cant return the recId.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

I am unsure what do you mean by return, please clarify.

The returned value of a method must match what has been defined as the method return value. If you want to return RecId, it must be of type RecId as well. Unfortunately you did not paste that, so we cannot tell if that is the problem. For example:

public RecId dosomething()

{

RecId test = 123456;

return test;

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

i select() a record with the select code.

I get a record and i can query the recId from the record.

but I want to give it back to the previous class / methods.

Exmaple

retrun salesTableImport.recId;

So my question is how is the syntax to return the recId from the selected record.

Thank you for help.

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report
Copy link

Link copied!
Where are you doing this?

It's works if you have records.

select recId
from salesTableImport where salesTableImport.CustAccount == account && salesTableImport.OrderedBy == orderedBy; return salesTableImport.recId;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I have a record and get a recId too.

But i can not return them.

If i try this code : return salesTableImport.recId;

I get an error: The operand is not compatible with the type of function

What do you mean with 'Where are you doing this ?' ?

I do this in a method of my class, where i create recrods.

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report
Copy link

Link copied!

So I suposse you have something like

public RECID functionName()

{

select recId

from salesTableImport

where salesTableImport.CustAccount == account

&& salesTableImport.OrderedBy == orderedBy;

return salesTableImport.recId;

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!
No i do this all in this method,

void createSalesTableImport() { int64 stiRecId; str stiRecIdStr; ; //TODO Anfrage um bestellt durch erweitern mund ggf. Status != Übernommen select salesTableImport where salesTableImport.CustAccount == account && salesTableImport.OrderedBy == orderedBy; stiRecId = salesTableImport.RecId; stiRecIdStr = int642str(stiRecId); if(salesTableImport.RecId != 0) { return salesTableImport; //Info('Kopf ist bereits vorhanden'); } else if(salesTableImport.RecId == 0) { datum = today(); salesTableImport.clear(); //TODO salesTableImport.ImportId = ; salesTableImport.companyGLN = companyGLN; salesTableImport.CustAccount = account; salesTableImport.SearchName = searchName; salesTableImport.OrderedBy = orderedBy; salesTableImport.Backlog = backlog; salesTableImport.Email = email; salesTableImport.OrderNum = orderNum; //salesTableImport.ProvisionalContractId = provisionalContractId; salesTableImport.CustName = name; salesTableImport.DiscReadingDate = datum; //salesTableImport.ImportStatus = importStatus; salesTableImport.ContractId = contractId; importLineTable++; salesTableImport.ImportLine = importLineTable; salesTableImport.insert(); } //TODO SalesTableImport fehlt noch; //Vorläufige auftragsummer //ImportStatus }

And it works i only want to return the recId that i selectetd.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

Same answer as my reply. You are not returning the type you have declared.

Void = do not return anything, no type

You need RecId there as explained already.

Was this reply helpful? Yes No
Verified answer

Rudi Hansen 4,079 on at

Like (0)

Report
Copy link

Link copied!
Your method is not defined to return anything. (void means do not return a value)

And your return statement returns the table, not the tables recid (should be return salesTableImpor.recid)

Also your method needs to return something even if no record is found, that's why i have inserted the last return line.

So your method should look like this.

recid createSalesTableImport() { int64 stiRecId; str stiRecIdStr; ; //TODO Anfrage um bestellt durch erweitern mund ggf. Status != Übernommen select salesTableImport where salesTableImport.CustAccount == account && salesTableImport.OrderedBy == orderedBy; stiRecId = salesTableImport.RecId; stiRecIdStr = int642str(stiRecId); if(salesTableImport.RecId != 0) { return salesTableImport.recid; //Info('Kopf ist bereits vorhanden'); } else if(salesTableImport.RecId == 0) { datum = today(); salesTableImport.clear(); //TODO salesTableImport.ImportId = ; salesTableImport.companyGLN = companyGLN; salesTableImport.CustAccount = account; salesTableImport.SearchName = searchName; salesTableImport.OrderedBy = orderedBy; salesTableImport.Backlog = backlog; salesTableImport.Email = email; salesTableImport.OrderNum = orderNum; //salesTableImport.ProvisionalContractId = provisionalContractId; salesTableImport.CustName = name; salesTableImport.DiscReadingDate = datum; //salesTableImport.ImportStatus = importStatus; salesTableImport.ContractId = contractId; importLineTable++; salesTableImport.ImportLine = importLineTable; salesTableImport.insert(); } return salesTableImport.recid; // Inserted so the method returns something no matter what. //TODO SalesTableImport fehlt noch; //Vorläufige auftragsummer //ImportStatus }

Was this reply helpful? Yes No