Hi Sheila,
Does this really work ?? I thought I had tested this as well and got an error on this as well. testing testing ... You are right ! Appearently there has been a change here, that I wasn't aware of. Maybe the limit I found was connected to the GUI/dialog or maybe it was connected to the WHERE clause. I stand corrected: Using the MapBasic window solved the problem ! Thanks Sheila, 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. ------------------------------------------------------------------------------------------------ Klik ind p� http://www.kortal.dk og se det hele lidt fra oven! "Quan, Sheila" Til: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> <S.Quan@sdgwo cc: rld.net> Vedr.: RE: MI-L Limit of Select Statements?? 18-01-02 12:07 Hi Peter There is a workaround this problem by using the "Show Mapbasic Window" and typing your SQL select statement there which does exceed 255 characters. Highlight the entire query and press Enter. MapBasic will then execute your query and return a selection file. I have tried this in the past and it appears to work. Fingers crossed! Sheila Quan Steer Davies Gleave 28-32 Upper Ground, London SE1 9PD > [direct] +44 (0)20 7919 8509 > [reception] +44 (0)20 7919 8500 > [fax] +44 (0)20 7827 9851 > [email] [EMAIL PROTECTED] > www.steerdaviesgleave.com This message is sent in confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 18 January 2002 10:07 To: [EMAIL PROTECTED] Subject: RE: MI-L Limit of Select Statements?? Hi Anitra, Yep, there is a limit in the SQL select statement: max length is 255 characters. I can't see any way around this other than letting the ODBC/OCI driver perform the select. Could you in the select statement send to the Oracle database enter the preferred select, or is this what you allready do ? I have made this limit clear to MapInfo Corp. a year or 2 ago, but appearently there are more important things. 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. ---------------------------------------------------------------------------- -------------------- Klik ind p� http://www.kortal.dk og se det hele lidt fra oven! Anitra Robertson <[EMAIL PROTECTED] Til: MapInfo Users <[EMAIL PROTECTED]> u> cc: Sendt af: Vedr.: MI-L Limit of Select Statements?? [EMAIL PROTECTED] onsmag.com 18-01-02 07:37 Besvar venligst til Anitra Robertson Hi, This may be really obvious to you all (I feel as though I am in remedial corner!!!:-)) Can anyone tell me if there is a limit on the size of a Select Statement in MapBasic?? More detail: I am selecting a table from an Oracle 8i database and whilst I want ALL of the columns, some of them require aliases. My select works when I pull out about 10 columns (plus some aliases), but not when I pull out all the columns (approx 40). (P.s It works if I do Select *). Can anyone offer any suggestions as to how I can get this to work? TIA, -- Anitra Robertson GIS Analyst Tattersall's (Gaming and Lotteries) Melbourne, Australia CONFIDENTIALITY NOTE: This e-mail is intended only for the use of the individual or entity named above and may contain information that is confidential and privileged. If you are not the intended recipient, you are hereby notified that any distribution, copying or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error or are not the named recipient, please notify us immediately by return e-mail <[EMAIL PROTECTED]> or telephone 613-8517-7405 and destroy the original message. Thank you. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
