This file contains context-sensitive topics for the Microsoft Visual Database Tools. For information about the Database tools, press F1 from the Data View tab.


Data View Tab in the Options Dialog Box

Enables you to set options for queries and stored procedures for Microsoft® SQL Server™ and Oracle databases. This dialog box appears when you choose Options from the Tools menu. In the resulting dialog box, choose the Data View tab to set the options described below.

Dialog Box Options

Limit SQL output

If checked, this option limits the number of lines of data visible in the Output window when you run a stored procedure. If you check this option, type the maximum number of lines you want to be able to see in the Output window.

SQL Query Time-out

The number of seconds allowed for the execution of a query before the query times out. The default is 30 seconds. You can type a different number to change this limit.

SQL Login Time-out

The number of seconds that elapse before an attempt to log in to a SQL Server database times out. The default is 15 seconds. You can type a different number to change this limit.

View System Objects

If this option is checked, Data View displays system objects that are created for your database. For example, the sysproperties table, a system table created by Microsoft SQL Server to store the properties for a SQL Server database, appears when this option is checked.

SQL Server Debugging

If checked, this option enables the Microsoft SQL Server debugger for stored procedures. This feature is available in Microsoft® Visual C++® 5.0 Enterprise Edition only.

Verbose SQL output

If checked, this option causes all the output from the Microsoft SQL Server driver to be displayed in the Debug tab of the Output window during debugging of stored procedures. This feature is available in Microsoft Visual C++ 5.0 Enterprise Edition only.

OK

Accepts your settings.

Cancel

Ignores any changes you made to the existing settings and closes this dialog box.


Insert Database Item Dialog Box

Enables you to select a database item that will be inserted into the current database or database project. This dialog box appears when you choose New Database Item from the Insert menu.

Dialog Box Options

Database Item

Lists the types of items available in the database you are connected to. Select the database item you want to insert:

Database Item	Microsoft®  SQL Server™ 6.5	Microsoft  SQL Server 6.0	Oracle 7.x	All Others
Table	available	not available	not available	not available
Database Diagram	available	not available	not available	not available
Query	project dependent	project dependent	project dependent	project dependent
Stored Procedure	available	available	available	not available
Trigger	available	available	available	not available
Database

Lists the databases you are connected to for this project. Select the database that you want to insert the database item into.

OK

Creates the database item you selected in the appropriate editor.

Cancel

Cancels the action.

Help

Opens the Help topic for this dialog box.


Rename Dialog Box

Enables you to change the name of a database diagram or stored procedure in Data View. Appears when you right-click a database diagram or stored procedure in Data View and choose Rename from the shortcut menu.

Dialog Box Options

Enter a name

Shows the existing name of the database diagram or stored procedure. Type your new name in this box.

OK

Renames the object in Data View.

Cancel

Cancels this action.

The database diagram or stored procedure is renamed in the database when you save the table, the database diagram, or your database project.


Run Stored Procedure Dialog Box

Displays the parameters in the selected stored procedure and enables you to run the stored procedure against your Microsoft® SQL Server™ database. This dialog box appears when you right-click a stored procedure name in Data View and choose Run from the shortcut menu.

Dialog Box Options

TYPE

Shows the data type for the parameter displayed in the NAME cell.

NAME

Shows the parameter name.

VALUE

Shows the value for the parameter that will be used in the stored procedure. To change this value, click inside this cell and type a new value.

OK

Accepts your settings and runs the stored procedure.

Cancel

Cancels the action.

Help

Opens the Help topic for this dialog box.


Save As Dialog Box

Enables you to save the current database diagram under a new name. Appears when a database diagram is open and you choose Save As from the File menu.

Dialog Box Options

Save this database diagram as

Shows the existing name of the database diagram. Type a new name in this box.

OK

Creates a copy of the database diagram with the new name in Data View and updates the dtproperties table in your database with the new diagram name.

Cancel

Cancels the action.

Note Specifying a name in this dialog box does not rename the existing database diagram; it creates a new copy of the diagram with the name you specify. To rename the diagram, right-click the diagram in Data View and choose Rename from the shortcut menu.


