pcsoft.us.windevCopyright 2026, PC SOFT20 Dec 2009 18:00:11 Z10 Oct 2009 01:47:56 ZHi JImbo san, (and Hi You) With reference to this discussion : http://forum.mysnip.de/read.php?27131,25246 I have modified your source a bit (will follow) and ATM I think you are wrong : >Therefore, the program would balk at you with an error message if the structure in the analysis doesn't match the physical structure of the data file. BUT: there's virtually no way to know whether the program needs to be updated or the data file has to be restructured! Even worse, I found that data files not always contain the correct generation number but do work together with an analysis of a higher generation number as long as the physical structure fits the structure in the analysis! > I think we can catch error 70016 (THE FILE DOES NOT MATCH ITS DESCRIPTION) -- see yourself : [code] // Use the same connection for all the data files HChangeConnection( "*", SHARED.gsConnection ) // Open all Files and DO error handling sAllFiles is string = HListFile("","",hLstNormal) sCurrFile is string nErrCode is int FOR EACH STRING sCurrFile OF sAllFiles SEPARATED BY CR WHEN EXCEPTION IN HOpen(sCurrFile) //TRace(sCurrFile) DO ExceptionEnable() nErrCode = ExceptionInfo(errCode) // THE INDEX DOES NOT MATCH THE DATA OR CORRUPTED INDEX IF nErrCode = 70021 _OR_ nErrCode = 70052 THEN HIndex( sCurrFile, hNdxSilent ) // FILE NOT FOUND ELSE IF nErrCode = 70003 THEN HCreation(sCurrFile) // THE FILE DOES NOT MATCH ITS DESCRIPTION ELSE IF nErrCode = 70016 THEN // modify this database table.... ELSE // Remains yet unsolved !! EndProgram( ExceptionInfo(errFullDetails), -1) END END END [/code] So it seems that we are able to catch structural analysis changes (Error 70016): The idea is now ro re-use the cModifyAuto class coming along with the WDSetup example.... but more in the following message... (This one is allready too long. Björn30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-23329/read.awp20 Dec 2009 18:00:11 ZHi All, Great discussion. Two comments: 1) We always distribute WDMODFIC.exe + required files with our applications. Furthermo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-23329/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-23329/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-solution-retrieve-generation-number-from-analysis-23327/read.awp19 Dec 2009 16:12:40 Zhttp://www.windev.at/html/intgennumber.html This is not about a new command but it's using the current ..GenerationNumber prope…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-solution-retrieve-generation-number-from-analysis-23327/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-solution-retrieve-generation-number-from-analysis-23327/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22392/read.awp22 Oct 2009 11:43:40 ZGuenter, a second install (with a second, new database) is the same as a first install. The tbl_version is newly created and …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22392/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22392/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22388/read.awp22 Oct 2009 09:46:03 ZHi Arie, what if your customer chooses to install your program a second time? Only way to go: distribute the tbl_version togeth…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22388/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22388/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22169/read.awp10 Oct 2009 18:12:10 ZI always have one file in the project called tbl_version, which has only one field current_version. On startup of my exe I read…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22169/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22169/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22157/read.awp10 Oct 2009 18:10:01 ZHi Bjoern, most days I'm out of bed from about 4:00 in the morning. Normally, I have take a nap in the afternoon anyway because…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22157/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22157/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22156/read.awp10 Oct 2009 18:09:50 ZHi Bjoerno san, I think, we don't have a choice here, let's be realistic! We do not re-invent HyperFileSQL, we do not re-invent…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22156/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22156/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22155/read.awp10 Oct 2009 18:09:25 ZDomo Arigato JImbo san, As always, I am readong your comments very! carefully: But atm. it seems that I a'm not able to get it…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22155/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22155/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22154/read.awp10 Oct 2009 18:09:13 ZJimbo san, just this (atm) I don't want to have WDMODFIC.EXE with our Installation. I simply hate black boxes. I prefer program…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22154/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22154/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22153/read.awp10 Oct 2009 18:09:00 Z>Now the questions remains : How to auto-update db-tables which are not in sync with the analysis any more ? > >I would li…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22153/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22153/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22152/read.awp10 Oct 2009 18:08:43 ZHi JImbo san, (and Hi You) >With reference to this discussion : > >http://forum.mysnip.de/read.php?27131,25246 > …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22152/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22152/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22145/read.awp10 Oct 2009 01:48:10 ZNow the questions remains : How to auto-update db-tables which are not in sync with the analysis any more ? I would like to re-…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22145/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22145/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22143/read.awp10 Oct 2009 01:47:47 ZFor a better understanding, or in other words, to see the whole problematic: Here the current snippet : HFAQL CS, UserGroupwa…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22143/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/22144-ping-jimbo-san-hopen-hcreationifnotfound-auto-modify-tables-22143/read.awpPing JImbo san. HOpen() vs HCreationIfNotFound() /auto modify db-tables