length of concat string

Is there a max length for a concat string ?

I get an invalid substring reference for the following:

q.sql = [Select concat(t1.THANK_YOU) as "Attended Carol Stream Open
House" 
from contact t1]
q.requestLive = false
q.active = true
q.rowset.first()

?q.rowset.fields["Attended Carol Stream Open House"].value

However just by dropping the "e" in the string it returns the value.
That's 
31 instead of 32 characters.

Just curious on this one.

Claus

Lysander wrote:
> Claus Mygind schrieb:
>> However just by dropping the "e" in the string it returns the
value. 
>> That's 31 instead of 32 characters.
>>
>> Just curious on this one.
> 
> Is it possible that the field lenghth of dBase-queries is limited to 31?
> 
> And WHY would you want to have such a field name???
> Maybe there is another way to achieve what you are trying to do?

Sounds like the normal internal limit in dBASE/BDE. I have a feeling 
this is a BDE limitation ... although I seem to recall that dBASE 
doesn't deal with variables longer than 31 characters either (it uses 
'em, but they aren't unique). Same for property names for custom 
properties of controls ...

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

Just to be descriptive.  This is part of an app where I export the data into 
an excel spreadsheet dirctly from my .html page.

Thanks for the reply.
Claus

"Lysander" <nobody@nowhere.de> wrote in message 
news:dwcpwilcIHA.1188@news-server...
> Claus Mygind schrieb:
>> However just by dropping the "e" in the string it returns the
value. 
>> That's 31 instead of 32 characters.
>>
>> Just curious on this one.
>
> Is it possible that the field lenghth of dBase-queries is limited to 31?
>
> And WHY would you want to have such a field name???
> Maybe there is another way to achieve what you are trying to do? 

Claus Mygind schrieb:
> However just by dropping the "e" in the string it returns the
value. That's 
> 31 instead of 32 characters.
> 
> Just curious on this one.

Is it possible that the field lenghth of dBase-queries is limited to 31?

And WHY would you want to have such a field name???

Thanks for the confirmation.  Now I know and will stay within the limits.

"Ken Mayer [dBVIPS]" <dbase@_nospam_goldenstag.net> wrote in
message 
news:wDTxL0mcIHA.1748@news-server...
> Lysander wrote:
>> Claus Mygind schrieb:
>>> However just by dropping the "e" in the string it returns
the value. 
>>> That's 31 instead of 32 characters.
>>>
>>> Just curious on this one.
>>
>> Is it possible that the field lenghth of dBase-queries is limited to
31?
>>
>> And WHY would you want to have such a field name???
>> Maybe there is another way to achieve what you are trying to do?
>
> Sounds like the normal internal limit in dBASE/BDE. I have a feeling this 
> is a BDE limitation ... although I seem to recall that dBASE doesn't deal 
> with variables longer than 31 characters either (it uses 'em, but they 
> aren't unique). Same for property names for custom properties of controls 
> ...
>
> Ken
>
> -- 
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase/dBASEBooks.htm
> http://www.goldenstag.net/dbase