Board index » delphi » Locate doesn't work with options

Keith Knapp

Delphi Developer
Mon, 13 Nov 2000 03:00:00 GMT

Locate doesn't work with options

When I use the loCaseInsensitive and loPartialKey options in the LOCATE
method for a query the correct record is not found, an example is below.

If I get rid of one of the options then things work.

If I only search with one key and field it works with both options. But
it never works with multiple keys and fields with both options.

Is there a work around? Is this a bug?

DM.qryStuff.Locate('LASTNAME;FIRSTNAME',VarArrayOf(['Doe','John'])
,[loCaseInsensitive,loPartialKey])

 
Brian Bushay Tea

Delphi Developer
Tue, 14 Nov 2000 03:00:00 GMT

Re:Locate doesn't work with options


This works for me using delphi 3 BDE 4.51
although if you are trying to locate on a partial key for multiple fields only
the last field value can be partial

Quote
>When I use the loCaseInsensitive and loPartialKey options in the LOCATE
>method for a query the correct record is not found, an example is below.

>If I get rid of one of the options then things work.

>If I only search with one key and field it works with both options. But
>it never works with multiple keys and fields with both options.

>Is there a work around? Is this a bug?

>DM.qryStuff.Locate('LASTNAME;FIRSTNAME',VarArrayOf(['Doe','John'])
>,[loCaseInsensitive,loPartialKey])

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Other Threads

1. TQuery's locate method doesn't work properly

2. TLocate Options doesn't work

3. Options/Final Output doesn't work

4. Locate/Seek doesn't work for this

5. TQuery.Locate Doesn't work as expected

6. Locate doesn't work correctly

7. Locate Doesn't work

8. Locate doesn't locate

9. WORKING DIRECTORY: Doesn't work

10. Post doesn't work with Indy, works with ICS