Cache SQL question

Question

Question

Viroj (Pat) Pad... · Jun 9, 2020

I have a table with 4 column: MRN (primary key), Name, DOB, and Gender. I want to bring in the values on all of the columns into a DTL. Currently, I declare variables for each of the columns and using 3 select statements.

&sql(SELECT Name INTO :Name FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

&sql(SELECT DOB INTO :DOB FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

&sql(SELECT Gender INTO :Gender FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

Is there a way to do this in a single select statement?

Discussion (4)1

Log in or sign up to continue

Sridhar Mandalapu · Jun 9, 2020

This can be achieved by changing your SQL statement into this:

&sql(SELECT Name, DOB, Gender INTO :Name,:DOB,:Gender FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

0 0

Eduard Lebedyuk · Jun 9, 2020

&sql(SELECT Name, DOB, Gender INTO :Name, :DOB, :Gender FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

0 0

Robert Cemper · Jun 9, 2020

see: https://cedocs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=RSQL_into

&sql(SELECT Name, DOB, Gender INTO :Name,:DOB,:Gender
FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

1 0

score 0 · Answer 1 · 2020-06-09T13:57:14-04:00

Viroj (Pat) Pad... · Jun 9, 2020

Thank you all.

0 0