DB Value Lookup Issue

[Alan DeKok]

On Jun 15, 2020, at 7:05 AM, Gabriel Marais <gabriel.j.marais at gmail.com> wrote:
> We tried all the suggestions below but unfortunately still receive a 0
> value when the number is larger than 4 294 967 296.
> 
> We edited our query to cast values as a 64 bit integer. Also edited
> the dictionary to make Acct-Diff a interger64.
> ...
> 
> The values in our SQL db are bigint.
> 
> Still unsure why we're getting a 0 :(

  If the output of the expansion is "0", then the issue is in your SQL server.  There's little we can do to help there.  You'll have to read your SQL server documentation to fix the query.

  Alan DeKok.