Tcl/Tk in a Nutshell

Name

sybnext

sybnext handle [commands] [substitutionCharacter] [tclvarname colnum...]

Return the next row of data from the SQL statements executed by the last sybsql command. Returns a list with all columns converted to strings.

The optional commands parameter can specify a command string to repeatedly execute for each row until no more data is available. Command substitution is performed, where the strings @1, @2, @3, etc., are replaced with the results from the appropriate columns. The string @0 is replaced with the entire row, as a list.

An optional parameter substitutionCharacter can specify a different substitution character to be used instead of @. A null string may be specified, in which case column substitutions are not performed.

Tcl variables may also be set for each row that is processed. One or more matching pairs of variable names and column numbers can be specified.