There certainly used to be a length limit for the select statement used by
ODBC too.
---------------------------------------------
David Booth
Senior GIS Officer
Merseyside Information Service
> -----Original Message-----
> From: Jacques Paris [SMTP:[EMAIL PROTECTED]]
> Sent: 21 September 2000 16:18
> To: Mike Taylor; 'Mapinfo List'
> Subject: RE: MI MB: Run Command Limitation
>
> I have written the most sophisticated program of all :
>
> dim a,b as string
> onerror goto crash
> a=""
> boucle:
> a=a+"A"
> b="print "+""""+a+""""
> print len(b)
> run command b
> goto boucle
> goto fin
> crash:
> print "error "+err()
> fin:
> end program
>
> and it gets stuck on a command at 508 characters (error 965, expression
> too
> complex). The run command accepts thus a string of 507characters. That
> would
> be 512 - 5 (let us assume that it is some code id).
>
> Aren't they other places in MI where the 512 character limit is imposed?
> Don't I remember something of the sort with the "where" clause of the SQL
> requester?
>
>
> Jacques PARIS
>
> e-mail [EMAIL PROTECTED]
> For MapInfo support, see the Paris PC Consult enr. site at
> http://www.total.net/~rparis/gisproducts.htm
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mike Taylor
> Sent: September 21, 2000 1:04 AM
> To: 'Mapinfo List'
> Subject: RE: MI MB: Run Command Limitation
>
> Hi again
>
> Seems I spat the dummy at the wrong statement.
> I changed the string (from select to print) that I was sending to run
> command. eg,
> From:
> qs = "select ... <lots of stuff> ... from table into anothertable"
> run command qs
> To:
> qs = "print ""select ... <lots of stuff> ... from table into
> anothertable"""
> run command qs
>
> This worked fine, so I will change my question to why is this happening
> with
> select??
> The amount of characters seems to be variable as well depending on the
> expression?
> I've attached a program which will generate the problem on my machine.
>
>
> -----Original Message-----
> From: Mike Taylor [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 21 September 2000 15:20
> To: 'Mapinfo List'
> Subject: MI MB: Run Command Limitation
>
>
> Hi
>
> I seem to have run into a size limitation on the string you can pass to
> run
> command. It works when I trim the string down to 421 characters and fails
> (badly, invalid page fault) when it is 422 characters.
> The command also fails when I put it into the mapbasic window of
> professional.
> Is there any workaround for this?
> Why is 422 the magic number?
> ----------------------------------------------------------------------
> 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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
