<< Click to Display Table of Contents >> Navigation:  Dataservers > AdoServer Class > Methods > AdoServer:FieldGet()

Purpose

Get the contents of a field that is identified by its position.

 

Prototype

METHOD FieldGet (  uFieldID )  

 

 

Argument(s)

<uField>        The position/name/symbol of the required field

 

 

Description

If the column is of type AdChapter, an object of type AdoRecordSet() is returned

 

Note        The return value of FieldGet() will be influenced by the NullAsBlank setting:

-        If the SQL Value is not NULL a value of the proper type is allways returned

-        If the SQL value is NULL or the server is at EOF and NullAsBlank = FALSE, FieldGet() will return NIL

 

-        If the SQL value is NULL or the server is at EOF and NullAsBlank = TRUE, FieldGet() will return a value of the proper type (String, Date, Numeric, Logical)

 

Note 2        The return value of DateTime fields depends on a global setting that can be changed with the AdoDateTimeAsDate() function. If this flag is TRUE a Date value will be returned, else an object of type AdoDateTime

 

See Also

AdoServer, AdoServer:FieldPut(), AdoServer:NullAsBlank, AdoDateTimeAsDate(), AdoDateTime