| Support |
| Site Admin |
|
| |
| Joined: 12 Mar 2004 |
| Posts: 370 |
| Location: Omaha, NE |
|
|
|
 |
|
 |
|
Q: When creating a SQL script via the SQL Editor, is there any way to display and select the files and fields other than the SQL Wizard?
A: You do need to enter the name of the file in your statement. If you don't have the library in your SQL library list, then you need to qualify it with both the library and file name (ie:surveyor.demo). Once you've typed in a statement, if you want to insert fields into the statement you need do the following:
1) Click with your left mouse button anywhere in the name of the file or library. For example, if your statement was 'Select * from surveyor.demo' then you would click anywhere in 'surveyor.demo'.
2) Either press the F4 key on your keyboard or select from the Edit menu Column Lookup. The list of fields for this file will be displayed in a popup window.
3) Put your cursor in the statement where you want to enter the fields. For example, you may want to replace the '*' with certain fields in the file. You would delete the '*' and leave your cursor in that spot. |
|
