TOracleDataSet and Locate by blanks

[matthias]

Hi,

i just encountered a problem using the Locate-function of the OracleDataSet. I've field which sometimes contains 10 blanks. The method will fail because the search criteria is trimmed and the original value in the dataset not (see function NullField).

What would you suggest?

kindly regards,

Matt

 

[Marco Kalter]

If spaces are significant, you can set TOracleSession.Preferences.TrimStringFields to False. This way all trailing spaces will be preserved in the result set of a dataset.

 

[matthias]

Hi Marco,

thanks for your answer. But I already set TrimFields to false. As far as I can see it concerns the method SearchRecord where you're iterating through the FieldList. If the criteria is a ftString you do a StringArray[f] := TrimRight(Value); The trim method which cares about the setting is TrimString, I think.

Well, hope this will help. Thanks for your answer.

kindly Regards,

Matthias

 

[Marco Kalter]

Hmm, I think this should be:

StringArray[f] := TrimString(Value);

Can you try this?

 

[matthias]

Hi Marco,

well, this is working - as expected. Are you going to fix this in your package?

thanks,

Matthias

 

[Marco Kalter]

Of course