| Insert a dialogue screen [message #1601] |
Wed, 03 September 2008 08:27  |
gpatti
Messages: 283
Registered: August 2008
|
Senior Member |
|
|
Hi Tony,
I have my application working well now, but would appreciate your advice on transaction patterns within the framework to see how I might make some functionality improvements.
I currently have an 'Import' function that inserts data into a table using a select (from the same table actually, but with a new key value). This all done by simply using an ADD4 transaction on pressing the 'Import' button.
I'd like to improve this by inserting a dialogue between the 'Import' button and the ADD4, allowing the user to enter some parameters (yes/no, dropdown selections and radio buttons etc.), enabling me to adjust the select clause.
If possible, I'd like to improve this even further, by allowing the user to preview the data (LIST1?) before using SUBMIT to actually add to the database.
I'm think I may need to define a temporary table for this, but I'd like your views on how I might select the best transaction patterns to achieve this.
Graham
|
|
|
|
| Re: Insert a dialogue screen [message #1602 is a reply to message #1601] |
Wed, 03 September 2008 10:49  |
AJM
Messages: 2370
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
Take a look at the 'Generate PHP scripts' function in the Data Dictionary which is a two-screen process - screen (a) asks for a table name and a pattern id, then screen (b) does what is necessary for that pattern.
When it comes to previewing the data you have two choices - retrieve it from memory (i.e. within the table object) or retrieve it from the database.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
