Open a Grid component
/pages/Ref/Action Javascript/Open a Grid component.xml
Opens a grid component in a pop-up window, or in a DIV on the current page. This requires first defining a grid component.
Ordering Lookup Entries - Grid Component
/pages/Server/Guide/Design/View/Grid/Ordering Lookup Entries - Grid Component.xml
Often you will want to display a list of values selected from a table. It is often desirable to specifically order these entries, instead of allowing them to display in record order or alphabetically. Here is a technique for solving this problem. This example uses a drop down list box on a dialog component, but the technique works equally well with a list box on a grid component.
SQL::Query::Execute Function
/pages/Ref/Api/Namespace/SQL/Query/Execute Method.xml
Execute the current statement using the current or passed connection. Optionally providing argument values as an object or as XML. Note: Argument values are merged with those already set on the query.
SQL::Query::Validate Function
/pages/Ref/Api/Namespace/SQL/Query/Validate Method.xml
Execute the current statement using the current or passed connection.
SQL::Query::Join Object
Internal use only. The SQL::Query::Join object fully describes the joining of a parent table to a referenced table. Key properties include .JoinType and (if an outer join) the .OuterJoinType.
SQL::Query::GroupBy Object
Internal use only. The SQL::Query::GroupBy object describes the GROUP BY and HAVING expressions of a SELECT statement. The GROUP BY clause contains an optional ALL keyword and a list of column expressions upon which to group the result set. The optional HAVING clause is evaluated for each aggregated row to determine whether the summary will be included in the output.
Grid Component - Checkbox Column - Custom Ajax Callbacks
/pages/Server/Guide/Design/View/Grid/Grid Component/Grid Component Checkbox Column, Custom Ajax Callbacks.xml
When you do a custom Ajax callback, the 'e' object that is passed into your Xbasic function that handles the callback contains a lot of useful information. Now, the 'e' object contains 3 additional properties that are automatically set if the grid has a checkbox column. The properties are:
SQL::Query::ReleaseConnection Function
/pages/Ref/Api/Namespace/SQL/Query/ReleaseConnection Method.xml
Clear out the connection property.
SQL::Query::TableReference Object
Internal use only.
SQL::Query::ColumnOrder Object
Internal use only. A SQL::Query::ColumnOrder object describes an entry in the ORDER BY clause.