Entries for month: September 2007
DBX 10.0.4 Released
Posted by Kevin J. Miller in ColdFusion , DBX on September 9, 2007
Very minor release which adds an option in the code generator to
insert a table alias for select and update queries when using
owner.table.column naming syntax.
Ideally,
all queries should be written in the verbose owner.table.column syntax
for performance reasons (saves the query optimizer from having to
resolve the ambiguity), but this becomes a major pain to write,
especially if you use [brackets] along with the verbose naming, and you
use the generated query code from DBX as the basis for adding JOIN's
and so on.
The alias option simply aliases the table in
question with the first character of the table name and fills in the
reference for the specified columns.
Recent Comments