Visionary User's Guide Chapter 3: Creating Data Sources

Home

Contents

Index

Master Index

New Book

Modifying Data Sources You can modify data sources using the Query Diagram and SQL Text views in the Query Editor. The Query Diagram view provides those users who are unfamiliar with SQL with a graphic tool in which to modify data sources. If you are familiar with SQL, you might prefer to modify your data sources in the SQL Text view. However, if you modify an SQL statement in the SQL Text view, the Query Diagram view is no longer available and appears as a cross-hatched window. To modify a data source using the Query Diagram view 1. Click the Worlds tab and Data Sources button to display the Data Sources panel. 2. Navigate to the query you want to modify. 3. Double-click the query to display the Query Editor. 4. Click Query Diagram to display the Query Diagram view. 5. If you want to add additional query blocks, click the Data tab in the World Manager to display the Query Design panel. 6. Double-click the data and operation blocks you want to add to your query diagram to place them in the Query Editor. 7. Click the connection between the blocks and press DELETE to remove existing connections. 8. Click the Output port and the Input ports to connect the blocks. 9. Right-click each of the blocks and select Properties from the context menu to display a properties dialog box for each block. 10. Define the properties for each of the query blocks. 11. Click SQL Text to view the executed SQL query. 12. Click Data Sheet to view the results of your query. You can create or modify an SQL query using an editing tool, such as SQL Editor, and then copy and paste the query into the SQL Text view. To modify a data source using the SQL Text view 1. Click SQL Text in the Query Editor to display the SQL Text view. 2. Modify the query using standard Windows editing commands. 3. Click Data Sheet to execute the query and display results. Tip: The SQL Text view supports multiple SELECT statements. When multiple SQL statements are executed, Visionary uses the last SELECT statement for the data source result set.