|
|
|
|
|
|
|
|
|
|
version 11
If we now want to know how many movies more recent or equal to 1960 are in the Video Library.
The code 4D would be:
• Using SQL code, the above query becomes:
• Using the generic SQL commands, the above query becomes:
• Using the QUERY BY SQL command, the above query becomes:
• Using the SQL EXECUTE IMMEDIATE command, the query above becomes:
As in the previous section, in order to test all the above examples, simply launch the "4D SQL Code Samples" database and go to the main window. You can then choose the query mode and press the WHERE clause button.
|
|
|
|
|
|
|
|
|
|