str2int64 conversion

(0) Share

Report

Posted on by Koti9999

Hi DAXers,

int64 myint64,;

myint64 = str2int64('test');

info("result : %1" ,myint64);

I am getting 0 in info dialogue.

Can anyone please help me

Thanks

All responses (5)

Answers (1)

Koti9999 55 on at

Like (0)

Report

RE: str2int64 conversion

Thanks a lot Nikolos...as you suggested I have assigned recid..i am able get produnitid.
Verified answer

nmaenpaa 101,158 Moderator on at

Like (1)

Report

RE: Ax 2012 str2int64 conversion

Looks like you want to get RecId (int64) of some record, but at the moment you have the natural key (string). You need to use "L1K1" to search for the corresponding record from the related table (if you don't know which table to go to, you will find the table by looking at relations of the table that you have in "production" variable). Once you find this record, assign it's RecId to your "resourceGroup" variable.
Martin Dráb 233,305 Most Valuable Professional on at

Like (0)

Report

RE: Ax 2012 str2int64 conversion

Again, L1K1 isn't a number, therefore the conversion is meaningless.

What are you trying to achieve?

Maybe it means that you have ProUnitId, which is a unique key of a table and you need RecId corresponding to this ID, but you str2int64() can't convert 'L1K1' to something like 67879890228. You'd need a query to database to obtain the additional piece of data.
Koti9999 55 on at

Like (0)

Report

RE: Ax 2012 str2int64 conversion

Thanks for replying.. actually i have below scenario..

int64 resourcegroup = str2int64(production.prounitid);

Here produnitid is string,it will fill as 'L1K1'
Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: Ax 2012 str2int64 conversion

What would you want to get as a result? What are you trying to do?

You can't convert text to number. That's why you get zero.

It's only possible to convert a string that contains numbers, such as "54".