PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → [WD20] HFSQL - Compare structures of Analysis File and Physical File
[WD20] HFSQL - Compare structures of Analysis File and Physical File
Débuté par DannHCS, 04 mai 2016 14:50 - 2 réponses
Posté le 04 mai 2016 - 14:50
Hi,
is there a function or a method to check if the structure of the physical file is the same of the description in analysis?

I use HCreationIfNotFound and crashes because of the different structure.

Thanks,
Dann
Posté le 04 mai 2016 - 14:59
try with HCheckStructure function
Posté le 04 mai 2016 - 18:38
Hi Dann,
The following code will catch the different structures:

WHEN EXCEPTION IN
HCreationIfNotFound("*",hChangeCharset)
DO
SWITCH HError()
CASE 70016:
Info("Data needs reorganization")
// here you can add code to reorganize data //
EndProgram()
OTHER CASE:
Error("HFSQL error: " + HError())
EndProgram()
END
END