InfoQube IM - Community

Submitted by Alp on 2020/06/17 10:59

Hi,

While I was rebuilding my database, I managed to copy all fields of a grid from one file to another except an ID field, which in the original was set as text field and in the new file as number field. I need this field to be a number field since sometimes I'd like to sort data on this field. Because xml copying gave me empty cells in that field, I set destination field type as text. This time, as expected, it worked fine. But data was lost when I changed field name in the destination file, like from 'CustomerID' to 'ID'.

The strange thing is that copying was successful for another field with text in the original and number in the destination. The only difference between the failed one and the successful one seems to be that the former is 5 or 6 character long while the latter is only single character long.

Thanks,

Alp

Version 0.9.115g build 6/11/2020

Comments

Update

I entered data manually under the new 'ID' column whose type is number, closed file, reopened, and the whole data is gone in this field.

Alp

I would ask Pierre to confirm or deny this but I think 'id' is a system field which is automatically assigned to each item in the database. Having another 'id' field might confuse the database. If this is the case then using a different name would be the answer.

Thank you, Paul. Indeed, it looks like that way. When I gave it a different name, SysID, data remained intact.

Alp