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
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
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
3 matches
Mail list logo