🚀 go-pugleaf

>>function NewTable_OnClick
>>    form.view = ":database:newtable.dbf"
>>    form.datamodref1.ref.query1.active = false
>>    form.datamodref1.ref.query1.sql = ' select * from "newtable.dbf" '
>>    form.datamodref1.ref.query1.active = true
>>
>>This worked sometimes but mostly it didn�t. Instead I get a form with
empty
>>entryfields and no connection to any table.
>
>Closing the query also severs the controls' datalinks to its rowset's
>fields. You must reassert the datalink properties of the controls after
>reactivating the query.
>__


Ok, so the datalinks were the problem.
I cut out  "form.view....."  and changed the code to the following:

function NewTable_OnClick
form.datamodref1.ref.query1.sql = ' select * from "newtable.dbf" '
form.datamodref1.ref.query1.requery()

Now it works perfectly!

Ulli