SQL::ResultSet::DataIsNull()

Syntax

Result_Flag as L = <SQL::ResultSet>.DataIsNull( ColumnIndex as N | ColumnName as C )

Argument	Description
Result_Flag	.T. = The data is NULL. .F. = The data is not NULL.
<SQL::ResultSet>	A SQL::ResultSet object created with a DIM statement.
ColumnIndex	The number of the column. The first column is 1.
ColumnName	The name of the field.

Description

The DataIsNull() method determines whether a given element in a SQL::ResultSet is Null.

Example

dim conn as SQL::Connection

dim rs as SQL::ResultSet

dim connString as C

dim select_exp as C

dim list as C

connString = "{A5API='Access', FileName='c:\program files\a5v8\mdbfiles\alphasports.mdb'}"

select_exp = "select * from customer where bill_state_region = 'ny'"

if .not. conn.open(connString)

ui_msg_box("Error", conn.CallResult.text)

end

end if

if .not. conn.execute(select_exp)

ui_msg_box("Error", conn.CallResult.text)

end

end if

rs = conn.ResultSet

while rs.NextRow()

if .not. rs.DataIsNull(3) then

list = list + rs.Data(3) + crlf()

end if

end while

ui_msg_box("Column 3 Values", list)

conn.close()