Modifying SQL SELECT statements

If the data source is SQL (such as Quick Select, SQL Select, or Query), you can graphically modify the SQL SELECT statement.

To modify a SQL data source:

Select Design>Data Source from the menu bar.

Sybase WorkSpace returns you to Visual SQL. (If you used Quick Select to define the data source, this might be the first time you have seen Visual SQL.)
Modify the SELECT statement graphically using the same techniques as when creating it.

For more information, see “Using SQL Select”.

Modifying the statement syntactically Select Design>Convert to Syntax from the menu bar to modify the SELECT statement syntactically.
Click the Return button to return to the editor.

Some changes you make (such as adding or removing columns) require Sybase WorkSpace to modify the update capabilities of the DataWindow object.

Changing the table If you change the table referenced in the SELECT statement, Sybase WorkSpace maintains the columns in the Design view (now from a different table) only if they match the data types and order of the columns in the original table.

Modifying the retrieval arguments

You can add, modify, or delete retrieval arguments when modifying your data source.

To modify the retrieval arguments:

In Visual SQL, select Design>Retrieval Arguments from the menu bar.

The Specify Retrieval Arguments dialog box displays, listing the existing arguments.
Add, modify, or delete the arguments.
Click OK.

You return to Visual SQL, or to the text window displaying the SELECT statement if you are modifying the SQL syntactically.
Reference any new arguments in the WHERE or HAVING clause of the SELECT statement.