NewBie : TDbComboBox Usage

[Milan Mehta]

I am new to Xailer and trying to use TDbComboBox. I could see that it use
aItems and aItemsBound arrays to store the ComboBox option. But I want to
directly refer to a Database field instead. How can I do that ?
Typically, my tables are as follow :
Machine Master
MachineCode
MachineName
MachineTypeCode
Machine Type Master
MachineTypeCode
MachineTypeName
Now when preparing the Form of Machine Master, I want to show
MachineTypeName from Machine Type Master Tabel. How can I do it ?
Let me say that I amazed by the environment called Xailer. I have started
loving the same in a very short period !
TIA
Milan.

[ignacio]

Milan,
The aItems property is not linked to any dataset, it must be populated
manually. BTW, with SQL datasources is easy with the method QueryArray. For
DBF datasources consult the method SaveToArray().
Regards,
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
noticias:4b74d5d0$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> I am new to Xailer and trying to use TDbComboBox. I could see that it use
> aItems and aItemsBound arrays to store the ComboBox option. But I want to
> directly refer to a Database field instead. How can I do that ?
>
> Typically, my tables are as follow :
>
> Machine Master
> MachineCode
> MachineName
> MachineTypeCode
>
> Machine Type Master
> MachineTypeCode
> MachineTypeName
>
> Now when preparing the Form of Machine Master, I want to show
> MachineTypeName from Machine Type Master Tabel. How can I do it ?
>
> Let me say that I amazed by the environment called Xailer. I have started
> loving the same in a very short period !
>
> TIA
> Milan.
>

[ignacio]

Milan,
The aItems property is not linked to any dataset, it must be populated
manually. BTW, with SQL datasources is easy with the method QueryArray. For
DBF datasources consult the method SaveToArray().
Regards,
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
noticias:4b74d5d0$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> I am new to Xailer and trying to use TDbComboBox. I could see that it use
> aItems and aItemsBound arrays to store the ComboBox option. But I want to
> directly refer to a Database field instead. How can I do that ?
>
> Typically, my tables are as follow :
>
> Machine Master
> MachineCode
> MachineName
> MachineTypeCode
>
> Machine Type Master
> MachineTypeCode
> MachineTypeName
>
> Now when preparing the Form of Machine Master, I want to show
> MachineTypeName from Machine Type Master Tabel. How can I do it ?
>
> Let me say that I amazed by the environment called Xailer. I have started
> loving the same in a very short period !
>
> TIA
> Milan.
>

[Milan Mehta]

Thanks Ignacio, problem solved.
Another related problem is, the search is only on the first character.
How can I have incremental search ? like if I type ABC, it should point to
record starting with ABC. I want to achieve the same with TDbComboBox as my
selection is from a Dbf file.
Kindly guide.
With best regards,
"Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> wrote in message
news:4b7517fa$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Milan,
>
> The aItems property is not linked to any dataset, it must be populated
> manually. BTW, with SQL datasources is easy with the method QueryArray.
> For DBF datasources consult the method SaveToArray().
>
> Regards,
>
> --
> Ignacio Ortiz de Zúñiga
> [Equipo de Xailer/Xailer team]
> http://www.xailer.com
> http://www.xailer.info
>
> "Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
> noticias:4b74d5d0$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>> I am new to Xailer and trying to use TDbComboBox. I could see that it use
>> aItems and aItemsBound arrays to store the ComboBox option. But I want to
>> directly refer to a Database field instead. How can I do that ?
>>
>> Typically, my tables are as follow :
>>
>> Machine Master
>> MachineCode
>> MachineName
>> MachineTypeCode
>>
>> Machine Type Master
>> MachineTypeCode
>> MachineTypeName
>>
>> Now when preparing the Form of Machine Master, I want to show
>> MachineTypeName from Machine Type Master Tabel. How can I do it ?
>>
>> Let me say that I amazed by the environment called Xailer. I have started
>> loving the same in a very short period !
>>
>> TIA
>> Milan.
>>

[Milan Mehta]

Thanks Ignacio, problem solved.
Another related problem is, the search is only on the first character.
How can I have incremental search ? like if I type ABC, it should point to
record starting with ABC. I want to achieve the same with TDbComboBox as my
selection is from a Dbf file.
Kindly guide.
With best regards,
"Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> wrote in message
news:4b7517fa$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Milan,
>
> The aItems property is not linked to any dataset, it must be populated
> manually. BTW, with SQL datasources is easy with the method QueryArray.
> For DBF datasources consult the method SaveToArray().
>
> Regards,
>
> --
> Ignacio Ortiz de Zúñiga
> [Equipo de Xailer/Xailer team]
> http://www.xailer.com
> http://www.xailer.info
>
> "Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
> noticias:4b74d5d0$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>> I am new to Xailer and trying to use TDbComboBox. I could see that it use
>> aItems and aItemsBound arrays to store the ComboBox option. But I want to
>> directly refer to a Database field instead. How can I do that ?
>>
>> Typically, my tables are as follow :
>>
>> Machine Master
>> MachineCode
>> MachineName
>> MachineTypeCode
>>
>> Machine Type Master
>> MachineTypeCode
>> MachineTypeName
>>
>> Now when preparing the Form of Machine Master, I want to show
>> MachineTypeName from Machine Type Master Tabel. How can I do it ?
>>
>> Let me say that I amazed by the environment called Xailer. I have started
>> loving the same in a very short period !
>>
>> TIA
>> Milan.
>>

