--- docs/api.html Wed Jul 22 21:54:38 1998 +++ docs/api.html Wed Jul 19 17:19:34 2000 @@ -1,2 +1,5 @@ + + Generic Tcl Database Interface API + @@ -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: