Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
8
Erster Beitrag:
vor 4 Jahren, 5 Monaten
Letzter Beitrag:
vor 4 Jahren, 5 Monaten
Beteiligte Autoren:
Steven Sitas, Ned!, ICI

Difference between WDMODFIC and HModifyStructure (WD17)

Startbeitrag von Steven Sitas am 18.11.2013 15:43

I have been using HModifyStructure - for sometime now - in my WinDEV 17 applications.
It seemed to work fine ...
Today I got a call from one of my customers - his database was totally "messed" up.
He got all kind of strange INTEGRITY ERRORS

I had done some analysis modifications, mostly added Links (but also fields) and I thought the HModifyStructure in my code would take care of them ....

I got the data and just finished the testing - here is what I learned.

1. HModifyStructure took care of the new fields
2. HModifyStructure made a TOTAL mess of the Links
3. After HModifyStructure the program opened the the database/files just fine. It just failed with some updates - due to INTERGRITY errors.

4. I ran WDMODFIC and it showed tens of tables that needed to be fixed.
I couldn't understand what type of "fix" they needed but I went on and WDMODFIC fixed everything.
//////////////////////////////////////////////////////////////////////
I am using Windev17 and HFSQL 17
And in my Analysis ALL files are described as Classic HF and I change to HFSQL in my code.

Please note that the same app (in Classic) mode doesn't show the problem.
/////////////////////////////////////////////////////////////////////////////////////////

Anybody care to comment?

Antworten:

Hi Steven
Maybe , if you are not try, to try with HSetRep()
HSetRep() do something with links. You can see in help.

P.S. I also use HModifyStructure() but until today I has not similar problems.

Regards !

von ICI - am 18.11.2013 20:34
Hi,

I have sent this request to PC Soft in the past and they came back to me with the follwing:

Quote

The update links is not supported by the HModifyStructure function, it is only the structure of the data. A suggestion to this effect has been forwarded to our development team and our quality team for the next versions.
You have to call HAddLink, this function can add/change the links between files on your server :

http://doc.pcsoft.fr/en-US/?3044312&name=haddlink_function&q=HAddLink



I am using HCreationIfNotFound and this seems to update files and links correctly.

Thanks
Ned!

von Ned! - am 19.11.2013 09:40
Hi Ned,
thanks for the info - I didn't know this limitation ...
When you say that HCreationifNotfound updates files and links correctly, what do you actually mean?
Does it change the TYPE of a link, already in the database?

Steven Sitas

von Steven Sitas - am 19.11.2013 13:56
Hi Steven,

Yes it will change the type of link, e.g. it will change a 1-to-1 link to a 1-to-Many link. So for me, the HCreationIfNotFound essentailly makes the deployed database have the same structure as you have in your analysis.

Thanks
Ned!

von Ned! - am 19.11.2013 14:03
Hi Ned,
I also use HCreationIfNotFound, but it doesn't change my links !!!!!!!
Just tried - WinDEV17 and HFSQL

von Steven Sitas - am 19.11.2013 14:26
Hi,

The difference could be that you have HF Classic files in your analysis maybe? Mine are currently HFC/S in the analysis (using WD18 as well)

If you delete the link, is it created properly after that? It's not a good answer but it might work.

The best answer is for PC Soft to update HModifyStructure to update links and files!

Thanks
Ned!

von Ned! - am 19.11.2013 14:35
Hi,
thanks for your suggestions.
I think I will make a small application to run WDMODFIC.
It is the only safe solution for now ...

Steven Sitas

von Steven Sitas - am 19.11.2013 14:53
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.