|
| Inicio → WINDEV 2024 → Clarification sought on WD's ability to change data structure "on the fly" |
| Clarification sought on WD's ability to change data structure "on the fly" |
| Iniciado por guest, 28,sep. 2012 20:24 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 28,septiembre 2012 - 20:24 |
I've not yet played with this, so I'm asking the WD experts..
In Clarion, I have a third party template that I can add to my application - it's job is to detect if an application update has changed the structure of one of the application's database files... if a change is detected (e.g. a field is added; an index is added; a field changed from a string to an integer; a field length has been lengthend; etc), a new empty table is created at runtime; the contents of the old table are migrated to the new table; the old table is renamed (to serve as a backup) and the new table is renamed to the old table's name, and a runtime error is stopped due to a data type mismatch. The template controls it all - within a few mouse clicks I can add that functionality and it takes no coding at all to benefit from this feature. Needless to say, this template is worth its weight in gold - it has saved me from having to write a dedicated "data transfer" application that has to be ran on every customer's machine..
I know the WD IDE can / will do this - the $1,000,000 question is this: is a WD application capable of also detecting a change in the table schema when it opens the table and then doing the steps above, or will the WD application halt itself with a critical error and the application terminates? |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
94 mensajes |
|
| Publicado el 21,enero 2015 - 13:39 |
I have exactly the same question (I guess this is a typical newbie question when switching from Clarion and FileManager).
How did you solve this question ? |
| |
| |
| | | |
|
| | | | |
| | |
|