Displaying the underlying SQL statement

As you specify the data for the DataWindow object in Visual SQL, Sybase WorkSpace generates a SQL SELECT statement. It is this SQL statement that will be sent to the DBMS when you retrieve data into the DataWindow object. You can look at the SQL as it is being generated while you continue defining the data for the DataWindow object.

To display the SQL statement:

Click the Preview tab to make the Preview view available, or select View>Preview if the Preview view is not currently displayed.

You may need to use the scroll bar to see all parts of the SQL SELECT statement. This statement is updated each time you make a change.

Editing the SELECT statement syntactically

Instead of modifying the data source graphically, you can directly edit the SELECT statement in Visual SQL.

Converting from syntax to graphics With some statements, it may not be possible to convert the syntax back to graphics mode. In general, once you convert the SQL statement to syntax, you should maintain it in syntax mode.

To edit the SELECT statement:

Select Design>Convert to Syntax from the menu bar.

Sybase WorkSpace displays the SELECT statement in a text window.
Edit the SELECT statement.
Do one of the following:
- Select Design>Convert to Graphics from the menu bar to return to Visual SQL.
- Click OK to return to the wizard if you are building a new DataWindow object, or to the DataWindow editor if you are modifying an existing DataWindow object.