Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2026-09

Lazarus DBLookupcombobox

4 messages · 2 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Lineu Carneiro Saraiva

Hi,

I started developing a software with Lazarus / Oracle after many years programming with Delphi.

Now I started a quite complex form with some dblookupcombobox and I have this problem:

When I try to change a register I do db1.keyvalue = table.keyfield.value;

It doesnt work.

The description related to keyfield doesnt appear.

DBlookup is connect to the table that is active.

If I click on the component all registers of the table are there.

Tried everything with IA and had no solution.

Another form with just one dblookup is working normally but in the new form nothing solves my problem.

Rgds

---------------------- Lineu Carneiro Saraiva www.aeromuseu.com.br +55-19-9-8137-5200 (Whatsapp)

Reply by email

Jamal Gabra
to Lineu Carneiro Saraiva

Hi,

I know the struggle. I have had my fair share at the beginning of using the DBLookupCombobox.

Did you ensure that your DBLookupComboBox has the following properties set correctly and they point to the appropriate fields from the database/table: ListField
KeyField
ListSource

If yes, can you generate a small version and attach to highlight the issue and give a chance to go through the code/form lines.

Regards,

Jamal

On Sat, Sep 19, 2026 at 7:52?PM Lineu Carneiro Saraiva via lazarus <

Show quoted text 40 lines
wrote: Hi, I started developing a software with Lazarus / Oracle after many years programming with Delphi. Now I started a quite complex form with some dblookupcombobox and I have this problem: When I try to change a register I do db1.keyvalue = table.keyfield.value; It doesnt work. The description related to keyfield doesnt appear. DBlookup is connect to the table that is active. If I click on the component all registers of the table are there. Tried everything with IA and had no solution. Another form with just one dblookup is working normally but in the new form nothing solves my problem. Rgds -- ---------------------- Lineu Carneiro Saraiva www.aeromuseu.com.br +55-19-9-8137-5200 (Whatsapp) -- _______________________________________________ lazarus mailing list https://lists.lazarus-ide.org/listinfo/lazarus

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20260920/dd917e85/attachment.htm>

Reply by email

Jamal Gabra

Haven't finished the whole thing yet, but I see your first mistake here:

instead of ".AsString":
<< else tb055b.parambyname('x6').asstring:=db52.keyvalue;

Use ".Value" for the assignment:

> else tb055b.parambyname('x6').Value:=db52.keyvalue;

This is just one line, you have many of them.

Will look at the PDF in more depth later, if the above does not fix your issue.

Jamal

Show quoted text 85 lines
Thanks for answer. I created a PDF, enclosed here, with all the information and some imagens. If you cannot open the PDF or if you need more info please let me know. I have being using Delphi for more than 25 years and I never had problem with dblookup. ChatGPT tried some many alternatives and concluded with something like "I dont know". Nice weekend and thans again. ---------------------- Lineu Carneiro +55-19-9-8137-5200 (Whatsapp) Em 20/09/2026 05:54, Jamal Gabra escreveu: Hi, I know the struggle. I have had my fair share at the beginning of using the DBLookupCombobox. Did you ensure that your DBLookupComboBox has the following properties set correctly and they point to the appropriate fields from the database/table: ListField KeyField ListSource If yes, can you generate a small version and attach to highlight the issue and give a chance to go through the code/form lines. Regards, Jamal On Sat, Sep 19, 2026 at 7:52?PM Lineu Carneiro Saraiva via lazarus < > wrote: > Hi, > > I started developing a software with Lazarus / Oracle after many years > programming with Delphi. > > Now I started a quite complex form with some dblookupcombobox and I have > this problem: > > When I try to change a register I do db1.keyvalue = table.keyfield.value; > > It doesnt work. > > The description related to keyfield doesnt appear. > > DBlookup is connect to the table that is active. > > If I click on the component all registers of the table are there. > > Tried everything with IA and had no solution. > > Another form with just one dblookup is working normally but in the new > form nothing solves my problem. > > Rgds > > -- > ---------------------- > Lineu Carneiro Saraiva > > www.aeromuseu.com.br > +55-19-9-8137-5200 (Whatsapp) > > -- > _______________________________________________ > lazarus mailing list > > https://lists.lazarus-ide.org/listinfo/lazarus > --

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20260920/0b46aa46/attachment.htm>

Reply by email

Lineu Carneiro Saraiva
to Jamal Gabra

Hi Jamal,

Will check this soon and inform you.

Rgds

Jamal Gabra wrote 111 lines
Haven't finished the whole thing yet, but I see your first mistake here: instead of ".AsString": << else tb055b.parambyname('x6').asstring:=db52.keyvalue; Use ".Value" for the assignment: >> else tb055b.parambyname('x6').Value:=db52.keyvalue; This is just one line, you have many of them. Will look at the PDF in more depth later, if the above does not fix your issue. Jamal On Sun, Sep 20, 2026 at 12:54?PM Lineu Carneiro Saraiva wrote: Thanks for answer. I created a PDF, enclosed here, with all the information and some imagens. If you cannot open the PDF or if you need more info please let me know. I have being using Delphi for more than 25 years and I never had problem with dblookup. ChatGPT tried some many alternatives and concluded with something like "I dont know". Nice weekend and thans again. ---------------------- Lineu Carneiro Saraiva www.aeromuseu.com.br <http://www.aeromuseu.com.br> +55-19-9-8137-5200 (Whatsapp) Em 20/09/2026 05:54, Jamal Gabra escreveu: > Hi, > > I know the struggle. I have had my fair share at the beginning of > using the DBLookupCombobox. > > Did you ensure that your DBLookupComboBox has the following > properties set correctly and they point to the appropriate fields > from the database/table: > ListField > KeyField > ListSource > > If yes, can you generate a small version and attach to highlight > the issue and give a chance to go through the code/form lines. > > Regards, > > Jamal > > > On Sat, Sep 19, 2026 at 7:52?PM Lineu Carneiro Saraiva via > lazarus wrote: > > Hi, > > I started developing a software with Lazarus / Oracle after > many years > programming with Delphi. > > Now I started a quite complex form with some dblookupcombobox > and I have > this problem: > > When I try to change a register I do db1.keyvalue = > table.keyfield.value; > > It doesnt work. > > The description related to keyfield doesnt appear. > > DBlookup is connect to the table that is active. > > If I click on the component all registers of the table are there. > > Tried everything with IA and had no solution. > > Another form with just one dblookup is working normally but > in the new > form nothing solves my problem. > > Rgds > > -- > ---------------------- > Lineu Carneiro Saraiva > > www.aeromuseu.com.br <http://www.aeromuseu.com.br> > +55-19-9-8137-5200 (Whatsapp) > > -- > _______________________________________________ > lazarus mailing list > > https://lists.lazarus-ide.org/listinfo/lazarus > --
---------------------- Lineu Carneiro Saraiva www.aeromuseu.com.br +55-19-9-8137-5200 (Whatsapp) -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20260920/10d4970b/attachment.htm>

Reply by email