Magoo5289
May 27th, 2004, 09:36 AM
I am attemtping to pull directly from a lotus notes database using ODBC conenctions as it supports the command function giving stronger SQL capabilities and I have run into two problems.
1) Does ODBC not support the count command? I can my sql statement fine but as soon as I set it to use the count function, it generates an API driver error.
2) Is there a way to link three lotus notes databases together in an SQL statement as I need to count and group for all three databases in the same subreport.
1) Does ODBC not support the count command? I can my sql statement fine but as soon as I set it to use the count function, it generates an API driver error.
2) Is there a way to link three lotus notes databases together in an SQL statement as I need to count and group for all three databases in the same subreport.