IBQuery and Locate sensitive case

[alexhaifa]

Hello

I have a IBQuery and Locate, my problem is being case sensitive.

My Query has many rows in UPPER CASE and others in Low Case words, the locate is case sensitive and I need to locate the words without this, how to do this?

Thanks
Alexandre

[PavloP]

To use the Locate method in the case-insensitive mode, add the loCaseInsensitive constant to the Options parameter of this method:

Code: Select all

IBCQuery1.Locate(FieldName, KeyValue, [loCaseInsensitive]);

See more details in our documentation:
http://www.devart.com/ibdac/docs/index. ... tions).htm

[alexhaifa]

Thanks very much

You're right!! I had forgotten about this )

[PavloP]

Feel free to contact us if you have any further questions.