Locate() fails with 'Variant conversion error'

This article has not been rated yet. After reading, feel free to leave comments and rate it.

Locate() fails with a 'Variant conversion error', if you search for only one field and have this in a variant array.

This is a problem if you create the array to search for dynamically at runtime.
In the case, that you array would have only one entry, you have to pass the value itself:

Note:
This was observed under Delphi 3 with BDE 5 using InterBase and MS-SQL. I don't know if the problem occurs with later versions of Delphi. BDE version and dbms should not matter.

	begin .. MyArr := .. FieldStr := .. case FieldCount of 0: // error 1: found := Table1.Locate(FieldStr, MyArr[0], []); else found := Table1.Locate(FieldStr, MyArr, []); end; end.

Comments:

NEW: Optional: Register   Login Email address (not necessary): Rate as Off-topic Very Helpful Helpful Ok article Not useful Very bad	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option, or post under a registered account.
	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Add a picture: Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.