Check field with data type int64

(0) Share

Report

Posted on by VoltesDev

Hi guys,

If I want to compare a field with data type int64, is empty or not, what should I use ?

For example there is one table : CustLedgerAccounts. this contain field SummaryLedgerDimension which is int64. I need to create a while select statement that involve this field to be empty.

Something like this, but this is error :

while select forupdate custLedegerAccounts where custLedegerAccounts.SummaryLedgerDimension == ""

&& custLedegerAccounts .AccountCode == TableGroupAll::Table

Thank,

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi VoltesDev,

You can use custLedegerAccounts.SummaryLedgerDimension == 0 or !custLedegerAccounts.SummaryLedgerDimension

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi VoltesDev,

Int64 default value is 0.

docs.microsoft.com/.../integers

Was this reply helpful? Yes No
VoltesDev on at

Like (0)

Report

Hi all,

just curios, if I'm using sysTableBrowser, those field are empty, not 0. Is it the same ?

Thanks

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Volted,

Are you checking it is empty in SSMS?

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi VoltesDev,

It's just appearance set up for the field. You can check the value on SQL side and for integers (including int64) it's 0.

Was this reply helpful? Yes No
VoltesDev on at

Like (0)

Report

Hi Blue,

No, it's still in Visual Studio. I'm creating a batch job using SysOperationFramework. Just want to make sure, my query is correct.

Noted from Sergei, in SysTableBrowser is a display only.

Thanks.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

SysTableBrowser doesn't always show what is in the database. It can also show a value from related table instead of int64 (RefRecId). So it's always good to check the actual values directly from the database. "Empty" value for all numeric fields is always zero.

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Voltes,

Nikolaos has already explained, do you have any other questions?

Was this reply helpful? Yes No
VoltesDev on at

Like (0)

Report

Hi,

it's cool. thank you all

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

LedgerDimenion fields are integer throughout the system , you can not compare string with integer thats the reason you are getting this error. Compare it with zero.

Was this reply helpful? Yes No