| Index
» Projekty
» phpMyEdit
» Fórum
» Adding a virtual field, not in DB, and managed myself. |
 |
ScottChapman
Založený: 09.06.2007
Príspevky: 31
Zaslal: 2009-05-22 18:11
Návrat hore
Odpovedať s citátom
|
I would like to create a virtual field, that I manage through triggers.
Specifically I am wanting to put a check box in the Add/Update forms which let me know I should do some additional processing. I already have triggers setup for these operations with code that conditionally needs to be processed.
I thought I could do that by adding a virtual field, but let me know if there is another way to do this...
|
doug
Založený: 10.02.2003
Príspevky: 1013
Bydlisko: Denver, Colorado (USA)
Zaslal: 2009-05-23 18:05
Návrat hore
Odpovedať s citátom
|
Hopefully someone will prove me wrong, but I think you are looking for capabilities in phpMyEdit which do not exist.
|
ScottChapman
Založený: 09.06.2007
Príspevky: 31
Zaslal: 2009-05-23 19:38
Návrat hore
Odpovedať s citátom
|
any other way you can think to add an input field (checkbox for example) on the update/insert forms?
Like I said I am familiar with triggers OK.
|
doug
Založený: 10.02.2003
Príspevky: 1013
Bydlisko: Denver, Colorado (USA)
Zaslal: 2009-05-23 19:45
Návrat hore
Odpovedať s citátom
|
Not that I can think of. phpMyEdit basically only works with fields that exist in the db table. Maybe add another field and then concoct a 'php' script option to interact with it. Or maybe a dummy / virtual field followed by other unusual mechanism.
|
ScottChapman
Založený: 09.06.2007
Príspevky: 31
Zaslal: 2009-05-23 19:50
Návrat hore
Odpovedať s citátom
|
What is a dummy/virtual field?
I think I saw from other postings that a virtual field is just one that uses SQL for its value? Perhaps I could use that and just ignore the SQL or something?
|
doug
Založený: 10.02.2003
Príspevky: 1013
Bydlisko: Denver, Colorado (USA)
Zaslal: 2009-05-23 19:55
Návrat hore
Odpovedať s citátom
|
| ScottChapman Napísal: |
| What is a dummy/virtual field? |
R.T.F.M. and/or search the forum for dummy and/or virtual to find examples. Easiest examples add numbers displayed in two other columns in List mode.
|
ScottChapman
Založený: 09.06.2007
Príspevky: 31
Zaslal: 2009-05-23 22:31
Návrat hore
Odpovedať s citátom
|
Nothing in the documentation...
I did read that one can create a "virtual" field, but I am not sure exactly what the designation (how do you specify that a field is virtual?).
And I did see one post where there is a PHP option (which only works if there is a dummy SQL option).
I see that the PHP option includes a PHP file which is executed. It looks to me as though it returns the text to use for the value, but I am not sure that would work for a checkbox?
|
|
Odoslať novú tému
Odpovedať na tému
|
|
|
|