DBX 10.0.4 Released

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 JOINs 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.

0 comments… add one

Leave a Comment