KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Note: SQL to ORDA
PRODUCT: 4D | VERSION: 17 | PLATFORM: Mac & Win
Published On: June 28, 2018
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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

Commented by David Michels on November 19, 2018 at 3:39 PM
I accept