[ignacio]

Milan,
Please explain which kind of 'search': DBF, SQL, from the DbBrowse filter
fields, from DBFBrowse OnSeek event, ....
Regards,
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
noticias:[email=4b752c3f@svctag-j7w3v3j....]4b752c3f@svctag-j7w3v3j....[/email]
> Thanks Ignacio, problem solved.
>
> Another related problem is, the search is only on the first character.
> How can I have incremental search ? like if I type ABC, it should point to
> record starting with ABC. I want to achieve the same with TDbComboBox as
> my selection is from a Dbf file.
>
> Kindly guide.
>
> With best regards,
>
> "Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> wrote in message
> news:4b7517fa$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>> Milan,
>>
>> The aItems property is not linked to any dataset, it must be populated
>> manually. BTW, with SQL datasources is easy with the method QueryArray.
>> For DBF datasources consult the method SaveToArray().
>>
>> Regards,
>>
>> --
>> Ignacio Ortiz de Zúñiga
>> [Equipo de Xailer/Xailer team]
>> http://www.xailer.com
>> http://www.xailer.info
>>
>> "Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
>> noticias:4b74d5d0$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>>> I am new to Xailer and trying to use TDbComboBox. I could see that it
>>> use aItems and aItemsBound arrays to store the ComboBox option. But I
>>> want to directly refer to a Database field instead. How can I do that ?
>>>
>>> Typically, my tables are as follow :
>>>
>>> Machine Master
>>> MachineCode
>>> MachineName
>>> MachineTypeCode
>>>
>>> Machine Type Master
>>> MachineTypeCode
>>> MachineTypeName
>>>
>>> Now when preparing the Form of Machine Master, I want to show
>>> MachineTypeName from Machine Type Master Tabel. How can I do it ?
>>>
>>> Let me say that I amazed by the environment called Xailer. I have
>>> started loving the same in a very short period !
>>>
>>> TIA
>>> Milan.
>>>
>
>

[ignacio]

Milan,
Please explain which kind of 'search': DBF, SQL, from the DbBrowse filter
fields, from DBFBrowse OnSeek event, ....
Regards,
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
noticias:[email=4b752c3f@svctag-j7w3v3j....]4b752c3f@svctag-j7w3v3j....[/email]
> Thanks Ignacio, problem solved.
>
> Another related problem is, the search is only on the first character.
> How can I have incremental search ? like if I type ABC, it should point to
> record starting with ABC. I want to achieve the same with TDbComboBox as
> my selection is from a Dbf file.
>
> Kindly guide.
>
> With best regards,
>
> "Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> wrote in message
> news:4b7517fa$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>> Milan,
>>
>> The aItems property is not linked to any dataset, it must be populated
>> manually. BTW, with SQL datasources is easy with the method QueryArray.
>> For DBF datasources consult the method SaveToArray().
>>
>> Regards,
>>
>> --
>> Ignacio Ortiz de Zúñiga
>> [Equipo de Xailer/Xailer team]
>> http://www.xailer.com
>> http://www.xailer.info
>>
>> "Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
>> noticias:4b74d5d0$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>>> I am new to Xailer and trying to use TDbComboBox. I could see that it
>>> use aItems and aItemsBound arrays to store the ComboBox option. But I
>>> want to directly refer to a Database field instead. How can I do that ?
>>>
>>> Typically, my tables are as follow :
>>>
>>> Machine Master
>>> MachineCode
>>> MachineName
>>> MachineTypeCode
>>>
>>> Machine Type Master
>>> MachineTypeCode
>>> MachineTypeName
>>>
>>> Now when preparing the Form of Machine Master, I want to show
>>> MachineTypeName from Machine Type Master Tabel. How can I do it ?
>>>
>>> Let me say that I amazed by the environment called Xailer. I have
>>> started loving the same in a very short period !
>>>
>>> TIA
>>> Milan.
>>>
>
>

[Milan Mehta]

