I think the whole expression has to be less than 256, but I can't remember.
The obvious suggestion is to break your SQL statement into sections or
abbreviate.
ex:
SELECT one.NGS_id INTO two
FROM one
WHERE (((one.NGS_id)>"1"));
SELECT two.NGS_id INTO three
FROM two
WHERE (((two.NGS_id)<"2"));
or something.
and:
Use left$(column,3)="Bus"
instead of:
column="Bush will be our next president, but we all have to wait for ten
days if not more to find out"
But you probably knew all that already.
Also, leave the mapbasic window open, that can help automate the dissection
of a where clause.
Charles K. Huyck
ImageCat, Inc
http://ImageCatInc.com
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 08, 2000 3:21 PM
Subject: MI-L SQL Question
> Greetings,
>
> Does anyone know of the limitation of the SQL Select Columns and Where
> Condition boxes?
>
> I seem to be only allowed a limited number of entries. I thought at first
> it was a 256 character issue, but I not even allowed that many.
>
> Any thoughts or suggestions.
>
> TIA
>
> Peter
>
> ___________________________
> Peter McPherson
> GIS Technician
> Cameco Corporation
> 2121 11th Street West
> Saskatoon, Saskatchewan
> S7M 1J3
> Canada
>
> Telephone (306) 956 6433
> Fax (306) 956 6390
>
>
>
>
> _______________________________________________________________________
> 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.
