AutoCommand 20036 Guia de Instalação descarregar pdf (Página 61)

Notes:

• The query does not begin with the SELECT statement. The query starts with the field names.

• The like or contains operator, “$”, uses a different argument order than other operators. The left-

hand argument is the string that you are seeking, and the right-hand argument is the string or field in which

you are seeking. In the above examples we are searching for all the values in the field RECALL1 which

contain the current group: ‘<group>’ $ RECALL1. For an exact match, use the equal operator

,’=’: operator = ‘<operator>’.

• The AND & OR clauses are entered as .AND. & .OR

• TRUE and FALSE are represented by .T. & .F. Using ‘1’ for true and ‘0’ for false is NOT supported.

Sorting:

Results may be sorted by adding ORDER BY [field name] to the end of the query. Further Adding DESC

will sort in descending order. Note only one field may be sorted on. For example, the following will generate a list

of all, open, non-reservation sales for a given operator, group and su/jointfilesconvert/487301/bgroup within the last 24 hours and order the

results in descending order of the BALANCEDUE field:

AutoRecall="first_name,last_name,descrip1,orig_dt,balancedue FROM sh_save

WHERE date_time > DATETIME(YEAR(DATE()), MONTH(DATE()), DAY(DATE())-1) .AND.

'<GROUP>' $ RECALL1 .AND. '<SUBGROUP>' $ recall2 .AND. operator =

'<OPERATOR>' .AND. salespoint = '<SALESPOINT>' .AND. finalized = .F. AND

reserv_no = 0 ORDER BY balancedue DESC"

To query for a blank field, you cannot compare the field to an empty string. For example, if you used the following

expression:

MYFIELD = ''

The results of the query would contain records where MYFIELD is not blank. This is because comparisons are

between two strings up to the length of the shorter string. Therefore an empty string, which has a length of 0, will

always match the first 0 characters of a field. Instead of comparing with an empty string, you should compare the

field to a blank string:

MYFIELD = ' '

Where ' ' is padded with spaces up to the length of MYFIELD.

FileSync application now supports TCP monitoring (ServiceMonitor)

1 2 ... 56 57 58 59 60 61 62 63 64 65 66 ... 182 183

Sem comentários

AutoCommand 20036 Guia de Instalação Página 61