One of our customers supplied the following information :
I have not used the SQLLink plugin to return multiple variables but I would
first check my query to make sure I get the desired results in the database
program that I use. For example I am using Access, I write the query in
access and then execute it to make sure I get the results I need. Then I
view the SQL and copy it and paste it into the OGM plugin setup criteria and
modify the variables to be variables I pass from IVM (i.e. SELECT %Friend%
FROM Friends).
FYI - I have had problems with long SQL queries getting truncated by IVM,
which forced me to make two database queries to get all the information I
wanted from the database. I also had problems with pulling text information
in as values because Access requires double quotes to be used around text
when making calls to the database. When you use quotes in the call executed
in the plugin the query gets truncated and will not work. Therefore the
lesson learned is to try to make calls to the database using numerical
values or single word text values as variables to avoid this from happening.
Hope this helps.