A virtual column is a named item that can be added to the result set. For example:
SELECT name, vorname, MAX(a) AS max FROM ...
The example uses a virtual column max. The value of max is calculated from other values.
241242243244245246247248249250251252
f = pAkteReference.getStatement().createFunction("MIN"); Function f2 = pAkteReference.getStatement().createFunction("UPPER"); f.addPart(f2); f2.addPart(minTableRef.newColumnReference(dbBeteiligte.getColumn("aName"))); VirtualColumn vc = new VirtualColumn("MIN", Column.Type.VARCHAR); vc.setValue(f); minStatement.addResultColumn(vc); bc.addPart(minStatement); return result; }