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

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 t

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: > 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 que

[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