>>Hi all!
>>
>>was wondering if anyone can tell me what might have happened to truncate some field names in one of my tables. I believe these names were >10 chars and worked fine for awhile, but somehow they got truncated back to 10 chars, which of course messed up a few reports, etc. I do remember 'modifying' the table once or twice, but would this cause it? Or maybe it was deleteing and then re-adding the table....
>>
>>TIA,
>>Dan
>
>
>
>I got same problem as in table designer, it allow 11 character but when I:
>
>Select * from table1 group by key1 into table2
>
>the longer fieldname is truncated!!
>
>what should be done is to change all fields, program... to fit in 10 character!
>
>Anyway, truncate fieldname is not important, lose a column data is
important!>
>Then, you're better to:
>
>use table1 excl
>Alter table1 rename column longfield1 to shortfld1
>use in table1
Hi Justok,
CCing to me asking my idea about SQL ? SQL select would truncate it because it's creating a free table. If you want to do SQL + preserve longfieldnames then change your SQL syntax to create a view :
create sql view mynewview as ;
select ...
I wouldn't create a table but a view for something I could SQL select. Still if you need a table, you have afileds(), create, alter, drop etc series of handy commands :)
Cetin