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.

Reply via email to