pcsoft.us.windevCopyright 2026, PC SOFT5 Oct 2015 13:01:00 Z29 Sep 2015 19:16:00 ZHello, I am trying to move the interface between tables and application to class methods. The data are held in an object and then moved to a table with Create or Update methods. It's all about the Update method. To be able to use HModify() I had to get a position in a table (or a file, if you prefere). I thought that HReadSekFirst would do the trick. Actually it does but only half-way. The method looks like this: PROCEDURE Update() {:ProperTabelName_STR,indFile}..Connection = gDict_cnConnection HReadSeekFirst( :ProperTabelName_STR, SpedKsw_CR, :SpedKsw_CR ) MemoryToFile( object, :ProperTabelName_STR ) IF NOT HModify( :ProperTabelName_STR ) THEN Error( "CL_Forwarder::Update(): HModify( spedytorzy )", HErrorInfo() ) RETURN END where: :ProperTableName_STR is a string attribute that holds the name of the table in this case it is "spedytorzy" :SpedKsw_CR is a string attribute that holds the value of the SpedKsw_CR column in spedytorzy table. spedytorzy.SpedKsw_CR is a primary key and there is an index on this column. gDict_cnConnection is a connection to my MySQL database. Now when I run this method I get an error: Error at line 17 of Method Update process. HReadSeekFirst function called. No item found in file. Technical Information Project : wdWS50_DictSQL Dump error of module <14.00Icb>. - WL Call: Processing , line <17>, thread <0> Function , syntax # <0> - Level: fatal error (EL_FATAL) - Error Code: 70202 - WD55 Error Code: 202 - No system error code - No system error message - What happened? No item found in file. - Debug Information: IEWDHF=27001 Module= Version=<14.00Icb> Fonction (7,12) - Attached Information: EIT_LOGICALTABLENAME : EIT_PILEWL : Method Update (CL_Spedytor.Update), line 17 Click BTN_SaveAndExit (WIN_AddOrModifyForwarder.BTN_SaveAndExit), line 3 Click Modify (WIN_CarriersDict.Modify), line 7 EIT_COMPOSANT : EIT_DATEHEURE : 29/09/2015 19:00:21 - Identifier in .err: 71036 Help - Check that the Item is properly described in the file. Very well. But if I change the table name in HReadSeekFirst() from :ProperTabelName_STR to spedytorzy, the method behaves and pls note that MemoryToFile() and HModify() don't mind the :ProperTabelName_STR. I am not noticing something pretty obvious but it's the second day I am playing with the problem and I'll probably use HExecuteSQLQuery() and rewrite the method. But if you see what my blind eye is missing, pls write. All the best30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-solved-54306/read.awp5 Oct 2015 13:01:00 ZHi Piet, As this is reusable generic code that serves on any db table there is no other way. If you look at my code you see …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-solved-54306/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-solved-54306/read.awp[WD14] HReadSeekFirst() in a class methodguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-solved-54304/read.awp5 Oct 2015 10:45:00 ZHi, Both Peter and Jacek are using the same variable name for the key name and the search value. I find this very confusing,…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-solved-54304/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-solved-54304/read.awp[WD14] HReadSeekFirst() in a class methodguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-solved-54292/read.awp4 Oct 2015 19:33:00 ZOK. I have made it work. HReadSeekFirst( :ProperTabelName_STR, "SpedKsw_CR", :SpedKsw_CR ) This are the only parameters form…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-solved-54292/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-solved-54292/read.awp[WD14] HReadSeekFirst() in a class methodguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-54285/read.awp3 Oct 2015 17:02:00 ZPeter, thanks a lot. Unfortunately this indirection hasn't worked for me. This time I got an error: '500001' element unknown…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-54285/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-54285/read.awp[WD14] HReadSeekFirst() in a class methodguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-54242/read.awp30 Sep 2015 09:21:00 ZHi Jacek, This is how it looks in my save method (which will determine if it will call the Add or Update method.: // Create …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-54242/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54230-wd14-hreadseekfirst-class-method-54242/read.awp[WD14] HReadSeekFirst() in a class method