The following sample SQL Statement provides an example which returns all values found in Configuration > Tables for The Financial Edge Account's Receivable "Payment Source". The same example can be used in The Raiser's Edge for configuration tables or code tables as well.
Tip: To locate a specific table, simply replace "Payment Source" in the WHERE clause to suit the values you're interested in.
--Displays the description values for the configuration table called "Payment Source"
SELECT TE.DESCRIPTION as 'Description',
CASE TE.ACTIVE WHEN -1
END as 'Status'
FROM dbo.TABLEENTRIES TE
JOIN dbo.CODETABLES CT ON CT.CODETABLESID = TE.CODETABLESID
WHERE CT.NAME LIKE 'Payment Source'
Note: While it is possible to get this list, it is not possible to INSERT into these tables. Adding or changing configuration information requires a manual entry in the front end.
Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Our Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.