Locate and loPartial

Thread View: borland.public.cppbuilder.database.multi-tier

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Bob Kelly Mon, 04 Nov 2002 14:39

#295

Author: Bob Kelly
Date: Mon, 04 Nov 2002 14:39

23 lines
1664 bytes

Hi all,
I'm trying to use the locate method to allow partial input of a first and
last name and locate the nearest match.
I find that I cannot get the first name to allow partial match whereas the
last name does.
ie input Jo Blog in a TEdit field, (split into first an last) and it finds
nothing whereas input of  Joe Blog finds the Joe Bloggs record.
relvant code is:-

TLocateOptions Opts;
Opts.Clear();
Opts << loPartialKey << loCaseInsensitive;
Variant locvalues[2];
locvalues[0] = Variant(first);
locvalues[1] = Variant(last);
ClientDataSet1->Locate("FirstName;LastName", VarArrayOf(locvalues, 1),
Opts);

Am I doing something wrong here?

--
Bob Kelly
Dundee College

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads