[Gambas-user] Nested data source
T Lee Davidson
t.lee.davidson at gmail.com
Thu Jul 4 15:54:31 CEST 2019
On 7/4/19 4:04 AM, Marco Ancillotti wrote:
> Il 03/07/19 19:15, Benoît Minisini ha scritto:
>> Le 03/07/2019 à 18:56, Marco Ancillotti a écrit :
>>> uhmmm, so I have a graphical design problem , I have a form that would like to be like:
>>> 1)---------input from datasource1-------------
>>> 2)---------insert into datasource2-------------
>>> 3)---------input from datasource1-------------
>>> Is there a way to move third part to a datasource3 and link datasource 1 to 3 ?
>>> If I move datasource 2 to bottom the graphical design will be hard to understand.
>> Sorry, can you be more precise?
> The problem is only graphical, I've made two example of what I have not working and the solution I've imagine if is possible to
> link two datasource.
> Obviously if anyone finds a better solution it's welcome.
It is difficult to determine exactly what you are trying to accomplish. But, it appears as though you are perhaps trying to join
data from two distinct tables.
The Table property of a DataSource can take a SQL SELECT statement, ie. "SELECT a.field1, b.field3 from a, b".
(http://gambaswiki.org/wiki/comp/gb.db.form/datasource/table) You might need to use a SQL JOIN in the SELECT statement to get
what you need, or maybe a SQL Subquery would do the trick.
More information about the User