The Select Fixture validates the contents of a table or query on DefaultConnection[?].


Script Fixture
line call?
CREATE TABLE PERSON
(
ID INT
,FIRSTNAME VARCHAR(25)
,LASTNAME VARCHAR(25)
)
/ OK

Script Fixture INSERT INTO PERSON VALUES(:1,:2,:3)
BIND1 BIND2 BIND3 call?
10 Robert Martin OK
20 Micah Martin OK


The Select Fixture uses arg[0] for the name of a table. The second line defines the names of the columns.

Select PERSON
ID FIRSTNAME LASTNAME
10 Robert Martin
20 Micah Martin

arg[0] can be a query statement.
Select SELECT * FROM PERSON WHERE ID = 10
ID FIRSTNAME LASTNAME
10 Robert Martin

arg[0] may specify many columns. Some columns may not be verified.
Select PERSON
ID FIRSTNAME
10 Robert
20 Micah

Demonstrate surplus and missing rows.
Select PERSON
ID FIRSTNAME LASTNAME
10 Robert Martin
20 Modified Martin
30 Missing Martin


Clean up
Script Fixture DROP TABLE PERSON
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