Re: [Gambas-user] Connecting DataControl to DataSource

2015-01-05 Thread T Lee Davidson
I think our mails crossed in transit. Anyway... The SQL query used to obtain the Result should essentially be: SELECT * FROM DataSource.Table WHERE DataSource.Filter So, it can actually be determined by calculation, or maybe more correctly stated, by concatenation. The data control would

Re: [Gambas-user] Connecting DataControl to DataSource

2015-01-05 Thread Lewis Balentine
YEP --- that was the problem. I completely missed is a container. In MS VB5/6 you only needed to place the Datasources on the same form actually not even that: you could build a connection or selection set and reference that. One thing I would like to see is the ability to return the SQL

Re: [Gambas-user] Connecting DataControl to DataSource

2015-01-05 Thread T Lee Davidson
On 01/05/2015 04:35 PM, Lewis Balentine wrote: ' Console Window Output: [snip] - - - - - - - - - - - - - - - - - - - - - ' FMain.Form_Open.37: DataView1 Parent: FMain Lewis, This is why you are not getting the results you expect. DataView1.Parent.Name should be DataSource1. [Sorry for the

[Gambas-user] Connecting DataControl to DataSource

2015-01-05 Thread Lewis Balentine
I must be missing something very basic in the use of form database controls. I can not seem to get a data control populated ... It appears to me that the data control is not linked to the DataSource. What am I missing ??? Two additional questions: Is there a way to access the Result object of a

Re: [Gambas-user] Connecting DataControl to DataSource

2015-01-05 Thread T Lee Davidson
On 01/05/2015 04:35 PM, Lewis Balentine wrote: I must be missing something very basic in the use of form database controls. I can not seem to get a data control populated ... It appears to me that the data control is not linked to the DataSource. What am I missing ??? Two additional