All of the fields in the 'SQL Select' dialog box have a limit of 256
characters that can be entered into the box.
I have a query that has 233 characters in the 'Select Columns' portion
and it executes correctly. However when I save the query (Save
Template) and reload it, it fails to execute.
The reason for this is that MapInfo inserts numerous spaces into the
string, causing it to exceed the 256 character limit.
For example, my original query was ...
RDSEGDAT.Road_name, RDSEGDAT.Rd_segmtno,
ProspectFootpaths_2002.Side, RDSEGDAT.from, RDSEGDAT.to,.....
But after saving it and reloading the following is displayed...
RDSEGDAT . Road_name , RDSEGDAT . Rd_segmtno ,
ProspectFootpaths_2002 . Side , RDSEGDAT . from , RDSEGDAT . to ,.....
MapInfo has inserted a space before every comma and before and after
every dot, making this SQL useless.
My questions are (particulary to MapInfo) why is there a 256 character
limit on these fields and why are the unnecessary spaces added?
Is there any fix to this?
Thanks,
Chris
CHRISTOPHER PRESCOTT
GIS Specialist
TONKIN CONSULTING
5 Cooke Terrace
Wayville SA 5034
T +61 8 8273 3100
F +61 8 8273 3110
E [EMAIL PROTECTED]
PRIVACY & CONFIDENTIALITY NOTICE
This e-mail and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom it is
addressed. This communication may contain material which is legally
privileged and any misuse of this e-mail and any file attachments is
strictly prohibited. If you have received this e-mail in error, please
delete it and any attachments immediately and notify the first sender by
e-mail or by telephoning +61 8 8273 3100.
You may rely on documents and drawings received by e-mail when confirmed
by a signed Tonkin Consulting hardcopy.
Whilst we have used appropriate software to alert us to the presence of
computer viruses, we cannot guarantee that this e-mail and any files
transmitted with it are free from them.
