Script Fixture CREATE TABLE NUMBERS ( VALUE INT )
call?
OK


The Insert Fixture uses 2 or 3 parameters.
The second line defines the names of the columns.

Insert NUMBERS 1
VALUE
10
20
30

Insert NUMBERS 1 APPEND
VALUE
40
50
60

We can use Select to validate the table.
Select NUMBERS
VALUE
10
20
30
40
50
60

Or we can use a Script to validate the table.
Script Fixture begin Select count(*), sum(value) into :out 1, :out 2 from numbers; end;
call? BIND1 BIND2 statement?
6 210


Clean up
Script Fixture DROP TABLE NUMBERS
call?

Keyboard Shortcuts ?

  • General

  • t Test page or suite
  • e Edit page
  • v View page (after test)
  • a Add new page

  • Go To

  • g u User Guide
  • g q Quick Reference Guide
  • g f Full Reference Guide
  • g c Recent Changes

  • Edit Mode

  • CTRL+s Save page
  • ESC Cancel edit

  • Tools

  • p Properties
  • w Where used?
  • AK+v Versions
  • AK+h Page History
  • / Focus on search bar
  • s Open search page
Close