Server Error(s) Dialog Box

Appears when errors have been encountered while you were trying to run a stored procedure. This dialog box lists each error from your database server that prevented the stored procedure from running successfully.

Dialog Box Options

OK

Returns to the stored procedure.

Show Warnings

Shows the ODBC warnings that occurred when you attempted to run your stored procedure. ODBC warnings codes are five digits in length and begin with 01.

The Show Warnings option is checked by default. You can clear this setting to hide warning messages when you run stored procedures.


Create New Extended Stored Procedure Dialog Box

Use this dialog to register an extended stored procedure and have it appear in the Extended Stored Procedure folder. You can create an extended stored procedure by using the Visual C++ Extended Stored Procedure Wizard.

Procedure
Specify the name of the Win32 exported function (the name of the extended stored procedure on the server).

DLL Name
Specify the name of the .dll in which the extended stored resides.


Data View Tab

Data View provides a graphical environment for creating, viewing, and editing the database objects that reside on a remote database server. Data View is your starting point for managing your database objects, such as database diagrams, tables, triggers, views, and stored procedures.

Each connection to your database is represented by a data connection icon [image]. Within a data connection, Data View displays the following types of files in separate folders:

Icon	Folder	Comments
	Database Diagrams
	Table	Within a table, you can also see a list of its columns [image] and triggers [image].
	View	Within a view, you can see a list of its columns [image].
	Stored Procedures	Within a stored procedure, you can see a list of its parameters [image]. If a stored procedure returns columns, you can also see a list of those columns [image].
Data View is visible when a data connection has been established for your database project or web project.

For more information about the database objects you can manage in Data View, refer to the MSDN library topic, “Microsoft Visual Database Tools Overview.” For information about objects that are represented in Data View when you’re connected to an Oracle database, see the topic “Working with Oracle Databases.”


Column Property Page

This property page contains a set of properties for the column selected in Data View.

Name

Shows the name of the column.

DataType

Shows the data type of the column.

Length

Shows the column length.

Precision

Shows the column precision, that is, the number of digits that appear to the right of the decimal point.

To change any of these options, open the table in design mode by right-clicking the table name and choosing Design from the shortcut menu.


Database Object Property Page

This property page contains a set of properties for the database object selected in Data View. Database objects that use this property page include:

•	Database Diagrams

•	Stored Procedures

•	Tables

•	Triggers

•	Views

The following information appears in this property page:

Name

Shows the name of the database object.

Type

Shows the type of database object: Database Diagram, Stored Procedure, Table, Trigger, or View.

Owner

Shows the database User ID of the individual who owns this database object. A database object owner is the individual who created that object.


Data Connection Property Page

This property page contains a set of properties for the data connection selected in Data View or FileView.

Type

Shows the type of database you’re connected to.

Data Source

Shows the name of the data connection.

Server

Shows the name of the server where the database resides.

Database

Shows the name of the database you’re connected to.

User

Shows the User ID you used to log in to the database.

Login

Shows the Login ID you used to log in to the database.


Parameter Property Page

This property page contains a set of properties for the parameter selected in Data View. Parameters are listed under a stored procedure in the Stored Procedures folder.

Name

Shows the name of the parameter.

Data Type

Shows the data type of the parameter.

Type

Shows the ODBC data type of the parameter.


File Property Page

Displays properties for the file selected in FileView — either a project (a .dsp file) or a file you saved earlier (such as a query file).

If you have displayed properties for a project, the dialog box is named Project Properties and contains a tab named Database Project. If you have displayed properties for a file, the dialog box is named FileView Properties and contains a tab named File.

The property page contains the following information:

File Path

Shows the location of the file on your local computer. Three dots (…) are used to indicate the default project path.

Last Modified Time The date and time at which the file was last written to disk.


Extended Stored Procedure Properties Page

Name
Name of the extended stored procedure (a Win32 function exported from a .dll).

Type
The Microsoft® SQL Server™ object type.

Owner
ID of the user who created the extended stored procedure object.

DLL Name
The name of the .dll in which the extended stored resides.