|
| How to "alter" a table created by alias? |
| Iniciado por guest, 12,jun. 2015 08:51 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 12,junio 2015 - 08:51 |
Hello,
I would like to know if I can change a data source (data file) after I have created it via alias.
I want to create "trigger_files" for every file I have in my analysis and I don't want to use a separate stored procedure for each file.
On the other hand, I want my trigger files to have some more attributes than my analysis files. Can anyone help me?
Best regards,
Kozeta |
| |
| |
| | | |
|
| | |
| |
| Publicado el 12,junio 2015 - 13:34 |
Hi Kozeta,
I never done it this way in HFSQL (i do it a lot with mssql and oracle) but probably you can do it using alter table statement in sql
http://doc.windev.com/en-US/… |
| |
| |
| | | |
|
| | |
| |
| Publicado el 12,junio 2015 - 19:28 |
I don't know what you are trying to acheive but it looks like a lot of work to consider.
If you change one file in the analysis what to do with trigger file?
If your trigger files are only for log purpose did you consider using the log option in the analysis?
You can add extra comments in it. http://doc.windev.com/en-US/…
If you can't do it that way why not create one file to store the information of the triggers with the extra fields you need and store the information of the main files in XML in one of the fields of your trigger file, HRecordToXML will help you.
http://doc.windev.com/en-US/index.awp…
Just my 2 cents. |
| |
| |
| | | |
|
| | | | |
| | |
|