🚀 go-pugleaf

Saveli Kossenko wrote:
> 
> If you want to open Table "on the fly" do this:
> Form.Query1.SQL="SELECT * FROM MYTABLE"
>     or
> Form.Query1.SQL="SELECT * FROM "+ sMYTABLE
>     and
> Form.Query1.Active=.t.
> 
> In your example you have to create two queries and change SQL string of
> second query "on the fly"...
> But may be you can play with the Filter property of the second query...
> 
> With best Regards,
> Saveli Kossenko
> 
> Erich greiner wrote in message <34A487DB.225F@t-online.de>...
> >New with VdB7 I have problems opening databases at runtime.
> >Converting my application, I have a form which open a master table
> >at page 1 for editing datas and also shows in a listbox the table
> >names of related tables for selecting.
> >At form page 2 I like to open this related table, selecting from a
> >second listbox the reccounts to work on it.
> >I understand that I have to use queries for linking tables to the
> >form.
> >Previously I stored the field content (table name) in a variable
> >and used the makro operator "&" to open it, but this is not working.
> >Anybody can help me?
> >Thanks
> >Erich Greiner

Thank you very mutch for the tip reg. opening tables "on the fly",
it works.
I have to preload the variable sMYTABLE with a valid table name because
at the time there is access to the first table the second query is 
already initiated I think.(?)
I found no Filter property of the query as you noted.
New with OOP, I have one more question:
Linking tables to a form with queries, there is no access to fields
which are not linked to the form, no way found.
Previously I used the syntax "TABLE_name->FIELD_name" to work on it.
Is there an other way or have all fields to be linked to the form ?
Thank you
Best Regards
Erich Greiner