Re: Populate with SQL [XPA 2.5]

Florian Groothuis

That won’t work because the requirement statement can’t be captured in the range-option of the DataSource option.


Defining a separate view isn’t an option.


Met vriendelijke groet - With kind regards,

Florian Groothuis
+31 (0)6 21927914

Meilink Beheer Borculo B.V. • Kamerlingh Onnesstraat 1
7271 AZ  Borculo • Nederland • +31 (0)545 253525
KvK 08009803 • Our general terms and conditions apply • Disclaimer

Van: [] Namens Govert Schipper
Verzonden: dinsdag 13 juni 2017 14:57
Onderwerp: Re: [magicu-l] Populate with SQL [XPA 2.5]




You could use the "Data source" property of the combobox to associate a table with the values of the combobox. You can even define a Range of the data fields. Or you could define a separate view and connect that view as a data source.




Van: <> namens Florian Groothuis <f.groothuis@...>
Verzonden: dinsdag 13 juni 2017 14:11
Onderwerp: [magicu-l] Populate with SQL [XPA 2.5]


How can I populate either a combobox or a select task with a SQL-statement?
I have a program that let's the user answer a list of questions. Some answers should be selected from a query from the DB. One simple select program populated by a SQL-statement sent as a parameter would be nice. Preferably without any third party software.

Thans in advance.

Join to automatically receive all group messages.