VCursor Class: Field Methods
Field( inIndex as Integer ) as VField Field( inName as String ) as VField
- inIndex - The Index of the field. Starts from 1.
- inName - The Name of the field.
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.
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