Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: AdoQuery Locate VarArrayOf Problem



Permlink Replies: 0 Threads: [ Previous | Next ]
Coşkun Çınar

Posts: 2
Registered: 4/17/17
AdoQuery Locate VarArrayOf Problem
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 21, 2017 5:09 AM
We are migrating a of apps built in Delphi 7 to Delphi 10.1.2 Berlin.

We have encountered an issue that we have been unable to resolve.

We used AdoQuery.Locate in many places
like this
ADOQuery1.Locate('Column1',VarArrayOf(['value1']),[]);

this code doesn't work .

Error:
Project Proje1.exe raised exception class EVariantTypeCastError with message 'Could not convert variant of type (Array Variant) into type (OleStr)'.

I think the problem is due to the system.pos method
and i think its bug

http://i.hizliresim.com/Br8b4v.png

Can you check this part.

Thanks in advance

Edited by: Coşkun Çınar on Mar 21, 2017 5:09 AM

Edited by: Coşkun Çınar on Mar 21, 2017 5:10 AM
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02