Generic Tcl Database Interface API

--- docs/api.html Wed Jul 22 21:54:38 1998 +++ docs/api.html Wed Jul 19 17:19:34 2000 @@ -1,2 +1,5 @@ +
+ +
@@ -55,3 +58,3 @@ statement). Use with `fetchrow` and `endquery`.
- `sql query $conn "select * from sample where x > 3"` + `set query [sql query $conn "select * from sample where x > 3"]` @@ -62,3 +65,3 @@ is returned.
- `while {[set row [sql fetchrow $conn]] != ""} { puts $row }` + `while {[set row [sql fetchrow $conn $query]] != ""} { puts $row }` @@ -66,4 +69,4 @@

-

-

### Sample Usage:

+

+

### Sample Usage:

Also see @@ -86,3 +89,3 @@ # Put some dummy data in: -for {set i 0} {$i < 10} {incr i} { +for {set i 0} {$i < 10} {incr i} { sql exec $conn "insert into junk values ($i, $i.01, 'xx $i xx')" @@ -91,5 +94,5 @@ # Do a select and display the results -sql query $conn "select * from junk where i > 3" +set query [sql query $conn "select * from junk where i > 3"] -while {[set row [sql fetchrow $conn]] != ""} { +while {[set row [sql fetchrow $conn $query]] != ""} { puts "row = $row" @@ -97,3 +100,3 @@ -sql endquery $conn +sql endquery $conn $query @@ -113 +116,3 @@ +
+
>Release-Note: >Audit-Trail: >Unformatted: