Switch to: V12V11V10V9V8V7V6V5

Working with Procedures

Picture Text
schema_editor_procedures.jpg

List of Procedures

  • Here you can see list of all procedures of the current database.
  • Tap the name of a procedure to see the text of procedure.
  • Tap details icon on the right to see the list of parameters of the procedure.

Top Buttons

  • Tap EDIT button to be able DELETE PROCEDURE.
  • Tap REFRESH button to force re-read the current list.

Bottom Buttons

  • Tap button “+” to CREATE PROCEDURE.

schema_editor_procedures_elements.jpg

Procedure Elements

  • Here you can see the list of PROCEDURE Elements.
  • Tap a category name to see elements in that category.

schema_editor_procedures_create.jpg

Create Procedure

  • This screen allows you CREATE PROCEDURE in a visual way. You need specify the name of new procedure, choose result type in a case of function creation, add parameters and so on.
  • Note, that you could just execute CREATE PROCEDURE or CREATE FUNCTION command from SQL Editor. But many people may find this visual way more simple.

schema_editor_procedures_create_preview.jpg

Create Procedure Query Preview

  • Here you can see a live preview of the query to be passed to VSERVER to create a new procedure.

schema_editor_procedures_text_nowrap.jpg

View or edit the text of Procedure

Here you can edit text of procedure. After edit you should tap button SAVE to fix changes.

Bottom Buttons

  • Tap button “Wrap” to wrap the text of the procedure.

schema_editor_procedures_edit.jpg

Delete Procedures

  • This screen allows you to choose one or few PROCEDURES and delete it/them.