vfpre data processing system (record set operation expression data processing management system)

vfpre data processing system software features

The programming language used in the development of this system is Visualfoxpro6.0 (+sp5), which is pure green software and can be copied and used immediately. The file format of the data table is dbf, and its main functions are data table editing, process script files, single record set query, double record set comparison query, and record set/condition/grouping setting definition.

Among them:

【Data table editing】Quick entry of elements, quick entry of field values, pasting and cutting of fields and records (between tables), filtering, tree grouping, sorting, formula setting, summary, query output, etc.

[Procedure file] contains several commonly used record set processing statements in Chinese and is compatible with the visualfoxpro6.0 programming language.

【Single record set query】Including "table summary" (generating a single-dimensional or two-dimensional query table for the record set) or "list-based output" query to output files in multiple formats

【Double record set comparison query】is mainly used to compare elements and attributes between two approximate record sets

The application of this software makes up for the shortcomings of the programming language visualfoxpro that is too difficult and the low efficiency of EXCEL spreadsheet system management data processing, and improves the efficiency of data management and processing.

Instructions for use of vfpre data processing system

Examples of application of record set expressions:

​ 1: It is known that the Finance Department has N salary withholding businesses since October 2014 (each withheld person corresponds to a data table, including several deduction details for that person), and there are M salary court withdrawal businesses (all in another data table). Find the current salary withholding and withdrawal amounts of each borrower.

The record set expression is: <<:<<*<<$<<@<<:<<$<<*<<#<>+<>+<>+<>+<>+<>>>, data table=substr(__data table name, 21)>>, data table + personnel number>>, name ,personnel number,actual deduction,data table>>+<<:<>,name,data table,withdrawal amount,personnel number>>>>,data table+personnel number>>,remaining amount=actual deduction-withdrawal amount>>,name,personnel number,actual deduction,data table,withdrawal amount,remaining amount>>

​ 2: Find the current number of retired cadres, number of retired workers, number of retired personnel, and number of retired party members

The expression of the record set is: <<*<<>>, the number of retired cadres = the number of records in the record set (<<<<record set. Current retired personnel>>+<<record set. current retired personnel>>>>(identity="cadre")), the number of retired workers = the number of records in the record set (<<<<record set. current retired personnel>>+<<record set. current retired personnel> >>>(Identity<>"cadre")), the number of internal retirements = the number of records in the record set (<<record set. currently on the roll for retired personnel>>), the number of party members = the number of records in the record set (<<<<record set. current personnel to be retired>>+<<record set. current retired personnel>>+<<record set. current retired personnel on the roll>>>>(!empty (time to join the party)))>>

​ ​ 3: Find the total annual salary summarized by personnel in 2016.

The expression of the record set is: <<$<<*<<@<>+<>+<>+<>+<>+<>+<>+<>+<>+<>+<>+<>+<>>>, total salary = housing subsidy + position salary + annual merit salary + subsidy + qualification subsidy + property subsidy + municipal bureau monthly cashing + special business award + provincial bureau adjustment award + innovation award + annual general increase>>, personnel number>>

​ ​ 4: Generate the period of service of the chief and deputy staff members

Step 1: Define the extension field first: [Field..Resume tenure period (deputy unit)]

The expression defined: <<$<<*<<$<

vfpre data processing system update log

Main modifications and improvements:

​ ​ 1: Add functions: rearrange list values in string (), get list values in string ()

​ ​ 2: Solve the bug when {{}} in the running script contains a recordset expression that is more than 250 characters long

3: The character value table lookup function adds the table lookup method of "not greater than", "greater than", "not less than" and "less than" a certain value.

​ ​ 4: "Backup file" performance optimization and restore according to the latest directory file name by default

​​ 5: In the comparison query function of double record set records, the original comparison of values can only compare one expression, and the modification is to compare the entered "field (expression) check list"