An SQL Form Launcher (ComplexReference) control is not linked to a database attribute of the current table. With Complex Reference, you can open the form of another table, using a filter. You can define this filter using complex SQL statements.
Test the SQL statement in the SQL Assistant.
|
Property |
Description |
|
System Category |
|
|
ClassName |
ComplexReference |
|
Name |
Specifies the name. For example, $COMPLEXREFERENCE1. |
|
Specific Category |
|
|
DetailTable |
Specifies the table you want to open. Select the table. |
|
Filter |
Defines the filter that will be executed. Set the values that should be replaced in {}. Click Examples: FID = {FID_CHILD}. name = (select typename from specialtable where height = {objectheight} and width={objectwidth}) |
to open the SQL Assistant. You can use the ComplexReference control with input parameters, such as a radius, which the user is prompted to enter. An input box will appear. If the parameter is a numeric value, you must use the # character. If it is a text value, use the $ character.
Example: {#Radius} {$Name}
SDO_WITHIN_DISTANCE(a.Geom,
(select geom from LM_POINT where fid={fid}) ,
'distance = {#Radius}') = 'TRUE'