Do remember to set the right projection before selecting the records with SQL:
1. Open the MapBasic window 2. Enter this followed by a Enter: Set CoordSys Table <name of table> <name of table> is the name of your table with the correct projection 3. Do the SQL select. HTH, Peter ------------------------------------------------------------------------------------------------ Peter Horsb�ll M�ller, GIS Udviklingskonsulent / GIS-Developer Kampsax A/S - GIS Software & Solutions Rugaardsvej 55, 5000 Odense, DK tel: +45 6313 5013, dir:+45 6313 5008, fax: +45 6313 5090 mailto:[EMAIL PROTECTED] www.kampsax-gis.dk and www.kampsax.dk Authorized MapInfo Partner & Distributor in Denmark and Norway. ------------------------------------------------------------------------------------------------ Se mere om Dansk MapInfo Brugerkonference p� http://www.kampsax-gis.dk/Default.asp?ID=296 Klik ind p� http://www.kortal.dk og se det hele lidt fra oven! Check http://www.kortal.dk and have a look at Denmark from above! ----- Videresendt af Peter M�ller/Kampsax - 01-08-2002 08:52 ----- Andrew Tracey <andrew.tracey@s-tyneside-m Til: [EMAIL PROTECTED] bc.gov.uk> cc: Vedr.: MI-L SQL 31-07-2002 17:49 Dear All I am producing a query that will give me all of the eastings and northings for the points within a table. I can't get the results to show in metres, I only get them in degrees, does anyone have any ideas. Thanks 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] <mailto:[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] Message number: 2291 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2306
