AutoCommand 20036 Guía de instalación descargar pdf (Pagina 59)

Sales 4.1.01 now generates tables.config at startup in C:\ProgramData\Siriusware\Sales. This

file is used in place of the .inf files to indicate the data structure FileSync application will use with shared data

(typically F&B). Sales installs of FileSync application do not have their own tables.config anymore. Rentals

module installs should place a default tables.config in the ProgData\FileSync directory, but F&B

installs have an .INI setting that points to the Sales folder. FileSync application uses the tables.config from

there, which was generated by Sales. Tables.config is then moved to the C:\Program

Files\Siriusware\FileSync directory for FileSync's use. 4.0.58 Sales generates an .inf file, one for 32

bit, SalesData.inf, and one for 64 bit, SalesData_64Bit.inf, in C:\Program

Files\Siriusware\Sales that implements the registry settings necessary for FileSync application to operate

in Food & Beverage mode. The .inf file is copied to C:\Program Files\Siriusware\FileSync for

FileSync's utilization. 4.1.01 and 4.0.58 Sales will look for fileinfo.txt which is created by FileSync

application to determine if the shared data is ready. All other registry settings have been moved to the

Filesync.INI and Filesync_system.INI files.

Auto recall is now functional when salespoints use shared FileSync data

The AutoRecall query must be in Dbase format rather than SQL format: The Select and Sign functions should

not be present in the query string. The FROM, WHERE and field names are required. The table being queried must be

sh_save. The LIKE operator is represented by '$' which 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.

Example:

From the [preferences] section of Sales32c.INI:

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"

Details:

Functionality has been added to allow autorecall of Sales when shared data (FileSync application) is used. The

autorecall query string is added to the Sales32.INI file in the [Preferences] section. This query uses

Dbase format rather than SQL format. Please see following explaination and examples.

Any of the fields in the sh_save table may be used in the query. The contents of the specified fields are either

displayed on the buttons in the button grid or as columns in the list format.

1 2 ... 54 55 56 57 58 59 60 61 62 63 64 ... 182 183

Sin comentarios

AutoCommand 20036 Guía de instalación Pagina 59