xqconsts.pas

TxQuery is an SQL engine implemented in a TDataSet descendant component, that can parse SQL syntax,

{**********************************************}
{   Resource strings for TxQuery component     }
{   Copyright (c) 2002 by Alfonso Moreno       }
{**********************************************}
Unit XQConsts;

{$I XQ_FLAG.INC}
{$DEFINE LANG_ENG}
{.$DEFINE LANG_SPA}
Interface

Resourcestring

  SXQUERY_ABOUT = 'TxQuery Version 1.81 (Sep 2002)';

  //SDefaultDateFormat = 'm/d/yyyy';
  SAggrSUM = 'SUM OF ';
  SAggrAVG = 'AVG OF ';
  SAggrSTDEV = 'STDEV OF ';
  SAggrMIN = 'MIN OF ';
  SAggrMAX = 'MAX OF ';
  SAggrCOUNT = 'COUNT(*)';

{$IFDEF xqdemo}
  SDelphiIsNotRunning = 'TxQuery Dataset (c) 2002 Alfonso Moreno' + #13#10 +
    'This is a demo version. Delphi must be running !';
{$ENDIF}

{$IFDEF LANG_ENG}
  SExprParserError = ' %s at line : %d, Column: %d, token: %s';
  SInsertWrongFieldName = 'INSERT: Field: %s does not exist in the dataset';
  SGroupByIncongruent = 'Fields in GROUP BY must also exists in SELECT columns';
  SIsNotValidInExecSQL = 'You must use SELECT only with Open method or Active property!';
  SIsNotValidInSelect = 'You must use UPDATE, DELETE, INSERT or CREATE TABLE only with ExecSQL method !';
  SGetRecordInvalid = 'GetRecord: Invalid record';
  SWrongParamsInExtract = 'Parameters for extract must be float or integer !';
  SWrongParamsInDateTime = 'Parameters for day/time function must be float or integer !';
  SSQLIsEmpty = 'SQL statement cannot be empty';
  SWrongLengthInTrim = 'Length of trimmed char in TRIM function must be 1';
  SHavingExprWrong = 'Wrong expression in HAVING predicate';
  SHavingWrong = 'Aggregate function not found in SELECT';
  SCircularReference = 'Circular reference not allowed';
  SJoinPredicateWrong = 'Number of tables in JOIN predicate must meet number of tables in FROM !';
  SDataSetNotOpened = 'DataSet %s is not opened !';
  SWrongDataSetnameInExpr = 'Wrong dataset name ''%s'' in expression';
  SWrongResultsetFieldname = 'Wrong field name ''%s'' in expression';
  SJoinExpectedDataSet = 'The joining is not correctly defined !';
  SWrongParameters = 'Parameter(s) invalid for function %s';
  SWrongFirstArg = 'Argument %s must be alfanumeric !';
  SXQueryNotDefined = 'XQuery component not defined !';
  SDuplicateDataSets = 'DataSet name %s is duplicated in the table list';
  SColumnRepeated = 'There are more than one column with name %s';
  SRecnoInvalid = 'Recno out of range';
  SGroupBySelectWrong = 'Every single field in GROUP BY clause must be in SELECT clause';
  SGroupByWrongNum = 'No. of fields in GROUP unmatched with SELECT';
  SWrongTableName = 'Wrong table name in format %s.*';
  SWrongIndexField = 'Field index incorrect';
  SFieldNotFound = 'Field %s was not found';
  SJoinOnMustHaveDiffTables = 'Left and right tables must be different in JOIN';
  SJoinOnWrongRightTable = 'Right table in JOIN must meet second table in FROM';
  SJoinOnWrongLeftTable = 'Left table in JOIN must meet first table in FROM';
  SJoinOnWrongTableNum = 'Number of tables in FROM is wrong for JOIN ON clause';
  SSubqueryWrongCols = 'Subquery with more than one column';
  SSubqueryWrongTables = 'More than one table in FROM clause in subquery';
  SWrongTableNumber = 'No tables defined in FROM clause!';
  SWrongFieldName = 'Field Name %s not found';
  SWrongDataSetName = 'DataSet %s doesn''t exists';
  SErrorInDBField = 'Error specifying a database field !';
  SCannotContainParams = 'Field %s of database cannot have parameters !';
  SExpresionNull = 'Expression is empty';
  SExprNotBoolean = 'Expresion is not of boolean type !';
  SRecordNotFound = 'Cannot found a record that correspond to the expression !';
  SBookmarkNotFound = 'Bookmark %d not found';
  SIndexOutOfRange = 'Index out of range';
  SErrorInWhere = 'Error in where expression';
  SParameterNotFound = 'Parameter %s not found in the list of params';
  SFileNotExists = 'LoadFromBinaryFile: File does not exists !';
  SCircularDataLink = 'Circular data link';
  SDuplicateFieldName = 'Duplicate field name';
  SFieldNameNotFound = 'PRIMARY KEY: field not found';
  SBlobFieldWrongType = 'BLOB FIELD: wrong type (1-5)';
  SDataSetUnexpected = 'DataSet is not of the expected class: %s';
  SReadBooleanField = 'Cannot read field as boolean';
  SReadFloatField = 'Cannot read field as float';
  SReadIntegerField = 'Cannot read field as integer';
  SReadStringField = 'Cannot read field as string';
  SReadVariantField = 'Cannot read field as variant';
  SWriteBooleanField = 'Cannot assign field as boolean';
  SWriteFloatField = 'Cannot assign field as float';
  SWriteIntegerField = 'Cannot assign field as integer';
  SWriteStringField = 'Cannot assign field as string';
  SWriteVariantField = 'Cannot assign field as variant';
  SIsInvalidFloatValue = 'Invalid floating point value %s';
  SIsInvalidIntegerValue = 'Invalid integer value %s';
  SIsInvalidBoolValue = 'Invalid boolean value %s';
  SNotAnAggregate = 'This is not an aggregate field !';
  SInvalidFieldNo = 'Invalid field number %d';
  STransfColumnsMismatch = 'Number of columns in SELECT mismatch in GROUP BY';
  STransfOrderByMismatch = 'Number of columns in SELECT mismatch in ORDER BY';
  STransfWrongColumnGroup = 'Column order in GROUP BY must match in SELECT';
  STransfWrongColumnoRDER = 'Column order in order BY must match in SELECT';
  SFailOpenFile = 'Failed to open or create file';
  SFailCreateMapping = 'Failed to create file mapping';
  SFailMapView = 'Failed to map view of file';
  SBeyondEOF = 'Position beyond EOF';
  SListError = 'List index error';
  SSyntaxErrorMsg = ' %s at line : %d, Column: %d, token: %s';
  SParamsError = 'Params were not replaced !';
  SDuplicateAlias = 'Alias already exists';
  SSubqueryInSelectsError = 'Not allowed nested subqueries in subqueries in SELECT';
  SWrongParameterQuotes = 'It is not possible to coexist both quotes (") and (''))';
  SWrongJoin = 'More than one table but no JOINing defined';
  SSubqueryKindWrong = 'In this version all subqueries must be ANY or ALL, but not both';
  SWrongIntoTable = 'The INTO table defined does not exists';
  SxqFieldNotFound = 'Field not found ';
  SCaseListMissingAlias = 'CASE statement need an alias.';
  SCaseExprNotBoolean = 'Expresion is not of boolean type in CASE clause !';
  SJoinNotMismatch = 'Tables referenced in JOIN does not correspond';
  SDupParamsAsFields = 'ParamsAsFields: duplicate name';
  SJoinFieldIncongruency= 'Field in join for corresponding table not found';
  SJoinInvalidFieldName= 'Invalid field or table name in join clause';
  SEXPR_WRONGWHENEXPR = 'Expression in Case must be boolean';
  SEXPR_WRONGTHENEXPR = 'Expressions in THEN section must be all of same type';
  SEXPR_UNKNOWNID = 'Unknown Identifier %s';
  SEXPR_OPERATORINCOMPAT = 'Operator %s incompatible';
  SEXPR_CANNOTCASTTOSTRING = 'Cannot read %s as String';
  SEXPR_CANNOTCASTTOFLOAT = 'Cannot read %s as Float';
  SEXPR_CANNOTCASTTOINTEGER = 'Cannot read %s as Integer';
  SEXPR_CANNOTCASTTOBOOLEAN = 'Cannot read %s as boolean';
  SEXPR_WRONGUNARYOP = '%s is not simple unary operator';
  SEXPR_WRONGBINARYOP = '%s is not a simple binary operator';
  SEXPR_WRONGBOOLEANOP = 'cannot apply %s to boolean operands';
  SEXPR_WRONGRELATIONALOP = '%s is not relational operator';
  SEXPR_WRONGPARAMETER = 'Invalid parameter to %s';
  SEXPR_INVALIDPARAMETERTO = 'Invalid parameter to %s';
{$ENDIF}

{$IFDEF LANG_SPA}

  { Resource strings en Espa駉l - Mexicano       }
  { Traducido por Francisco Due馻s               }
  { Email: [e-mail]                 }

  SExprParserError = ' %s L韓ea : %d, Columna: %d, Identificador: %s'; //' %s at line : %d, Column: %d, token: %s';
  SInsertWrongFieldName = 'INSERT: El Campo: %s no existe en el dataset'; //'INSERT: Field: %s does not exist in the dataset';
  SGroupByIncongruent = 'Los campos del GROUP BY deben tambi閚 existir en las columnas del SELECT'; //'Fields in GROUP BY must also exists in SELECT columns';
  SIsNotValidInExecSQL = '