>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.