Just to add another approach, though I am please to know about the find statement in the workspace method, and find it more elegant than what I am about to say.
The Find command defaults to the first table with an indexed column in the Open table section of the workspace and it must also be in the Map From section as well, and the column to search defaults to the first indexed column in the table structure. To default to a particular table and column, set it up this way, open the workspace in notepad or other editor, (change *.TXT to *.WOR) and cut and paste the desired table as first in the Open Table section of the workspace, Save the file and close it. Open the workspace in MapInfo and bring the desired column up to the top through Table>Maintaince, highlight column , and use the "Up" button to bring it to the top. After doing this, add the table in layer control if it is not there, then save the workspace inside of MI. I discovered all this when trying to make a workspace opened in ProViewer to behave in a particular way for Find. And by the way, if you are trying to search on a particular field and it does not come up in the specify column, chances are good it needs to be indexed. William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Nick Hall [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 04:39 To: Adam Staunton; [EMAIL PROTECTED] Subject: RE: MI-L Query|Find - Getting the "Search Table" and "Column" to default to another table/column Adam, you could try adding the following line to your workspace find using mytable(column_name) options symbol makesymbol(48,16711680,24) which should then default the Find command to use the column called column name in the table called mytable and you get to pick a nice symbol too!!! HTH Nick -----Original Message----- From: Adam Staunton [mailto:[EMAIL PROTECTED] Sent: 16 October 2003 23:00 To: [EMAIL PROTECTED] Subject: MI-L Query|Find - Getting the "Search Table" and "Column" to default to another table/column Hi all, New here, and am not sure how to get the "Search Table" and "Column" to default to another table/column when using QUERY/FIND on a workspace with a heap of tables in it. The user is having to manually choose the table and column each time. any ideas ? cheers, Adam ************************************************************************** This message is intended only for the use of the addressee(s) named above and may contain confidential and/or privileged information. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action based upon it. Please delete and destroy the message from your computer. If you received this message in error please notify the Laidley Shire Council immediately. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Laidley Shire Council. Except as required by law the Laidley Shire Council does not represent, warrant or guarantee that integrity of this communication has been maintained nor that this communication is free of any error, virus, interception or interference. ************************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8764 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8772 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8784
