>>Note that if you use long field names in a database table, and SQL select from that table, into free table or cursor,m then the long field names woill be truncated to 10 chars in the result.
>
>Terry,
>When selecting to cursor (I never select into table, thats why I don't know if this is true) Long field names are preserved
>Try this:
>
>CLOSE DATABASES ALL
>CREATE DATABASE TestData
>SET DATABASE TO TestData
>CREATE TABLE Test (VeryLongNameOverTenChars C(10))
>INSERT INTO Test VALUES ("AAAAA")
>CLOSE DATABASES ALL
>SELECT * FROM Test INTO CURSOR cTest
>BROW
>BB
Granted it's OK for a cursor, I don't need to run your test as I have enough of my own to test it on. But a result table, unless explicitly attached to a database, has the field names truncated.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
