Page 1 of 1
Problem IBDAC with Tmssoftware DBlookupCombobox
Posted: Mon 14 Apr 2008 06:49
by softmouv
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
Posted: Mon 14 Apr 2008 07:49
by Plash
We cannot find any problem with TDBLUCombo component. Please describe in details the problem you have.
Problem IBDAC with Tmssoftware DBlookupCombobox
Posted: Mon 14 Apr 2008 09:56
by softmouv
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..
Posted: Wed 16 Apr 2008 11:55
by Plash
Unfortunatly, TMS Software site has disappeared yesterday. So I cannot download the TAdvDBLookupComboBox component for testing.
Posted: Wed 16 Apr 2008 15:14
by softmouv
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
Posted: Fri 18 Apr 2008 08:34
by Plash
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.
Posted: Fri 18 Apr 2008 14:21
by softmouv
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