FIELDVALUE Function

Returns the value of a specified field as a string.

Category: Data Input

Syntax

stringFIELDVALUE(<integer>)

Required Argument

<integer>

specifies the index into the incoming fields.

Examples

Example 1

// Declare a string variable to contain the third field value
String Value_Field3
 
// Use the fieldvalue function to get the
// value in the third field of the 
// incoming data 
Value_Field=fieldvalue(3)

Example 2

// Declare a hidden integer for the for loop, initializing it to 0
hidden integer i
i = 0
 
// Checks each field to see if the field is a name field and the value is numeric
for i = 1 to fieldcount()
begin
   if instr(lower(fieldname(i)),'name') then
   if isnumber(fieldvalue(i)) then
   return true
end