QueryEdit data fields display the result of the SQL Query. The QueryEdit field does not store the value in the table, this field is dynamic, and the value is recalculated for the selected record.
For the selected record the QueryEdit data field lets you display simple data or calculated data from another table through the use of the SQL query and the common field.
The program lets you display the value of this field on the record form and in reports. You cannot display this field on the grid, in custom views, statistics, or use it in the search and the sort functions.
Use this field type in a complex database solution that has several tables with related data. For example, use it when in one table you want to display processed, related data from another table.
If you want to use a queryedit field in your table:
In the below database sample there are two tables: STUDENTS and COURSE_LOG.
For the selected student the program executes SQL queries and displays results:
Course registration record, sample entry:
NUMBER_OF_COURSES; field definition sample:
CREDIT_HOURS; field definition sample:
TOTAL_PAYMENT; field definition sample:
GPA; field definition sample:
Copyright © 2021 · All Rights Reserved · PrimaSoft PC