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
Analist/programmeur
+31 (0)6 21927914


meilink.eu

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: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Govert Schipper
Verzonden: dinsdag 13 juni 2017 14:57
Aan: main@magicu-l.groups.io
Onderwerp: Re: [magicu-l] Populate with SQL [XPA 2.5]

 

Florian,

 

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.

 

Govert

 


Van: main@magicu-l.groups.io <main@magicu-l.groups.io> namens Florian Groothuis <f.groothuis@...>
Verzonden: dinsdag 13 juni 2017 14:11
Aan: main@magicu-l.groups.io
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 main@magicu-l.groups.io to automatically receive all group messages.