Combining (One Row) Parameter Tables

Applications often have single row tables to store things like app or user parameters. A common method to ensure the table only has one record is to set up a numeric field (perhaps “ParamID” as type Long) and set as the Primary Key. Set the Default Value for the table to 0, the Validation Rule for that field to =0 and set some Validation Text such as “Only one record allowed in this table.”

If the app has both an AppParam table for general settings and a UserParam table for user-specific setting you could combine them as one row in a query by creating a temporary field in the query that is only used to join the two tables together.


SELECT sp.*, up.* 
FROM 
(
  ( SELECT *, "A" as addedField FROM SysParam)  AS sp
  INNER JOIN 
  ( SELECT *, "A" as addedField FROM UserParam) AS up
  ON sp.addedField = up.addedField
)

Tigers have no natural predators. They love water and are great swimmers. Oh... and they purr as well as roar.

While no two tigers are striped exactly the same (stripes even vary on each side of the animal), all tigers have a set of three lines on their forehead as represented by Wang - the Chinese symbol for King.

This Chinese character features Wang, the Chinese Symbol for King three transverse lines representing the heaven, people and earth respectively.

When linked by the vertical line "|", a character comes into being representing the one owning the absolute authority of the world, the king.

Of the eight sub-species of tiger, three—the Caspian, Balinese, and Javan—are considered extinct, and the remaining five are critically endangered.

Estimates put the most numerous of the tigers, the Bengal, at 3,000–5,000 in the wild, primarily in India. This is more than the other four sub-species combined.

Combining (One Row) Parameter Tables

Tigers

Recent Posts