Calculations

Layouts and Local Variable Collisions

Calculations, Local Variables, User Interface

In the.fmsoup recently we discussed an issue raised by @menno. He had seen that local variables declared in one object on a layout were accessible in other areas. His immediate concern was that this was a security issue as it was possible that data would be accessible in places where it should not be seen. […]

Layouts and Local Variable Collisions Read More »

choose your favourite math operator

Using Boolean Data in Mathematical Functions

Calculations, Database Design, intermediate level, Scripting

If you are shy of maths you should check this article. Math-geeks know how useful these two simple math tricks are.

Using Boolean Data in Mathematical Functions Read More »

Make Data Entry Easier by Framing Questions as a Boolean Option

Basic Level, Calculations, Database Design, intermediate level, Scripting, User Interface

Learning to use boolean options can improve your database in important ways, via ease of input, data integrity, data storage and data re-use.

Make Data Entry Easier by Framing Questions as a Boolean Option Read More »

Business Data Systems