Hi Steve
Thanks ever so much for the advice. I did as you said but it makes not
a blind bit of difference unfortunately. It still crashed on the:
...
Create Ranges
From csrThematicMap
With lcColAlias
Use "Equal Ranges"
Number 10
Into Variable aRangeLimits
...
With:
Dim lcMessage, lcAPFilePath, lcField, lcTabFile, lcDBFFile,
lcFileName,
lcColName, lcColCapt, lcSQLStr As String,
lcColAlias As Alias,
However, I got it to work thanks to your "Run Command" reminding me.
The col caption, for example, may be "UNDER TWENTY-FIVES" (in an age
group domain), to go with the field "Under25" say. So the space in the
caption, I assume, was cocking it up. So I coded (not using the alias
field) with quotes around the col alias (ensuring a pukka alias string):
lcSQLStr = "Select Zone, " + lcColName + " " + Chr$(34) +
lcColCapt + Chr$(34) +
" from " + lcFileName + " into csrTemp NoSelect"
Run Command lcSQLStr
which worked. Got past this then the Shade statement failed.
So I substituted lcFieldCapt for lcFieldAlias in the shade statement and
voila! Thematic map of user-selected column name from a user-selected
table name! :-)
Thanks again for the trouble you took. Again, it's the looking over the
shoulder that helps just as much as the advice received, eh?
My very best wishes
Terry
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 18560
