When is data at risk of Restructure?

[stanlyn]

Hi,

When restructuring a table is there any situations where I could lose data by:

1. changing the name of a field,

2. changing the type of a field, (I know the basic stuff like changing a char to an int or numeric would lose data, however please list the not so obvious ways data lose can occur.)

3. any other way that I don't know to ask?

Thanks, Stanley

 

[kermit01de]

Hi Stanley,

Just about restructuring a table - you have to care for references in queries etc.

1. no
2. as you mentioned ...
3. yes ... generally eg. if you change date into text, you may not loose data, but it will be another format displayed. If you change length of a text field from 255 to 20 ... it will loose the data ... from 21 to 255




Kind regards
Mirko
--------------------------------------
>>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<