rr-sql and lotus notes
rr-sql and lotus notes
has anyone used rr-sql and the lotus notes ODBC driver to report on large text fields? the lotus notes documents are actually RTF format but using ODBC the lotus notes "views" are tables and the fields are shown as fields. the problem is how to handle large text fields - something around 1-2,000 chars or even larger. i have been successful using ODBC for text fields less than 255 chars - but anything larger than that gets truncated by odbc (with no error message).____