Hi, The TDBLookupComboBox uses Field.AsString or Field.Value to access the data... but I have problems with it using Unicode. I use MSSQL and I have to convert the string data using SysToUTF8/UTF8ToSys in OnGetText/OnSetText events [1] This works in TDBGrid, but not in TDBLookupComboBox. I'm working in a patch but I'm not finished. I have some problems... So, somebody have the same problem and already did the patch?

On Mon, Nov 28, 2011 at 10:28 AM, Marcos Douglas wrote: > Hi, > > The TDBLookupComboBox uses Field.AsString or Field.Value to access the > data... but I have problems with it using Unicode. > I use MSSQL and I have to convert the string data using > SysToUTF8/UTF8ToSys in OnGetText/OnSetText events [1] > This works in TDBGrid, but not in TDBLookupComboBox. > > I'm working in a patch but I'm not finished. I have some problems... > So, somebody have the same problem and already did the patch? I forgot to say that the TDBGrid works because it uses Field.DisplayText, instead of AsString or Value.

On 28/11/2011 11:37, Marcos Douglas wrote: > > On Mon, Nov 28, 2011 at 10:28 AM, Marcos Douglas ?wrote: >> >> Hi, >> >> The TDBLookupComboBox uses Field.AsString or Field.Value to access the >> data... but I have problems with it using Unicode. >> I use MSSQL and I have to convert the string data using >> SysToUTF8/UTF8ToSys in OnGetText/OnSetText events [1] >> This works in TDBGrid, but not in TDBLookupComboBox. >> >> I'm working in a patch but I'm not finished. I have some problems... >> So, somebody have the same problem and already did the patch? > > I forgot to say that the TDBGrid works because it uses > Field.DisplayText, instead of AsString or Value. There's indeed a bug in DBLookup controls not showing DisplayText Unfortunately is not as simple as replacing AsString by DisplayText because of the current method to find the list field

On Mon, Nov 28, 2011 at 12:00 PM, Luiz Americo Pereira Camara wrote: > On 28/11/2011 11:37, Marcos Douglas wrote: >> >> On Mon, Nov 28, 2011 at 10:28 AM, Marcos Douglas ?wrote: >>> >>> Hi, >>> >>> The TDBLookupComboBox uses Field.AsString or Field.Value to access the >>> data... but I have problems with it using Unicode. >>> I use MSSQL and I have to convert the string data using >>> SysToUTF8/UTF8ToSys in OnGetText/OnSetText events [1] >>> This works in TDBGrid, but not in TDBLookupComboBox. >>> >>> I'm working in a patch but I'm not finished. I have some problems... >>> So, somebody have the same problem and already did the patch? >> >> I forgot to say that the TDBGrid works because it uses >> Field.DisplayText, instead of AsString or Value. > > There's indeed a bug in DBLookup controls not showing DisplayText > > Unfortunately is not as simple as replacing AsString by DisplayText because > of the current method to find the list field Exactly. > Please create a bug report i'll look at it Here http://bugs.freepascal.org/view.php?id=20768