Monday | 15 APR 2024
[ previous ]
[ next ]

D3 vs UV - WITHOUT

Title:
Date: 2023-03-11
Tags:  

I ran into an issue today with the WITHOUT keyword in a SELECT statement. In D3 the WITHOUT statement checks the entire field and if it is null completely it will add it to the list.

In UV, the WITHOUT option will check each value marked field. This way it will grab records where some values have something but just one of the values can be null and it would be pulled into the list.

An example:

The command:

SELECT INV WITHOUT LINE

A record:

ID: 111
LINE: 3]]5

In D3, this item would not be picked up because the entire LINE field is not null.

In UV this item would be picked up because there is a null entry in the LINE.