Domino Code Fragment

Code Name*
How to Use @DbCommand to Access More Than One Column of Data		Date*
04/28/2024		Source (or email address if you prefer)*
Rlatulippe@romac.com
IP address:.3.15.202.4
Description*
By concatenating multiple @DbColumn formulas, however, you can return multiple columns of data.		Type*
Formula		Categories*
(Misc)
Implementation:
Required Client:
Server:
Limitations:
Comments:
Files/Graphics attachments (if applicable): Code:
Problem:
You are attempting to return two or more columns of data from an external data source, with a formula similar
to the following.

@DbCommand("ODBC";"Access";"";"";"Select Column1, Column2 from Table1")

Although no error is returned, you get only the first column of data.

Solution:
An individual @DbColumn formula can return only one column of data. By concatenating multiple
@DbColumn formulas, however, you can return multiple columns of data. You can use, for example, a syntax
such as the following:

C1:=@DbCommand("ODBC";"Access";"";"";"Select Column1 from Table1");
C2:=@DbCommand("ODBC";"Access";"";"";"Select Column2 from Table1");
C1+C2