Organizer Advantage is powerful yet easy to use database manager for Windows.
Advantage Designer lets you modify our solutions or easily create new ones.
Take control of your data with our simple or buinsess database software solutions.


 |  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 


easy-to-use database designer

Text, Numeric (Advanced)

You can define SQL Query attribute for Text and Numerical data fields. When this attribute is defined Organizer Advantage executes the query or the calculations and stores the result in this field. It happens in two situations: when you create a new record or when you modify an existing one. The field value is stored in the table.

There is additional attribute called IsSavedOnce that could be used in connection with the SQL Query. If you enter Y for this attribute the SQL Query is only executed once when the new record is created and then saved.

The program displays the value of this field on the record form, on the grid, in reports, statistics, you can use this field in the search or the sort functions, and you can use this field in other query or calculation definitions.

Organizer Advantage is using Firebird SQL. When defining SQL attribute use Firebird operators and functions:

  • arithmetic operators: +, -, *, /
  • concatenation operator: || (double-pipe) (’PO-’||ID)
  • constants: a number (12.22, 2) or a string enclosed in apostrophes (‘text string’, ‘123.12’)
  • functions: CURRENT_DATE, BIN_OR(N1,N2)

Text, Numeric data fields with SQL Query:

organizer, text and numeric as calculated fields

BARCODE, text field:

organizer, text and numeric as calculated fields, barcode sample

ENTERED, text field:

organizer, text and numeric as calculated fields, record entry date

MODIFIED, text field:

organizer, text and numeric as calculated fields, record modified date

TOTAL, numeric field:

organizer, text and numeric as calculated fields, total value

TAX_VALUE, numeric field:

organizer, text and numeric as calculated fields, tax value

FINAL_PRICE, numeric fields:

organizer, text and numeric as calculated fields, final price

 

Copyright © 2021 · All Rights Reserved · PrimaSoft PC