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