ODBC not seeing fields in subforms

HCL Domino Domino Forum
1

We are trying to use the latest ODBC (3.02b) driver to connect to our new ND6 database using Crystal Reports. ND6 is 6.01

We can connect to the database and see the forms but only the fields on the main form are visible, i.e. all of the fields on any subforms are not shown. Our database is making extensive use of subforms and we are now running out of ideas! We have tried moving fields from the subform to the main form and theyfields then become visible but this is impractical for all the forms in the database.

Has anyone else seen this and know of any workarounds?

2

Subject: Problem identified

Having done some more work on the problem, it seems that if the subform has an alias then the fields do not appear through the ODBC driver!!

The workaround is to remove all the subform aliases, delete the subforms and re-insert them.

Does this look like a bug?

3

Subject: Try accessing a view — use a special form

Hi Steve,I’ve not tested the solutions, but they might serve as a set of new ideas:

  • with NotesSQL you can access documents based on a view or based on their form (using the internal index). Views are read only…

So try to use the view access to read what u need.

  • Cheat the system:

In your “normal” views use a Form formula to point to your normal forms (the one with the subforms). Have your LotusScript/XML Guys write an Agent that uses DXL to create one new form that is a merged one. It ain’t need to be pretty since it never shows to users and u could automate this. Then make sure your documents have the internal form name…

here u are.

Let me know if it helps