VCursor Class: Field Methods

Declaration:

Field( inIndex as Integer ) as VField
Field( inName as String ) as VField

Parameters:

• inIndex - The Index of the field. Starts from 1.
• inName - The Name of the field.

Description:

You can use these methods to access fields of the cursor and their values. The order of fields in the cursor is the same as the order of fields in the SELECT statement of the query.

Example:

dim i, Records as Integer
LastName as String
dim curs as VCursor
 
curs = gDataBase.SQLSelect(“select * from person where name like ‘john’ no_case”)
 
Records = curs.RecordCount
for i = 1 to Records
	curs.CurrentPosition = i
	LastName = curs.Field( “last_name” ).GetString  
next