Ignacio,
My problem solved with lSort := .T.
I could search incrementally in TDbComboBox.
Accept my gratitude. I am enjoying Xailer !
With warm regards,
Milan
"Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> wrote in message
news:[email=4b754e2e@svctag-j7w3v3j....]4b754e2e@svctag-j7w3v3j....[/email]
> Milan,
>
> Please explain which kind of 'search': DBF, SQL, from the DbBrowse filter
> fields, from DBFBrowse OnSeek event, ....
>
> Regards,
>
> --
> Ignacio Ortiz de Zúñiga
> [Equipo de Xailer/Xailer team]
> http://www.xailer.com
> http://www.xailer.info
>
> "Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
> noticias:[email=4b752c3f@svctag-j7w3v3j....]4b752c3f@svctag-j7w3v3j....[/email]
>> Thanks Ignacio, problem solved.
>>
>> Another related problem is, the search is only on the first character.
>> How can I have incremental search ? like if I type ABC, it should point
>> to record starting with ABC. I want to achieve the same with TDbComboBox
>> as my selection is from a Dbf file.
>>
>> Kindly guide.
>>
>> With best regards,
>>
>> "Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> wrote in message
>> news:4b7517fa$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>>> Milan,
>>>
>>> The aItems property is not linked to any dataset, it must be populated
>>> manually. BTW, with SQL datasources is easy with the method QueryArray.
>>> For DBF datasources consult the method SaveToArray().
>>>
>>> Regards,
>>>
>>> --
>>> Ignacio Ortiz de Zúñiga
>>> [Equipo de Xailer/Xailer team]
>>> http://www.xailer.com
>>> http://www.xailer.info
>>>
>>> "Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
>>> noticias:4b74d5d0$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>>>> I am new to Xailer and trying to use TDbComboBox. I could see that it
>>>> use aItems and aItemsBound arrays to store the ComboBox option. But I
>>>> want to directly refer to a Database field instead. How can I do that ?
>>>>
>>>> Typically, my tables are as follow :
>>>>
>>>> Machine Master
>>>> MachineCode
>>>> MachineName
>>>> MachineTypeCode
>>>>
>>>> Machine Type Master
>>>> MachineTypeCode
>>>> MachineTypeName
>>>>
>>>> Now when preparing the Form of Machine Master, I want to show
>>>> MachineTypeName from Machine Type Master Tabel. How can I do it ?
>>>>
>>>> Let me say that I amazed by the environment called Xailer. I have
>>>> started loving the same in a very short period !
>>>>
>>>> TIA
>>>> Milan.
>>>>
>>
>>

[Milan Mehta]

Ignacio,
My problem solved with lSort := .T.
I could search incrementally in TDbComboBox.
Accept my gratitude. I am enjoying Xailer !
With warm regards,
Milan
"Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> wrote in message
news:[email=4b754e2e@svctag-j7w3v3j....]4b754e2e@svctag-j7w3v3j....[/email]
> Milan,
>
> Please explain which kind of 'search': DBF, SQL, from the DbBrowse filter
> fields, from DBFBrowse OnSeek event, ....
>
> Regards,
>
> --
> Ignacio Ortiz de Zúñiga
> [Equipo de Xailer/Xailer team]
> http://www.xailer.com
> http://www.xailer.info
>
> "Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
> noticias:[email=4b752c3f@svctag-j7w3v3j....]4b752c3f@svctag-j7w3v3j....[/email]
>> Thanks Ignacio, problem solved.
>>
>> Another related problem is, the search is only on the first character.
>> How can I have incremental search ? like if I type ABC, it should point
>> to record starting with ABC. I want to achieve the same with TDbComboBox
>> as my selection is from a Dbf file.
>>
>> Kindly guide.
>>
>> With best regards,
>>
>> "Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> wrote in message
>> news:4b7517fa$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>>> Milan,
>>>
>>> The aItems property is not linked to any dataset, it must be populated
>>> manually. BTW, with SQL datasources is easy with the method QueryArray.
>>> For DBF datasources consult the method SaveToArray().
>>>
>>> Regards,
>>>
>>> --
>>> Ignacio Ortiz de Zúñiga
>>> [Equipo de Xailer/Xailer team]
>>> http://www.xailer.com
>>> http://www.xailer.info
>>>
>>> "Milan Mehta" <lotusinfosys@yahoo.co.in> escribió en el mensaje de
>>> noticias:4b74d5d0$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>>>> I am new to Xailer and trying to use TDbComboBox. I could see that it
>>>> use aItems and aItemsBound arrays to store the ComboBox option. But I
>>>> want to directly refer to a Database field instead. How can I do that ?
>>>>
>>>> Typically, my tables are as follow :
>>>>
>>>> Machine Master
>>>> MachineCode
>>>> MachineName
>>>> MachineTypeCode
>>>>
>>>> Machine Type Master
>>>> MachineTypeCode
>>>> MachineTypeName
>>>>
>>>> Now when preparing the Form of Machine Master, I want to show
>>>> MachineTypeName from Machine Type Master Tabel. How can I do it ?
>>>>
>>>> Let me say that I amazed by the environment called Xailer. I have
>>>> started loving the same in a very short period !
>>>>
>>>> TIA
>>>> Milan.
>>>>
>>
>>