Previous Topic Next topic Print topic


Select Type of Query to Create dialog box

Query Type List
A list of all query types available.
Generate query as TSQL stored procedure
Generates a TSQL stored procedure. When unchecked, OpenESQL Assistant does not generate a stored procedure query. Available when the Type Stored Procedure OpenESQL Assistant Option is set to TSQL and you have selected a SQL Server data source.
Generate query as SQL CLR stored procedure
Generates a SQL CLR stored procedure. When unchecked, OpenESQL Assistant does not generate a stored procedure query. Available when the Type Stored Procedure OpenESQL Assistant Option is set to SQL CLR and you have selected a SQL Server data source.
Generate query with FOR UPDATE
Generates a FOR UPDATE clause as part of a SELECT (cursor) or SELECT DISTINCT (cursor) SQL query.
Generate query with WHERE CURRENT OF
Generates a WHERE CURRENT OF clause as part of an UPDATE or DELETE SQL query.
SP Name
The name of the stored procedure you want to generate. A default name is supplied; however, you can override this by typing in a name of your choice. Applies to stored procedure queries only. Available only when you have selected a SQL Server data source.
Cursor Name
The name of the cursor generated for the query. A default name is supplied; however, you can override this by typing in a name of your choice. Available when the Generate OpenESQL Assistant Option is set to EXEC SQL.
Datarows Name
The name of the DATAROWS instance declared in the query. A default name is supplied; however, you can override this by typing in a name of your choice. Available when the Mode OpenESQL Assistant Option is set to ADO.NET and the Generate option is set to either EXEC ADO - disconnected model or EXEC ADO - connected model.
Previous Topic Next topic Print topic