Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
4
Erster Beitrag:
vor 2 Jahren, 8 Monaten
Letzter Beitrag:
vor 2 Jahren, 7 Monaten
Beteiligte Autoren:
Paulo Oliveira, Serge Shalo Wilson, KOZETA

How to "alter" a table created by alias?

Startbeitrag von KOZETA am 12.06.2015 06: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

Antworten:

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/?2034001&name=SQL_statements#NOTE8

von Paulo Oliveira - am 12.06.2015 11:34
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 the 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/?3044009

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?3044093

Just my 2 cents.

von Paulo Oliveira - am 12.06.2015 17:28

Re: How to save two database tables on one table at the front end

I want to save two database tables and the result should be viewed at the front end that is concider we have two database tables at the back end and at the front end one table I want to validate two forms and the result of both forms should be viewed at the front end table . please I need help thanks

von Serge Shalo Wilson - am 02.07.2015 13:11
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.