Quick access to data stored in a database is what powers modern day applications. New in version 17 of 4D is a powerful tool, ORDA. ORDA is a new way to access data in a quick and easy to code manner, utilizing a combination of DOT notation and simple English. Previously available to 4D developers were SQL and native commands (such as the QUERY command) so with ORDA added there is now a third way. This technical note will explore the translation from SQL commands to ORDA commands, highlighting the benefits of moving to ORDA and how complex SQL commands can be written in a much more reader-friendly line of code. It is also important to mention that ORDA is thread safe, while SQL is not!

Download Complete Tech Note: Tech Note Document