FinanceFerret/2.0/sql/qryCbx Accts

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  • Purpose: dataset for drop-down boxes
  • Fields:
    • ID: The way this is generated is a bit of a kluge so that each line's "value" will be unique, even though some lines may have "aliases". The HTML drop-down list control seems to reject duplicate values. Appending the ID of the "alias" to the ID we actually want used gives a unique value per line which can easily be converted to the proper value by taking only the integer part.
  • History:
    • 2009-08-30 Created for web interface version
    • 2018-05-06 This is no longer being used; SQL now implemented in PHP.

SQL

CREATE OR REPLACE VIEW qryCbx_Accts AS
SELECT
  CONCAT_WS('.',ID_Alias,ID) AS ID,
  Name
FROM Accounts
ORDER BY Name;