Download User`s Guide
Transcript
SQL Data Manager Tasks Note that you must use the pound sign as the statement delimiter in Query Pane if you create stored procedures. Stored procedures use the semicolon as a statement delimiter within the procedure itself. b. Click File New SQL Query or click . If Query Pane contains statements that have not been saved, you are prompted to save them. Click Yes to save the existing statements, specify a file name and location, then click Save. Click No to discard the existing statements. Any SQL statements in Query Pane are cleared and the statement indicator is positioned at the top left of the pane. The indicator is the yellow arrow . c. Use Query Builder to build a statement. See “Query Builder Tasks” on page 6-41. If execution stops because of an error, the statement indicator positions to the statement that was being run when the interruption occurred. Also, the Text Results tab lists the statement that was last run. Knowing the last statement run can help you troubleshoot the problem. See “To continue running SQL statements that were stopped” on page 6-57. ³ To close a database 1 Click File Close Database. 2 Click Yes to confirm that you want to close the database. Note that the title bar no longer shows the name of an open database or the name of a machine on which the database resides. In addition, the commands and icons for running a query become inactive (grayed out). You can run a query only if a database is open. ³ To change data with Grid Results grid The Grid Results grid must be active before you can change values in cells. See “To set Grid Results to allow changes to database data” on page 6-58. 6-45
Related documents
Pervasive.SQL User`s Guide
User's Guide
PDF manual - Ocean Drilling Program
Pervasive.SQL V8 User's Guide
Especificações e Características de Motor
Pervasive.SQL User's Guide Server Edition
The Smalltalk Environment, August 1981, BYTE Magazine
SC-PT650 - Support
F.A.S.T. User Manual - Welcome to the Official Website of
User's Guide
Garmin VHF 725 User's Manual
Table Of Contents System Manager i Introduction 1 Welc