Hi all ! Is it possible to use DataConnectionResources within dbcommand ? I ve some fields getting values by @dbcommand(“odbc”…) but I don t want to setup ODBC on each client, I just want to setup it on server…Any ideas please
Subject: RE: dbcommand with DCR ???
You can’t use a DCR directly from @DbCommand, but if you set up virtual fields in some documents, and you create a view of those documents, and just do a regular Notes @DbLookup to that view, then you can pull values from the relational database using the key of your virtual activity. Note that you must use the field name, not a column number, to get the live value from the database (and if there’s a column that displays the field you’re trying to retrieve, even that won’t work).
For some other options, read this article:
Off-loading Lotus Enterprise Integration tasks to the server