'KeyValues is a variant specifying the field value to match, or an array of field values, if
KeyFields lists more than one field.' This is in the Delphi Library Reference Help.

I want to search two fields values and I have tried that

Table.Locate('FieldName1;FieldName2', [FieldValue1, FieldValue2], [loPartialKey]);

where FieldValue1, FieldValue2 are two string value.

After compile, I got error messages as follow:

Error: Ordinal type required.
Error: Incompatible types: 'Integer' and 'string'.

I also tried that

Table.Locate('FieldName1;FieldName2', vArray, [loPartialKey]);

where vArray : array[1..2] of string; vArray[1]:=FieldValue1, vArray[2]:=FieldValue2

After compile, I got error messages as follow:

Error: Incompatible types: 'Variant' and 'Array'.

What is the exact syntex of the 'locate' method for searching more than one fields.

Please, help!

---Jinglan Wang

'KeyValues is a variant specifying the field value to match, or an array of field values, if
KeyFields lists more than one field.' This is in the Delphi Library Reference Help.

I want to search two fields values and I have tried that

Table.Locate('FieldName1;FieldName2', [FieldValue1, FieldValue2], [loPartialKey]);

where FieldValue1, FieldValue2 are two string value.

After compile, I got error messages as follow:

Error: Ordinal type required.
Error: Incompatible types: 'Integer' and 'string'.

I also tried that

Table.Locate('FieldName1;FieldName2', vArray, [loPartialKey]);

where vArray : array[1..2] of string; vArray[1]:=FieldValue1, vArray[2]:=FieldValue2

After compile, I got error messages as follow:

Error: Incompatible types: 'Variant' and 'Array'.

What is the exact syntex of the 'locate' method for searching more than one fields.

Please, help!

---Jinglan Wang

'KeyValues is a variant specifying the field value to match, or an array of field values, if
KeyFields lists more than one field.' This is in the Delphi Library Reference Help.

I want to search two fields values and I have tried that

Table.Locate('FieldName1;FieldName2', [FieldValue1, FieldValue2], [loPartialKey]);

where FieldValue1, FieldValue2 are two string value.

After compile, I got error messages as follow:

Error: Ordinal type required.
Error: Incompatible types: 'Integer' and 'string'.

I also tried that

Table.Locate('FieldName1;FieldName2', vArray, [loPartialKey]);

where vArray : array[1..2] of string; vArray[1]:=FieldValue1, vArray[2]:=FieldValue2

After compile, I got error messages as follow:

Error: Incompatible types: 'Variant' and 'Array'.

What is the exact syntex of the 'locate' method for searching more than one fields.

Please, help!

---Jinglan Wang

  I did this at work, and my Delphi at home does not have the Help updated.  But I had to create a variant
array, stuff the values in the array and use that as the second argument.
  LocateArray: Variant;

  with Table do
  LocateArray := VariantArrayCreate( [0,1], xxx ) { <-- the second parameter uses enumerated constants to
identify the type of array.  You will have to find the documentation on the VariantArrayCreate function.}

  LocateArray[0] := FieldbyName( 'Field1Name' ).Value;
  LocateArray[1] := FieldbyName( 'Field2Name' ).Value;

  if  Locate( 'Field1Name;Field2Name', LocateArray, [loPartialKey] ) then
    begin
       {whatever)
    end;

This is kind of fuzzy, so verify my code in the Help.

Jim

'KeyValues is a variant specifying the field value to match, or an array of field values, if
KeyFields lists more than one field.' This is in the Delphi Library Reference Help.

I want to search two fields values and I have tried that

Table.Locate('FieldName1;FieldName2', [FieldValue1, FieldValue2], [loPartialKey]);

where FieldValue1, FieldValue2 are two string value.

After compile, I got error messages as follow:

Error: Ordinal type required.
Error: Incompatible types: 'Integer' and 'string'.

I also tried that

Table.Locate('FieldName1;FieldName2', vArray, [loPartialKey]);

where vArray : array[1..2] of string; vArray[1]:=FieldValue1, vArray[2]:=FieldValue2

After compile, I got error messages as follow:

Error: Incompatible types: 'Variant' and 'Array'.

What is the exact syntex of the 'locate' method for searching more than one fields.

Please, help!

---Jinglan Wang

  Table.Locate('FieldName1;FieldName2', VarArrayOf([FieldValue1,
FieldValue2]), [loPartialKey]);

--
Try walking in my shoes - You'll stumble in my footsteps (Depeche Mode)
WWW:   http://www.{*word*104}enet.net/~peterp/
email: pet...@{*word*104}enet.net

jinglan wang <g...@gis.nmt.edu> wrote in article
<31F54B08.5...@gis.nmt.edu>...

country dave matthews
d...@msn.com
WWW Consultant/Developer--InfoCreations, Co.
www.infocreations.com (under construction)