Get Subform data using notesSQL

HCL Domino Domino Forum
1

Hi,

Is it possible to extract subform data from notes using notesSQL?

I read somewhere that in order to do so, one needs to create a view. But if we have hundreads of databases and subform’s, how can we do that?

Is any other way to get the subform info? C API?

Info:

Lotus domino – release 7.0.2FP3 on Windows NT 5.2

ODBC Driver: 8.0

Thanks in advance,

Sérgio Lopes

2

Subject: Get Subform data using notesSQL

If you simply mean document data that was entered (or is displayed) using a subform, then the COM, Lotusscript or Java interfaces can do it (forms and subforms are not germane to the question, just items and their content and flags, and the items will appear on the document regardless of access to the subform).

3

Subject: Get Subform data using notesSQL

You probably have choices in between NotesSQL and the C API. Why don’t you explain more about what you’re trying to do, and where/how your code will be running?

-rich