STRQMQRY require compile if add new field
I add field to a physical file, should i compile the STRQMQRY source, although inside STRQMQRY don’t use the new field. I test STRQMQRY old object, can run on in amend physical file. I juz want to double confirm from expert.
Software/Hardware used:
Software
Software/Hardware used:
Software
ASKED:
June 10, 2010 11:35 AM
UPDATED:
June 11, 2010 12:03 AM
Answer Wiki:
No need to recompile a QM query unless you removed something that was needed by the query or changed something to be incompatible.
For example, if you changed a CHAR column to be an INTEGER column, you would possibly have a WHERE clause that made a character comparison -- the comparison might have been against a quoted string and need to be changed so that it was a numeric literal instead. Or you might have renamed a column that you used in your column list -- you'd need to change the source to refer to the new name.
In general, if you don't have to make any change to the QM source, then you won't need to recompile.
Tom
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
