Hello Jan, This from the help on fDataDir() Returns the full path of the directory of HFSQL data files specified by the user when installing the application. Remark: This directory does not necessarily correspond to the real directory of the data files at run time (that may have been modified by HSubstDir, HChangeDir, ...). It may work for you or try fCurrentDir() Regards Alby Al - WinDev Forum
Hello Guenter I know where your project is but not sure if you want to go there. "Ploing" is French for plunging and plunging is a method for cleaning a blocked toilet so..... Regards Alby Al - WinDev Forum
Hello Sivaprakash The SQLTable and FileToMemory Table are existing commands to write the entire file to a memory table in one go. They are in the Help They would be difficult to use in this instance without a complex query to work out the values you need in the query process Regards Alby Al - WinDev Forum
Hello Sivaprakash It is the multiple TableAddLine() commands per row that are killing your performance. They are the source of the very large ..Value numbers in your profile screen shots. The answer is to create some memory variables and work out your assignment value before putting the data into the table with a single TableAddLine() function per row If you have absolutely have to chby Al - WinDev Forum
Hello Sivaprakash, That is a very inefficient way to add lines to the table because you are executing the tableaddline() function 20 times for each row. Use a single tableaddline for each row by adding the sdquery fields in the same sequence as the table columns with each sdquery value separated by a comma. FOR EACH sdQuery TableAddline(Table_Ledger,sdQuery.voucherdate,sdQuery.Accouby Al - WinDev Forum
Hello Sivaprakash Check the table content option is "By Programming" and that none of the table columns have a link I also fill memory tables using TableAddLine() and it is very quick but I use a different method In my code I would create a view of the data with HCreateView() and declare integer variables for nTableRow is int = 1 and nViewCount is int = hnbrec(Viewname) and theby Al - WinDev Forum
Hello Jaistar Your database should have fields for the menu item name and the program to run. Fill a table or treeview from the data file with a link back to the datafile so that a double click on the table row can lookup the datafile and open the associated program window. You can also use the same process to fill the standard menu process with data from a table. Prefill the menu with inby Al - WinDev Forum
Hello Jai This text is from the help for item: The files of user groupware Password of data files By default, the data files found in the user groupware have a specific password. This password is: "PCSGPW2001". To change this password: 1.Display the configuration window of the user groupware ("Workshop .. Configure the user groupware"). 2.In the "Files" taby Al - WinDev Forum
Hello Jaistar As Guenter has indicated you would need to modify the groupware windows. If the supervisor password is encrypted or hardcoded in the project init code or login screen and the groupware forms were modified to stop access to the SUPERVISOR user details then it might work. You would need to set the groupware to Custom as from memory, I think the autogroupware setting will creby Al - WinDev Forum
Hello Robert IMO it is never a good idea to have your data stored on the same physical drive as the OS. You would be better off moving the entire HFSQL Server to your new drive D: Regards Alby Al - WinDev Forum
Hello Aurélien, This is an ENGLISH language forum. Please post again in English Regards Alby Al - WinDev Forum
Hello, The answer, is never ! PCSoft supply an English language version of their software, they are morally obliged to fully support that product to the same extent as their French version but they refuse to do so. There is no logical or reasonable explanation for the lack of technical support for non French language developers. Cost is not a valid reason to deny the resourceby Al - WinDev Forum
Hello Issah No, the size of the table doesn't matter and I have some quite large memory tables. I do use the For Each function in memory tables but only when I do not also use any table functions inside the loop. The problem may have been fixed as I am going back a few years now. From memory, the loop would stop and exit if I changed a value in the table. Regards Alby Al - WinDev Forum
Hello Jacek Have you ticked the option "Automatically increment the version at each generation" in page 2 of the Version Information section ? Regards Alby Al - WinDev Forum
Hello Issah In my experience the For Each function for tables is broken. After several issues like yours when it was first released, I only ever use the old way. nTbleRow is int = 0 nTbleCount is int = TableCount(Table) For nTbleRow = 1 to nTbleCount I know the For Each function is supposed to be faster but it is unreliable. I think it scrambles its internal counters if you do aby Al - WinDev Forum
Hello All links Regards Alby Al - WinDev Forum
Hello Steven QuoteIt is in our interest, and of course PCSofts also, that wx becomes more popular and better known to the very large developers community. Every time I read the TIOBE index I am seized with despair that WX is not listed .. Save your despair, PCSoft seems to have no serious interest in the world outside of France. Check out the Spanish/English version of the Windev.comby Al - WinDev Forum
Hello Jaistar Have a look at these threads Regards Alby Al - WinDev Forum
Hello BKR I have a process, that sounds very similar to what you are doing and has worked for me for the last thirty plus years - so not just with Windev. File #1 has a primary key and a field which contains the name of the field/control calling the lookup elements. File #2 has the File #1 primary key value as a foreign key, a field for descriptions, return values etc and anything else I nby Al - WinDev Forum
Hello Jaistar, You could use remote access support software like Splashtop or Teamviewer. Spashtop is much cheaper than Teamviewer. Teamviewer has a free copy but it will only work to one location You could make the update with a patch or the complete new application. If there is a data file change then you would need to include the project .wdd file in the patch and as a separate fby Al - WinDev Forum
Hello Jaistar Yes. Check the examples Regards Alby Al - WinDev Forum
Hello Paulo Thank you for your quick response. I will pass your info on to my client's tech support people. Regards Alby Al - WinDev Forum
Hello All I have an issue with one client when they email out using smtp in my Windev V24 program. The same error occurs if they are sending one email or fifty The error message is: 'EmailSendMessage' function, syntax 3 What happened? Unable to send message. Check the recipient addresses as well as your account settings (sender address). Failure may be caused by a technicaby Al - WinDev Forum
Hello Jaistar That would depend on the source of the file as there are several Regards Alby Al - WinDev Forum
Hello Piet The UI disaster starts at V26 so if you have a V27 licence you could download a copy of V24 as the last decent version. V25 has the good UI but unfortunately has the bug where it doesn't always save all the open windows with Alt S. I get around that by selecting windows and Ctrl S and a prayer or two. Regards Alby Al - WinDev Forum
Hello Jaistar There is an "Import into the project" option in the project pane by right click on the "Project" item I don't use it, but I think that the SCM would also have a method of merging projects. Regards Alby Al - WinDev Forum
Hello Steven It is messy because the preview window is a PCSoft black box I add an extra email button into the "Export" menu tab In the init of that button I have some logic that either hides that button or hides the existing buttons - Btn_Email_HTML and Btn_Email_PDF The preview window is really fragile so don't delete the existing buttons, just hide them My button opby Al - WinDev Forum
Hello Kobus When I have to do date arithmetic I use the DatetoInteger() and IntegerToDate() functions. NextPTODate = IntegerToDate(DateToInteger(EDT_NextPTODate) + 180) DaysLeft = IntegerToDate(DateToInteger(NextPTODate) - DateToInteger(DateSys())) Regards Alby Al - WinDev Forum
Hello Kobus I would use EDT_LastNameInitials = nospace(EDT_LastName) + " " + nospace(EDT_Initials) Regards Alby Al - WinDev Forum
Hello Mark The file system in Windev is called Hyperfile and all commands that work on files start with "H" so HAlias() is the command to setup an alias BUJCAlias is Data Source HAlias("JCTrans","BUJCAlias") HChangeName("BUJCAlias","JCTrans") HChangeConnection(BUJCAlias,HyperFileCS) When you use an index with an alias, the index nameby Al - WinDev Forum