Xu,
I wonder if you could change your Sql statement to use the in clause
So the string would be bt_no in( val1, val2, val,3 etc
I also think that even though you can get 32K in a string variable it can
only be appended to in 256 byte chunks. So just check that TS is not greater
than 256 after 35 additions to the string
Regards
Martin Hodder
Technical Manager
Dataview Solutions
[EMAIL PROTECTED]
+44 (0) 17 13 43 14 19
WARNING - THIS E-MAIL TRANSMISSION IS CONFIDENTIAL.
This e-mail transmission (including any accompanying attachments)
contains confidential information which is intended for the named
addressee only. If you are not the intended recipient, you are hereby
notified that any use, dissemination, distribution or reproduction of
this e-mail is prohibited. If you have received this e-mail in error please
contact us immediately at [EMAIL PROTECTED] Thank you.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of Xu Xiaoning
Sent: 20 October 1999 14:33
To: MapInfo
Subject: MI Expression too complex
Hello,All:
In delphi and MaoInfo Ole , I wrote this code:
//-------------------------code
..
ts := '';
for j := 0 to 34 do begin
if j<>34 then
ts := ts + 'bs_no = "'+slist.strings[j] + '" OR '
else
ts := ts + 'bs_no = "'+slist.strings[j] + '"';
end; // for
ts := 'Select * from CELL where '+ts;
MapInfo.Do(ts);
...
//-------------------------code
It runs Ok!
but when i change "34" --> "35"
it runs error , mapinfo show error message box " Expression too complex".
Why? How can i do?
Help me!
thanks!
Xu Xiaoning
[EMAIL PROTECTED]
[EMAIL PROTECTED]
ICQ:46904055
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
