We are creating an application that uses an on-prem SQL Server db.
I'm running into an odd situation where when a view is queried, it will return data but will not populate all of the columns in the global variable record.
For instance, if my SQL view is returning a row that contains:
- lastname
- firstname
- id number
- grade
- whatever
- whoever
When it populates the variable, it will only populate a column that is used in the lookup. In the case below, it would populate the personID column but nothing else. If I have a text label on a screen, it would populate the column that I use in the label.
Set(wtf,LookUp(
vw_CaseNumber,
personID = 10031));
If I just do a lookup, it's fine:
I have no idea what's going on, but it's frustrating. I want to build a global variable and not have to do a lookup for the same data. It doesn't matter if I use a record, collection, etc. Still the same problem.
Any clues?
