Tcl/Tk in a Nutshell

Special Variables

The global variable sybmsg is used by Sybtcl to store information related to its operation. The variable is an array and contains the keys described in the following list:

collengths

A list of the column lengths of the columns returned by sybcols.

coltypes

A list of the types of the columns returned by sybcols.

dateformat

Controls formatting of dates. Can be set to a string containing substitution strings, described at the end of this section.

dberr

Error number generated by the last DB-Library routine.

dberrstr

Error text associated with dberr.

fixedchar

Normally, trailing spaces are trimmed from character data. If set to yes, trailing spaces are retained.

floatprec

Number of decimal places to use for floating-point values. Default is 17.

handle

The handle of the last Sybtcl command.

line

Line number of the SQL command or stored procedure that generated the last message.

maxtext

Sets maximum amount of data returned by sybnext and sybreadtext commands. Default is 32,768 bytes.

msgno

Message number from the last Sybase server message.

msgtext

Message text associated with msgno.

nextrow

Indicates result of last SQL command. Possible values are described in the next list.

nullvalue

String value to return for null results. The default value default will return 0 for numeric types and a null string for others.

oserr

Operating system error number associated with the last DB-Library error.

oserrstr

Error text associated with oserr.

procname

Name of stored procedure that generated the last message.

retstatus ...