Creating the rciDistance() function
About this task
To create the rciDistance() function:
Procedure
- Choose Edit > Insert > Routine and type the following
information in the New Routine wizard.
Routine Property Value Routine Name (SQL) rciDistance Language C Return type double precision Statement Local Variables No Arguments - Name: point1, Type: rciPoint, Default: none
- Name: point2, Type: rciPoint, Default: none
Routine Calling Options Only the Routine does not accept NULL arguments check box must be checked; clear the Routine may return inconsistent check box. Routine Name (C) rciDistance Shared object path Leave as default Behavior of Routines Well-behaved Special Stack Requirements None Cost of a Routine 0 Related Routines None Object grant privileges Grant execute privileges - Click Finish and then choose Project > Save to save your project.