@DbCommand Question

HCL Domino Domino Forum
1

Right now, this query returns one column (NAM). How can I modify it to return both columns (NAM & TST) (without using LotusScript - I can already do it in LotusScript, I’m seeing if the @ commands are faster and easier)?

Thanks

Sub Initialize

Dim macro As String

Dim theResult As Variant

Dim qryString As String



qryString = "SELECT DISTINCT NAM, TST FROM myTable WHERE ACCT = '15317249'"



macro = {@DbCommand( "ODBC" : "NoCache" ; "dbName"  ;"id" ; "pwrd" ;"} & qryString &{": "Discard"  )}





theResult = Evaluate(macro)

End Sub