SQL::Query::GenerateNativeSyntax Function
/documentation/pages/Ref/Api/Namespace/SQL/Query/GenerateNativeSyntax Method.xml
Generate a native SQL statement using the selected syntax associated with the current or passed connection.
Define an AlphaDAO SQL Query
/documentation/pages/Guides/Databases/Working with SQL/Define an AlphaDAO SQL Query.xml
Step by step instructions for defining an SQL Query, from establishing a connection to retrieving data.
Grid Component Builder - Setting Default Properties
/documentation/pages/Server/Guide/Design/View/Grid/Grid Component/Grid Component Builder Setting Default Properties.xml
The Options, Set Default Properties command in the Grid Builder has always allowed you to set default properties for the Grid when you create a new Grid. However, if you created a new Grid from a Template, the default properties that you set were not honored. They were only honored if you created a blank new grid. Now, the default properties are used even if you use a template. This makes it much easier to customize the Grid builder for developers whose native language is not English.
SQL::Query::ArithmeticOperator Enumerated Type
/documentation/pages/Ref/Api/Namespace/SQL/Query/SQL Query ArithmeticOperator Enumerated Type.xml
Internal use only. This is an enumerated type with one of the values below.
SQL::Query::DuplicateOption Enumerated Type
/documentation/pages/Ref/Api/Namespace/SQL/Query/SQL Query DuplicateOption Enumerated Type.xml
Internal use only. This is an enumerated type with one of the values in the list below:
SQL::Query::OuterJoinType Enumerated Type
/documentation/pages/Ref/Api/Namespace/SQL/Query/SQL Query OuterJoinType Enumerated Type.xml
Internal use only. This is an enumerated type with one of the values in the list below:
SQL::Query::LogicalOperator Enumerated Type
/documentation/pages/Ref/Api/Namespace/SQL/Query/SQL Query LogicalOperator Enumerated Type.xml
Internal use only. This is an enumerated type with one of the values in the list below:
Execute INSERT Query on a SQL Database
/documentation/pages/Guides/Desktop/Design/Data/SQL/Execute INSERT Query on a SQL Database.xml
The Execute INSERT Query on a SQL Database action allows you to insert one or more records into a remote SQL database. Alpha Anywhere will use AlphaDAO (Alpha Data Access Objects) to connect to the remote database.
TGRDL_CUST Tabbed GridLinker Component
/documentation/pages/Obsolete/Alpha Sports/Components/TGRDL_CUST Tabbed GridLinker Component.xml
Reviews and edits customer records and customer sales history.
Select Statements
/documentation/pages/Server/Reference/Design/Data/SQL/AlphaDAO Reference (SQL)/Select Statements.xml
In order to retrieve data from a database using SQL, you must create a SELECT statement, which may retrieve zero, one, or many rows, depending on how you format it. The rows are returned in a collection usually referred to as a result set. The SELECT statement, although there are some variations for advanced queries, is of the form: