Problem IBDAC with Tmssoftware DBlookupCombobox

softmouv · Post by **softmouv** » Mon 14 Apr 2008 06:49

Hi,
All Tmssoftware component works fine with IBDAC except DBlookupCombobox..
It's not a Tms problems because I have tested with DBASE and BDE and all
works fine...
Is somebody has any experience of this type of problem...
Is there any option in Query or Database connection that i need

Thank's for your help JLV

Plash · Post by **Plash** » Mon 14 Apr 2008 07:49

We cannot find any problem with TDBLUCombo component. Please describe in details the problem you have.

softmouv · Post by **softmouv** » Mon 14 Apr 2008 09:56

In a form:
* Query1+UpdateSQL--> Datasource1 (customer ... Name,surname,Month Inscription Number...)

* Query2--> Datasource2(Month ....Month Number,Month designation)
* TAdvDBLookupComboBox
Autoselect = True
AutoSize = True
Datasource (Query1) Datafield(Month Inscription Number)
Listsource (Query2)
KeyField(Month Number)
Lookup Column = 0
Lookup Load= llAlways
AdvDBLookupComboBox columns[0] Month Number
DropDirection = ddown
DropDownType = ddUser

When I directly enter the month value in TAdvDBLookupComboBox.text all works fine.
When I choose a month in the dropdown box no change...

To found where is the the bug
I put two Grids on my Form
Grid 1 --> Datasource1
Grid 2 --> Datasource 2

When I directly enter the month value in TAdvDBLookupComboBox.text immediatly the Month inscription Change in the grid 1 and the month number change in the grid 2.

When I choose a month in the dropdown box the Month Number change in the grid 2 but no change Month inscription in the grid1...

Sorry for my english ... I dont know if I well explain the troubleshootings..

Plash · Post by **Plash** » Wed 16 Apr 2008 11:55

Unfortunatly, TMS Software site has disappeared yesterday. So I cannot download the TAdvDBLookupComboBox component for testing.

softmouv · Post by **softmouv** » Wed 16 Apr 2008 15:14

Hi Plash,

Now the TMSSOFTWARE website works fine.....
For the DBlookupcombox it seems that when there is a selection and the
dropdown close the datasource go to first record ....i dont know if it's after
an close or open ????
Thank's for your help..and i think that IBDAC is a great product and very easy to use...

JLV

Plash · Post by **Plash** » Fri 18 Apr 2008 08:34

In my test the field value in the first grid is changed when I select a value from the list. TAdvDBLookupComboBox does not post the changes to the database. I need to move to the next record in the grid or call the Post method of TIBCQuery.

softmouv · Post by **softmouv** » Fri 18 Apr 2008 14:21

Thank's Plash but my problem is different

In a form i just put a lookupcombobox with datasource and Listsource there is no grid. in the form I have just only customer name,custommer adress
and custommer qualification.
Customer IBCQUERY1 is datasource and IBCQUERY2 différent qualification with code and désignation is the listsource...
When I enter directly the selection in the lookup Text all works fine..
but I choose in the dropdownlist no modification .
I try many things put in edit mode when dropdown..post and commit when close up ...no change....

Thank's JLV