RE: MI MB: Run Command Limitation

[Warren Vick, Europa Technologies Ltd.]

Hello Jacques,

Interestingly, your program stops at 309 on Pro v4.5, suggesting that the
limit was raised in latter versions. The limit has never caused me much of a
problem. Most tasks can be broken down or redesigned to accommodate the
restriction.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques Paris
> Sent: Thursday, September 21, 2000 4:18 PM
> 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]