Answered

Setting a record variable with SQL Server data

(0) Share

Report

Posted on by hanzelmans

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?

Categories:

Connecting to Data

All responses (3)

Answers (1)

AhmedSalih 6,678 Super User 2025 Season 1 on at

Like (0)

Report

Re: Setting a record variable with SQL Server data

@hanzelmans, nothing else you should be worried about in regards to on-prem SQL. If you faced any other issue, I am always happy to help. 🙂
hanzelmans on at

Like (0)

Report

Re: Setting a record variable with SQL Server data

Thanks a ton Ahmed!
Is there anything else that I should be watching out for when using on-prem SQL Server?
Steve

Verified answer

AhmedSalih

6,678 Super User 2025 Season 1 on at

Like (0)

Report

Re: Setting a record variable with SQL Server data

Hello, @hanzelmans ,

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos