Table Problem can you keep a table ontop of a form while editing the form
I have a push button which queries a table then creates and open the table over the form where the button is.
I would like the table to be visable so information can be took from it and typed into the form.
Please,is the any code I can use to do this.
see below for the script in my button
Var
input,testinput String
qq Query
tblVar Table
ordersTV TableView
endVar
input = "Type in RiskPhrase No ie ..10.."
input.view ("Risk Phrase Info"
qq=query
PhrasesRisk.DB | RiskPhrase | Hcode1 | Hcode2 | Hcode3 |
| Check ~input | Check | Check | Check |
PhrasesRisk.DB | RiskPhraseDescription |
| Check |
EndQuery
ExecuteQBE(qq,"tempPhraseRisk.db"
if ordersTV.open("tempPhraseRisk.db", WinStyleDefault, 100, 100, 1440*9, 1440*2) then
ordersTV.wait() ; wait for user to close
ordersTV.close() ; close Orders table
endif
endMethod
I have a push button which queries a table then creates and open the table over the form where the button is.
I would like the table to be visable so information can be took from it and typed into the form.
Please,is the any code I can use to do this.
see below for the script in my button
Var
input,testinput String
qq Query
tblVar Table
ordersTV TableView
endVar
input = "Type in RiskPhrase No ie ..10.."
input.view ("Risk Phrase Info"
qq=query
PhrasesRisk.DB | RiskPhrase | Hcode1 | Hcode2 | Hcode3 |
| Check ~input | Check | Check | Check |
PhrasesRisk.DB | RiskPhraseDescription |
| Check |
EndQuery
ExecuteQBE(qq,"tempPhraseRisk.db"
if ordersTV.open("tempPhraseRisk.db", WinStyleDefault, 100, 100, 1440*9, 1440*2) then
ordersTV.wait() ; wait for user to close
ordersTV.close() ; close Orders table
endif
endMethod