Re: URGENT : TABLE Space settings and T Table behavior on form modification

2010-10-21 Thread LJ LongWing
Manish, I agree with Mattbut my remembrance of the process is that T123 becomes T123A, Remedy creates T123B, copies the data into B, and then renames T123B to T123 when complete. This only occurs when it can't modify the table in place and needs to create a new one...as outline by Matt, this

Re: URGENT : TABLE Space settings and T Table behavior on form modification

2010-10-20 Thread Joe D'Souza
Manish, To answer question 1, creation of A tables is normal. The AR System doesn't do an alter table.. It creates a duplicate A table, copies information from T to A, drops T, recreates T with the new structures, and then copies info from A to T and then drops A.. This has been the design since

Re: URGENT : TABLE Space settings and T Table behavior on form modification

2010-10-20 Thread patchsk
Manish, As Joe mentioned now with 7.5 it directly alters the table when a field is deleted from a form instead of creating a A table etc.. Ex:ALTER TABLE Txyz DROP COLUMN Cxx Earlier versions it used to take a long time to delete fields form a form having huge amount of rows i.e, because it