?
Solved

Unsupported feature

Posted on 2009-02-14
12
Medium Priority
?
1,301 Views
Last Modified: 2013-11-23
Hi

I'm using D2009

when i use this code:

IBTable1.Locate('Name',Edit1.Text,[loPartialKey]);

 this message appears:

(Project Project1.exe raised exception EIBClientError with message 'Unsupported feature'.)

 
i really need the solution of this problem

Thanks
0
Comment
Question by:CodeGear2007
  • 3
  • 3
  • 3
9 Comments
 
LVL 13

Expert Comment

by:rfwoolf
ID: 23641658
I'm pretty sure delphi has a help file article on IBTable's methods. Check the syntax for the locate method -- you're probably doing something wrong with the [loPartialKey] or something. If it's doing this error at runtime, make sure that your Name field is indexed. What database are you using.
0
 

Author Comment

by:CodeGear2007
ID: 23642249
i'm using Interbase and D2009

and it's work with D2007 and Firebird
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23644122
what about not using the loPartialKey ?

is name a primary key field ?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:CodeGear2007
ID: 23644834
I tried to use [loPartialKey] and [loCaseInsensitive] and i even tried not using them

i also tried the name as primary key field and no priamry in both cases it didn't work
0
 

Accepted Solution

by:
CodeGear2007 earned 0 total points
ID: 23691521
i found the solution it is

IBTable1.Locate('Name',VarArrayOf([Edit1.Text]),[lloCaseInsensitive]);
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23691569
isn't that a typo ?

lloCaseInsensitive

the dubbel l ?
0
 
LVL 13

Expert Comment

by:rfwoolf
ID: 23693167
Umm.. I told you to check the help file which gives you the syntax (varrayof) which would have solved your problem. Although I probably don't deserve an A-grade answer, my answer was nonetheless correct :)
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23696467
next to that, vararrayof([edit.text]) and edit.text will result in the same thing
0
 
LVL 13

Expert Comment

by:rfwoolf
ID: 23700268
All right I looked up
TIBTable.Locate method in my delphi help, it gives the syntax:
[Delphi] function Locate(const KeyFields: string; var KeyValues: Variant; Options: TLocateOptions): Boolean; override;
and this example:
Locate('Company;Contact;Phone', VarArrayOf(['Sight Diver', 'P', '408-431-1000']), [loPartialKey]);
I concede that your version might not have this example or that it didn't tell you to use VarArayOf.
You may award yourself points as you like because I was not very helpful.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

839 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