locate with 2 fields doesn't work

[johnkuiper]

Normally I use only one key to locate a record.
Now I have to find a record with two fields.
This is what I use

Code: Select all

if Virtualtable.Locate('programma_id, lijstnummer',vararrayof([StrProgrid,IntLijstnr]),[])

This occurs an error, because the second field is not found. But the fields are created (seen with virtualtable.getfieldnames).

Is this a bug. Is there another way to find the record except the filter?

[Antaeus]

You should split fields in the field list with a semicolon, not with a comma:

Code: Select all

if Virtualtable.Locate('programma_id; lijstnummer',vararrayof([StrProgrid,IntLijstnr]),[]) 

[jkuiper_them]

Sorry

Normally I'm using one field to find.