Hello,
I need to search for a value in all fields of the record, because I don´t know the concrete field to look for.
Is there a way to search a value in the entire contents of the fields of the record?.
Thank you. 
FiveTech Support Forums
FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour question of tDataRow
Do you want to find which field of datarow object contains a search string? If that is what you want:
If the result is empty, then no field contains the search text.
If not empty that is the first field containing the text.
function FieldContaining( oRec, cText )
cText := Upper( AllTrim( cText ) )
return FieldName( AScan( oRec:aData, { |a| cText $ Upper( cValToChar( a[ 2 ] ) ) } ) )If the result is empty, then no field contains the search text.
If not empty that is the first field containing the text.
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India
Mr. Nages,
Thank you. The function always returned me blank, but I modified in this way:
function FieldContaining( oRec, cText )
return ( AScan( ArrTranspose( oRec:aData )[ 2 ], { |a| cText $ cValToChar( a ) } ) )
So, I check if its 0 (not found) or > 0, found.
Thanks