Str$(obj) = "text" is much simpler -----Original Message----- From: Driver, Greg 9434 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 26 June 2002 4:55 PM To: 'Andrew Tracey'; '[EMAIL PROTECTED]' Subject: RE: MI-L SQL Query
Andrew, >From the Query, SQL Select option type: Select Columns: * from Tables: your_table_name Where: str$(objectinfo(obj,1)) = "n" with n representing one of the following numbers: 1 - arc 2 - ellipse/circle 3 - line 4 - polyline 5 - point 6 - layout window frame 7 - region 8 - rectangle 9 - rounded rect 10 - text so if you wanted all lines then n=3 HTH Greg > -----Original Message----- > From: Andrew Tracey [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, June 26, 2002 09:01 > To: '[EMAIL PROTECTED]' > Subject: MI-L SQL Query > > Dear All > > I have a table which consists of Line, Point and Text data. I need a SQL > query that will enable me to pick out either all Text items or all Line > items etc. Is this possible to do and does anybody know how ? > > Thanks in advance > > Andrew Tracey > Development Services Department > South Tyneside M.B.C. > Town Hall > Westoe Road > South Shields > Tyne & Wear > NE33 2RL > > 0191-4271717 Ext. 7561 > E-Mail : [EMAIL PROTECTED] > > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > your system manager. > > South Tyneside Metropolitan Borough Council > www.s-tyneside-mbc.gov.uk > ********************************************************************** > stmbc-ms-disclaim > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
