SQL-031: Language-translation retrieval¶

This document describes SQL-031, the language-translation retrieval statement or call used by SAIF.Business.

Classification¶

Field	Value
SQL ID	SQL-031
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsLanguageTranslation`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:LanguageCode`, `:LanguageGenderCode`, `:LookupValue`	Input	String	5 / 1 / 50	Translation lookup key

Tables¶

Table	Access	Columns used
LANGUAGE_TRANSLATION	SELECT	See sample SQL and source implementation.

Sample SQL¶

SELECT LANGUAGE_TRANSLATION.LANGUAGE_CODE AS LanguageCode,
       LANGUAGE_TRANSLATION.LANGUAGE_GENDER_CODE AS LanguageGenderCode,
       LANGUAGE_TRANSLATION.LOOKUP_VALUE AS LookupValue,
       LANGUAGE_TRANSLATION.TRANSLATED_VALUE AS TranslatedValue,
       LANGUAGE_TRANSLATION.UPDATE_DATE AS UpdateDate,
       LANGUAGE_TRANSLATION.UPDATE_USER AS UpdateUser
  FROM LANGUAGE_TRANSLATION
 WHERE LANGUAGE_TRANSLATION.LANGUAGE_CODE = :LanguageCode
   AND LANGUAGE_TRANSLATION.LANGUAGE_GENDER_CODE = :LanguageGenderCode
   AND LANGUAGE_TRANSLATION.LOOKUP_VALUE = :LookupValue

Operations and processes¶

Language translation retrieval

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business\clsLanguageTranslation.vb