The new SQL engine native to 4D provides another way to query your database while taking advantage of the proven features of a widely known standard.
Learning the 4D language is no longer a requirement to enriching or querying your database.
SQL 92 standard support provides a real possibility of manipulating records of the database (DDL) as well as the structure (DML).
Because every development has different needs, there are several ways to put SQL in place using 4D.
4D allows writing simple SQL structures such as the IMMEDIATE EXECUTE command that allows executing a request or even more evolved structures within a START SQL…END SQL tag. This allows writing a series of requests that adhere to SQL 92 standards.
• Visualizing the result of SQL statement
Native integration of SQL in 4D is such that not only is it possible to use the two languages within a single method, but also to send the results of SQL requests in 4D objects (such as variables, fields, or controls like Listbox.)
Here’s a simple example: view the result of a request in an array becomes as easy as 1, 2, 3.
1) Place a Listbox in a form
2) Write your request in the script of a button
3) Execute it and view the result
4D automatically created the necessary columns and headers for you before filling the Listbox with data.
4D also allows, thanks to SQL, communicating with external data sources, including other 4D databases or even Oracle, MySQL, etc. databases.
A SINGLE line of code allows you to redirect your request to external data sources.
Adapt to your environment without having to rethink your development!
<< Web Services |
International |
Firmenprofil | Kontakt
| Site Map | © 4D 1995 - 2008 | Schriftgröße
ändern: [A]
[A]
[A] |
|
4D RSS Feeds - * Externer Link
Produktübersicht 
4D Produkte
Features Liste