Infr. Map Server
- 360 Publisher
- Alias
- AutoCAD
- AutoCAD Civil 3D
- AutoCAD Electrical
- AutoCAD for Mac
- AutoCAD LT for Mac
- AutoCAD Map 3D
- BIM 360 Glue
- Building Design Suite
- Constructware
- Creative Finishing
- Design Review
- Factory Design Suite
- Flame Premium
- Green Building Studio
- Infr. Map Server
- Infrastructure Modeler
- Installation Help
- Inventor
- Inventor ETO
- Inventor Fusion
- Inventor Fusion Technology for Mac
- Inventor LT
- Inventor Publisher
- Navisworks
- Navisworks Freedom
- PLM 360
- Product Design Suite
- Project Galileo
- Project Photofly
- Project Simulus
- Revit
- Revit LT
- Robot Structural Analysis Professional
- Sim 360 Pro and Sim 360 Moldflow
- Simulation 360
- Simulation CFD
- Simulation DFM
- Simulation Job Manager
- Simulation Mechanical
- Simulation Moldflow
- Simulation Moldflow Adviser
- Simulation Moldflow Communicator
- Simulation Moldflow Insight
- Simulation Moldflow Insight 360
- Smoke
- Vasari
- Vault
How to add your knowledge
Table of contents
No headersAn 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.
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.
SDO_WITHIN_DISTANCE(a.Geom,
(select geom from LM_POINT where fid={fid}) ,
'distance = {#Radius}') = 'TRUE'