Hi,



I needed to add more space into an already present varchar field.



alter table patient_triage_cons

add tmpACTIONTYPE VARCHAR(10),

add tmpACTIONNOTES VARCHAR(8192)



---



update patient_triage_cons set tmpACTIONTYPE = ACTION_TYPE,
tmpACTIONNOTES = ACTION_NOTES



---



alter table patient_triage_cons

drop ACTION_TYPE,

drop ACTION_NOTES



---



alter table patient_triage_cons

add ACTION_TYPE VARCHAR(10),

add ACTION_NOTES VARCHAR(8192)



---



update patient_triage_cons set ACTION_TYPE = tmpACTIONTYPE, ACTION_NOTES
= tmpACTIONNOTES





The above red line (or last line of script if this message does not show
in colour ) is where it fails. The memory usage just keeps going up by
small chunks continuously, but the cpu is hardly being touched. We have
cycled the machine, done a backup and restore but the problem still
occurs. The same script has been run at numerous other sites without a
problem. What I do not understand is that it really is just a
replication of the second statement in the script, and that always works
at this site.



Is there a way in Firebird 1.5.2 to alter the field size without doing
all the copying of data into temporary fields ?



T.I.A

Martin



[Non-text portions of this message have been removed]