Solved

Locate :-(

Posted on 1998-03-31
3
163 Views
Last Modified: 2010-04-06
FCurrTable.Locate('CURRENCY', VarArrayOf([S]), [])

Why does that give an EVariantError "Invalid variant type conversion" exception?

Locate always works fine till I want to search for one field.  How can I search on one field that is NOT case sensitive?  FindKey doesn't appear to work--case sensitive so it seems.

Scott
0
Comment
Question by:millerw
  • 2
3 Comments
 
LVL 1

Author Comment

by:millerw
ID: 1361137
BTW, S in the line is a string....and I know about loCaseInsensitive---I removed it while trying to debug the line to remove any complexity that may be causing problems.

Scott
0
 

Accepted Solution

by:
phillipf earned 50 total points
ID: 1361138
Try This:

FCurrTable.Locate('CURRENCY', S, []);

 

0
 
LVL 1

Author Comment

by:millerw
ID: 1361139
Don't I feel like an idiot :-)

Thanks
Scott
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now