FinanceFerret/queries/qryCbx Accts

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

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;