Tips

Display your dashboard on a big TV screen

Today, big screens are everywhere. At the airport or train station for arrival/departure. In production areas for failure/success or production numbers. In call centers for activity or calls in queue. In stock exchange for a ticker.

Your first thought could be to use a normal computer, macOS or Windows, with a “27” or 30” screen. Expensive, but easy to do. But besides the high price, you need to run a 4D app, launch it, update it, all just to display a picture?

Tips

Detailed analysis of your database structure

Did you know that you can retrieve very detailed information on a table, field, indexes, relation or even on the complete database structure? This kind of information is always very useful for analysis or introspection purposes. Of course, you could use the 4D Pack deprecated commands: _AP Get field infos and _AP Get table info. Another option is to use the SQL system tables.

None of them allows you to retrieve all information. So why use a plug-in or SQL when you could use a 4D command? The EXPORT STRUCTURE command returns the complete database structure definition in an XML tree. This command exists since 4D v14 R4.

Page 13 of 13