Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
5
Erster Beitrag:
vor 4 Jahren, 5 Monaten
Letzter Beitrag:
vor 4 Jahren, 5 Monaten
Beteiligte Autoren:
David Egan, Steven Sitas

[WD17] Integrity Error

Startbeitrag von David Egan am 31.10.2013 08:12

Hi
I have recently changed several files in my analysis and changed the links (changed from string to int fields). Now whenever I try to save a record I get a really bizarre integrity error message "testdb\stkmast.fic does not exist in CDB database". Well, yeah I know that 'cos testdb is a totally different database (identical to CDB)

What makes this even more odd is that the analysis is set to HFClassic, there are no connections set within the analysis itself & both testdb and CDB (which is the database I'm currently logged into) are HFCS databases. If I change to another database I get the same message, again pointing to testdb\stkmast. If I put the link back to the strings all works correctly, including writing the correct integer value to my desired linking field.

Does anyone have any idea what the problem could be, where it could be picking up this reference to the other database & how to fix it.

Thanks

David

Antworten:

Hi David,
It reminds me of a problem I had sometime ago ..
Here is a short "story" that may help you (or somebody else).

All my tables in the Analysis are always set to HFClassic.
I change to HF C/S using code in the project code.

I also use CUSTOM FOLDERs in the analysis and my code is something like this:
HChangeConnection("MyFolder",myconnect)

I use the same type of code for other HF "functions":
HModifyStructure("MyFolder",hmsBackgroundTask)
HCreationIfNotFound("MyFolder",hChangeCharset)

At some point I stupidly "moved" one of my tables OUTSIDE its analysis folder to the Main Group ...
Then because my code didn't EVER see this table, my WD app assumed it was in a default place (pointed to by my analysis) and I got all this crazy "integrity errors".

Hope this helps

von Steven Sitas - am 31.10.2013 14:29
Thanks Steven
Sounds something similar to my problem (I have my analysis organised/handled the same as you) , except that mine works OK if I revert the links so the data file must be visible. It's almost as if the integer links in the analysis are between 2 different databases, neither one being the default one.

All very strange!

von David Egan - am 31.10.2013 18:23
Hi David,
>> except that mine works OK if I revert the links so the data file must be visible.

Please note that the my data file was also visible - it just pointed to the WRONG data file on the disk.
Also when reverting the link, it is NATURAL NOT to get the "integrity error".

just my 2 cents

von Steven Sitas - am 31.10.2013 19:04
Thanks Steven
I think I've just solved it. After adding the integer field to my file I had moved it in the file description (being a bit anal); not sure if that was before or after I created the link though. I've moved it back to the bottom of the description & in a couple of quick tests it seems to be right.

Cheers

David

von David Egan - am 31.10.2013 19:22
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.