Devart Forums

Hi,

when I use MyQuery.Lookup(FieldName,SearchValue,ResultField)) on TMyquery where no IndexFieldNames is defined everything works ok but very slow, but when I add value in IndexFieldNames property and variable "SearchValue" is empty Myquery return error : '' is not valid integer value.

I noticed also that if IndexFieldNames is defined you can not use this dataset for lookup fields if field type is different. With empty IndexFieldNames everything is working ok.

Regards,
Pedja

Please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

Email is sent to you.

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

But note: when using IndexFieldNames MyDAC employs quick sorting method, and this method can't be employed when you use incorrect value type of SearchValue (string value for Integer field).