Register FAQ Memberlist Search Linoma Software Forum Index

Linoma Software Forum Index -> Surveyor/400 -> Can I select files or fields without using the SQL Wizard?
This forum is locked: you cannot post, reply to, or edit topics.  This topic is locked: you cannot edit posts or make replies. View previous topic :: View next topic 
Can I select files or fields without using the SQL Wizard?
PostPosted: 09/12/05 12:43:47 PM Reply with quote
Support
Site Admin
 
Joined: 12 Mar 2004
Posts: 376
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.
View user's profile Send private message Send e-mail Visit poster's website
Can I select files or fields without using the SQL Wizard?
  Linoma Software Forum Index -> Surveyor/400
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 6 Hours  
Page 1 of 1  

  
  
 This forum is locked: you cannot post, reply to, or edit topics.  This topic is locked: you cannot edit posts or make replies.  



Powered by phpBB 2.0.6 © 2001-2003 phpBB Group Style created by Vjacheslav Trushkin