SQL stands for Structured Query Language and is typically pronounced ìS.Q.L.î or†ìsequelî.† It is a language that is used by relational database management systems†to access databases, and to create, modify and destroy database objects. 4D v11 SQL has a native SQL engine that includes the ability to control 4D tables †and fields.† This grants the developer the opportunity to use the SQL language in†any 4D method to accomplish a myriad of tasks.† When used together, 4D and SQL†provide more flexibility to access and manipulate databases than ever before. If you are a 4D Developer who has little or no experience with SQL, this is a good†place to start.

Download Complete Tech Note and Example: Windows | Mac