|
QueryODBC > Command Tab Options
Fields
Analyze SQL Code
Turn SQL code analysis on (checked) or off (unchecked). While SQL code analysis is on, all SQL code in the command text field is analyzed for keywords, comments and character strings.
Code Type List
Lists each type of SQL code that is highlighted during SQL code analysis. When you select a code type, the text in the sample text field is highlighted using the currently assigned color. To change the highlight color, use the change color button.
Sample Text
Shows a sample of the highlight color for the currently selected item in the code type list.
Keyword File
Enter the path and file name of the keyword file, or use browse to select a file. Keyword files should contain a list of keywords delimited by a carriage return (one keyword per line). You can edit the keyword file provided with QueryODBC, or create your own keyword files. QueryODBC will automatically highlight and change the capitalization of words entered in the command text field if the word is contained in the keyword file.
Keyword Cap
Select the desired capitalization option for keywords. If you select "None," the capitalization of keywords will remain exactly as originally entered in the command text field. If you select an option other than none, QueryODBC will automatically change the capitalization of keywords you enter in the command text field.
Auto Commit
Specify the desired auto commit setting. (see Rollback/Commit Changes in the topic command tab).
After Each Query
Select this option to automatically commit changes (transactions) after each query. If you
select this option, you will not be able to rollback changes since all changes will be
committed automatically.
On Exit/Disconnect
Select this option to automatically commit changes (transactions) when you close
QueryODBC, or login to a new database. While using
this option, you can execute a ROLLBACK statement in the command
tab to reverse any non-committed changes. You can also manually execute a COMMIT
statement in the command tab to commit any
non-committed changes.
On Manual Commit Only
Select this option to disable auto commit. While using this option, you can execute a
ROLLBACK statement in the command tab to
reverse any non-committed changes (transactions). You can also manually execute a COMMIT
statement in the command tab to commit any
non-committed changes.
Caution:
If you select this option and quit QueryODBC or login to a new database without issuing a COMMIT
statement, your non-committed changes will be rolled back.
Read Characters
Specify the number of characters to read and sent as a single SQL command when
reading SQL script files. The maximum number of characters that may be sent as a
single command is 1.5 billion.
Tip: Changing this value can significantly affect the speed at which certain SQL scripts are processed. For example, in testing the read function with an SQL script containing 7,000 insert statements, reading 50,000 characters at a time was ten times faster than reading 400,000 characters at a time.
Tip: If you are debugging an SQL script that contains a syntax error, set the read characters low and use the line numbers provided in the statistics tab to locate the problem command. Note, some SQL scripts must be sent as a single command -- this technique cannot be used with these types of scripts.
Buttons
Change Color
Change the highlight color for the currently selected item in the code type list.
Browse
Select a keyword file using the keyword file selection dialog. Use this button as an alternative to typing the keyword file name and path in the keyword file editbox.
OK
Save current options settings (all tabs) and close options dialog.
Cancel
Close options dialog without saving changes to options.
Help
Displays this topic.
| 
