boolean context of (relation_a.relation_b)

Classic Servoy
1

Using Servoy 2.1.1 with Java 1.5 (and previous versions) it has been possible to test the true/false value of a relation (e.g.: if (tablea_to_tableb)) - that appears to work just fine. In javascript it has also been posible to chain relations like tablea_to_tableb.tableb_to_tablec.field_in_tablec - that too appears to work just fine.

But, when I tried “if (tablea_to_tableb.tableb_to_tablec)” that expression appears to evaluate to true when tablea_to_tableb exists but tableb_to_tabelc does not. I figure it should be true only when both of the compoenets are true.

Any reason I shouldn’t be able to test like this?

Thanks,
Neale.

2

use if possible databaseManager.hasRecords()

3

In some perfunctory testing, this appears to work just fine like databaseManager.hasRecords(tablea_to_tableb.tableb_to_tablec) - thanks for the pointer.

BTW, should I be able to find databaseManager.hasRecords() in the calculation field context of the editor? I couldn’t see it there :-(

Neale.

4

The databaseManager is not accessible in calcs, in the past we had utils.hasChildRecords(…) which you still can use (which is now hidden and depricated, due to move to databaseManager)
We will for use in calcs, add the method back (in next version): utils.hasRecords(…) as on databaseManager