Direct SQL

Executing SQL Commands direct

Last Modified: Sunday, 13 March 2005

Using the Direct SQL option can be dangerous if you don’t know what you’re doing (hence the warnings that pop up before the screen’s made available).

Direct SQL

Commands accepted can be any valid, non “SELECT” statement.

Examples being:
(To set all movies to “in library”)

UPDATE MovieListing SET Status=1
Possible Status values:

DESIRED = -2 (Status=-2)
ORDERED = -1 (Status=-1)
BORROWED = 0 (Status=0)
IN LIBRARY = 1 (Status=1)