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