I've imported an Access database into my Domino app, but the computed fields did not compute

HCL Domino Domino Forum
1

Hi there!

Does anyone know how to make computed fields compute when importing from Access?

Thanks!

Gérald

2

Subject: I’ve imported an Access database into my Domino app, but the computed fields did not compute.

How are you importing them? There are a lot of ways to get data in from external sources, and how you do it makes a big difference.

3

Subject: In case you already used one of these methods:

Remember field order is important too!

i.e.

FieldA Value

FieldB Value

FieldC A+B Computed Value

will work but

FieldA Value

FieldC A+B Computed Value

FieldB Value

will not since the value of FieldB is not available when FieldC is computed…

4

Subject: Two methods of the top of my head:

If using File, Import:

Check the “Calculate fields on form during document import” option

If using LotusScript:

Investigate the “ComputeWithForm” method

Good Luck!

C>