Lookup rich text fields in any database
Posted on 2004-08-13
For reporting reasons I need to have an agent that scanns all databases on a server and reports in which databases a rich text field is used.
I've got the code to scan the databases and walk through all forms in a database, but I can't seem to extract the rich text fields from the form note.
Using the API function NSFNoteInfo for a rich text field the data type is always returned as TYPE_INVALID_OR_UNKOWN (=0), where it should be TYPE_COMPOSITE.
Does anybody know of a way how I can walk through all forms in a database and check if there is a rich text field on it? Using LotusScript or C API or any other method?