SqlTxPtr$

Return the identifier for a text or image column in the current row.

Syntax

SqlTxPtr$ ( sqlconn%, column% )

where

sqlconn%

Is a SQL Server connection. The value of sqlconn% is returned by SqlOpen%.

column%

Is the number of the column. The first column in a table is number 1.

Returns

The identifier for a text or image column in the current row. In the case of a NULL text or image value, the identifier value is an empty string.

Important Do not modify this identifier in any way. Modifying the identifier can cause unpredictable results.

Remarks

Every text or image column has an associated identifier that uniquely identifies the text or image value. This identifier is useful in conjunction with SqlWriteText%. The identifier returned by SqlTxPtr$ supplies the value for the textptr$ parameter of SqlWriteText%. Call SqlTxPtr$ only after SqlNextRow% or SqlGetRow% has returned regrow.

Text pointers are of fixed length and can be null when the text or image value is null.

Example

See the Windows-based programming example for SqlWriteText%, later in this chapter, which uses SqlTxPtr$.

See Also

SqlTxTimeStamp$ and SqlWriteText%