Hi, my way: your data file should contain a field which is composed of item code + item name, some thing like " 4711 - Eau de Cologne ". Composing is automatic by using a trigger "before add / modify". The combo gives a list of the composed items. For more complex searches I'm using a separate search window but this seems not to be a very practical way in your caseby harvey68 - WinDev Forum
Hi, imho there's no way to do that! - A way would be to have a hidden column of same width nearby and switch the display of the combo-column off and the the edit column on. - Another one would to let a function key open a small window which you can place over the combo column in the correct row and let the user input a new value for the combo. You have to re-load the combos of the tabby harvey68 - WinDev Forum
Hi, as we know it from the past, it is a first step to integrate WINDEV and WEBDEV. An integration like WINDEV & WINDEV Mobile. Whether it works flawlessly already in v24 or later in v27, every journey starts with the first step and it seems to be one into the right direction. Applications like TSPLUS made some impact, but you can't expect from PC Soft to abandon all the work sittingby harvey68 - WinDev Forum
Hi, I think TablePosition Syntax 2 is your friend ... Kind regards, G. Predlby harvey68 - WinDev Forum
Hello, visit https.//www.windev.at Systemhaus Predl IT-GesmbH PC Soft international distributor 2191 Gaweinstal, Austriaby harvey68 - Links to Wx-related Forums & Sites
Hi Mike, Regards, GuenterPby harvey68 - WinDev Forum
Great service Berkel as we know it all too well ... Regards, G. Predlby harvey68 - WinDev Forum
Hi Willy, FX110 + FX120 are checkout scales for UK and Italy only. The Avery Berkel web site has no download of a manual, so you should contact them first and see whats the way to interface with those scales. Kind regards, G. Predlby harvey68 - WinDev Forum
Hi Fabrice, I have to thank you for your nice words and the appropriate explanation! Kind regards and thank you! GuenterPby harvey68 - WinDev Forum
Autor: Ola Link zum Beitrag: [27130.foren.mysnip.de] Relax everybody, no panic any more! I somehow managed to delete these test errors, but I don't exactly know how:eek: Best regards Olaby harvey68 - WinDev Forum
Autor: Ola Link zum Beitrag: [27130.foren.mysnip.de] Hi all, I have 3 stubborn test scenario errors that surfaced when I upgraded my ERP from WD21 to WD23. I can delete the test code, but that doesn't delete the errors. They do not seem to have any effect on the functioning of the app, but they are annoying. How can I delete these errors (disabling them is grayed out)? TEST_Mby harvey68 - WinDev Forum
Autor: GuenterP Link zum Beitrag: [27130.foren.mysnip.de] Hi Piet, changing the extension from .fic to something else is a logical move. The homophone "fick" to "fic" is in German the same as "f*ck" in English. My first WD 5.5 program did have this extension and there were several user questions in regards to this extension. "Are we going to be f*ckby harvey68 - WinDev Forum
Autor: GuenterP Link zum Beitrag: [27130.foren.mysnip.de] Hi Ola, thank you! I did not see the command HDeleteDirectory(..), it islisted for C/S only. That's a HUGE step forward! I could delete the directory BEFORE copying the data files to the correctly named directory. I propose a backup of the original data before doing the copy anyway!by harvey68 - WinDev Forum
Autor: Ola Link zum Beitrag: [27130.foren.mysnip.de] Hi Guenter, I also could not find a HRenameDirectory command (or anything equivalent), but WD version 15 and newer ones do have the HDeleteDirectory() command. Best regards Olaby harvey68 - WinDev Forum
Autor: André Labuschagné Link zum Beitrag: [27130.foren.mysnip.de] Thanks Piet - had tried the project panel and the delete function when the popup had focus.by harvey68 - WinDev Forum
Autor: Piet van Zanten Link zum Beitrag: [27130.foren.mysnip.de] Hi André, On the Page tab, Popup Pages, Delete Kind regards, Pietby harvey68 - WinDev Forum
Forum: WinDev Forum Betreff: Re: HFCS HCopyFile + warnings Autor: Piet van Zanten Link zum Beitrag: [27130.foren.mysnip.de] Hi Guenter, When I first started using Hyperfile, (in the previous century, even before it was called HFSQL) I for some reason wanted to change the file extension too. I felt it should be .dat or .dta. As a result back then there were even more problems than youby harvey68 - WinDev Forum
Autor: GuenterP Link zum Beitrag: [27130.foren.mysnip.de] Hi, HCopyFile(..) works just fine if a connection to a differently named directory is opened. But now I have the data in a directory with the "wrong" name. Only thing: I'd have to delete the original directory and rename the newly made directory to that "old" name. However, commands like HDeleteDirecby harvey68 - WinDev Forum
Autor: GuenterP Link zum Beitrag: [27130.foren.mysnip.de] Hi, in order to be able to painlessly switch from HFCS to Classic and back I'm trying to backup a HFCS directory by HCopyFile(..) and copy back these files to the HFCS Server. Using HCopyFile(...) to retrieve the files from the server works just fine, no problem at all. But. Putting those copied files back to the same serby harvey68 - WinDev Forum
Autor: André Labuschagné Link zum Beitrag: [27130.foren.mysnip.de] Hi All I cannot seem to be able to delete a Popup from a page. Are there any tricks I am missing? Cheers Andréby harvey68 - WinDev Forum
Autor: André Labuschagné Link zum Beitrag: [27130.foren.mysnip.de] Hi Fabrice That was a typo - well spotted. When testing the data source did contain records. I must be doing something strange or not understanding the concept at all. I never did get it to work. I may revisit this later. I have solved the problem with a structured array and the page loads instantly. There isby harvey68 - WinDev Forum
Autor: Fabrice Harari Link zum Beitrag: [27130.foren.mysnip.de] Hi Coming late to the discussion, but I see something VERY strnge in your original code... Your wrote : IF HExecuteSQLQuery(dsMyDataSource,MyConnection,hQueryWithoutCorrection,sSqlStatement) = False HReadSeekFirst(dsMyDataSource,MyField,"12345" IF HFound(dsMyDataSource) = True THEN HNextby harvey68 - WinDev Forum
Autor: André Labuschagné Link zum Beitrag: [27130.foren.mysnip.de] Thanks DW - will have a look at that approach.by harvey68 - WinDev Forum
Autor: DW Link zum Beitrag: [27130.foren.mysnip.de] Hello Andre Don't know if this will help but you should be able to query both tables with the relation and only have to loop thru 1 data source. I use this code to open 2 external files read them get what I need then close them. Example: // The "sSONo" is a parameter passed to this code. //Data source of files nby harvey68 - WinDev Forum
Autor: André Labuschagné Link zum Beitrag: [27130.foren.mysnip.de] Hi Paulo You wrote: sSqlStatement is string= "select * from myfile where MyField="+you_var This is what I have been doing. I want to speed it up. Let me describe what I am doing: 1. Load from table A into data source A 2. Load from table B into data source B 3. Data source A and B share a coby harvey68 - WinDev Forum
Autor: André Labuschagné Link zum Beitrag: [27130.foren.mysnip.de] Hi Peter Thanks for that - I still get the error. All I am wanting to do is load the records for table A into a data source and then retrieve a specific record from the data source depending on criteria in another data source. I am just wanting to find a specific record in the data source and get it into a buffer.by harvey68 - WinDev Forum
Autor: Paulo Oliveira Link zum Beitrag: [27130.foren.mysnip.de] Andre, If you use your code change the HNEXT to HREADNEXT. For performance you should use: dsMyDataSource Your_var is int=12345 sSqlStatement = "select * from myfile where MyField="+you_var IF HExecuteSQLQuery(dsMyDataSource,MyConnection,hQueryWithoutCorrection,sSqlStatement) then HreadFirst(dsMyDataSourceby harvey68 - WinDev Forum
Autor: Peter Holemans Link zum Beitrag: [27130.foren.mysnip.de] Hi André, You're using the wrong keyword (hReadSeekFirst instead of hReadSeek, hNext instead of hReadNext). It should be: IF HExecuteSQLQuery(dsMyDataSource,MyConnection,hQueryWithoutCorrection,sSqlStatement) THEN HReadSeek(dsMyDataSource,MyField,"12345") WHILE HFound(dsMyDataSource) Trace(dby harvey68 - WinDev Forum
Autor: André Labuschagné Link zum Beitrag: [27130.foren.mysnip.de] Hi Darren I am back onto trying to get this to work: dsMyDataSource sSqlStatement = "select * from myfile;" IF HExecuteSQLQuery(dsMyDataSource,MyConnection,hQueryWithoutCorrection,sSqlStatement) = False HReadSeekFirst(dsMyDataSource,MyField,"12345") IF HFound(dsMyDataSource) = True THby harvey68 - WinDev Forum
Autor: Arie Link zum Beitrag: [27130.foren.mysnip.de] Hi, the JSONToVariant() function is your friendby harvey68 - WinDev Forum