Thanks all, After incorporating the following changes, 1. Wrote a single query, combining multiple queries using UNION ALL 2. Converted into a single TableAddLine command, as suggested by AI. the report takes 10 seconds ( 6 sec for query execution and 4 seconds for TableAddLine).. This performance is from second time onwards and it takes around 15 minutes if we run the report for tby sivakrith - WinDev Forum
Hello, Another issue. TableAddLine returns 1 when we execute the query a second time, without leaving the window. It was working with a delay earlier. What we changed is to put some info statements in between to check the processing. Now we see that TableAddLine always returns one. And the execution never completes [ waited for 4 minutes ] Happiness Always BKR Sivaprakashby sivakrith - WinDev Forum
Hello, Thanks All for your reply. AI: I don't think the code executes TableAddLine 20 times. It executes TableAddLine 1 time and set 20 columns value. Here is the full code. FOR EACH sdQuery nRow = TableAddLine(Table_Ledger) IF Combo_AltLanguage = "Y" THEN Table_Ledger.COL_AccountName = sdQuery.accountnametamil Table_Ledger.COL_AccountNarration = sdQuby sivakrith - WinDev Forum
Thanks AI. 1. Yes the content option is set to Programming and all the table columns have NO link. 2. Our code to add columns. Adding around 8655 rows to this table. bQueryResult = HExecuteSQLQuery(sdQuery, a360_DataBaseConnection, hQueryWithoutCorrection, ls_select) IF bQueryResult THEN HReadFirst(sdQuery) IF HOut(sdQuery) = False THEN FOR EACH sdQuery nRow = TableAddLiby sivakrith - WinDev Forum
Hello, Using Windev 22, HFSQL Classic I add rows to a Table using TableAddLine after executing a query using HExecuteSQLQuery. Query Execution is fast, but adding the resultant rows is slow. 1. I delete all rows in the Table, using TableDeleteAll (takes few milliseconds) 2. Construct and Execute the query using HExecuteSQLQuery (tables few milliseconds) 3. Add rows usingby sivakrith - WinDev Forum
Thanks AI. Good points which I will try to implement in other conditions. For my this requirement, I need to provide a way to enter what the user likes, no issues misspellings and duplicates here. I need way to select from lookup or enter whatever rubbish he likes, in the same column.by sivakrith - WinDev Forum
Hello, Windev 22 I want a combo box facility, where I can select data from, if I want, else I can type whatever is required there. Is this possible in WIndev 22? Eg. For a column, there is a lookup file where user will a list of predefined ones. In transaction screens, user will either choose one from the lookup file else type what he requires there. a sort of Combo + Text column. Iby sivakrith - WinDev Forum
Hello, When I generate barcode (QRCode) and save it in png format, I get white space around the image, which is not required. Is there any way that I can save the image alone without white space around it? Happiness Always BKR Sivaprakashby sivakrith - WinDev Forum
Thanks, Guenter Predl, Vassilis Boutsikas. Tab1 = 1 is working. Guenter, I was going through the same help page that you have sent. Somehow it didn't click me this syntax though I tried various combinations. Thanks.by sivakrith - WinDev Forum
Hello, Using Windev 22 In a window, there are about 4 tab panes in a tab control. When I open the window for the first time, I see the control inside the first tab panes. OK, that's perfect. After entering data (and of course, saving the data), in all the 4 tab panes I want to make the first tab-pane to be 'active' or 'visible', so that through a code in someby sivakrith - WinDev Forum
Found the issue. It's spacing between the two columns in design mode. If the space is too small It gets overlapped. Moving the next column down makes things perfect. It's working. The only thing is we see some more space between those two columns in print.by sivakrith - WinDev Forum
Thanks, Arie, When I did a test report with just 3 fields, making the 2nd one multiline, it's working. Now I need to re-work my report and see which control(s) prevents things to move down. I'll try and let u know. Happiness Always BKR Sivaprakash I've attached the overlapping report's image here.by sivakrith - WinDev Forum
Thanks, Guenter Predl, Arie. As Arie said, If I do that will it push other controls down that single Text control(s)? When I tried it's overlapping, as the next control is not pushed down. The address is top in the Page header band, and we have a lot of other data to be displayed in the page header band apart from the Address. When the address got more than one line, with the auto-by sivakrith - WinDev Forum
Hello Using Windev 22 In reports, I want every fields to slide up so that there won't be any blank lines in between? Is it possible? Say if in address field(s) of a customer got three lines, the third line may be empty for few customers. In those circumstances there will be a blank line for the third line of address. I want the blank line not to be there, by moving up all fieldsby sivakrith - WinDev Forum
Hello, The below code worked for me ldUTCDateTime, ldLocalDateTime is DateTime cMyRequest is httpRequest cMyResponse is httpResponse cMyRequest..URL = ls_URL cMyResponse = HTTPSend(cMyRequest) lsDate is string = cMyResponse.Header["Date"] ldUTCDateTime = Middle(lsDate,13,4) + SP_Get_MonthNumber(Middle(lsDate,9,3)) + Middle(lsDate,6,2) + Middle(lsDate,18,2) + Middle(lsby sivakrith - WinDev Forum
Hello, Windev 22 Need to read the current date from the internet I use the following functions. ***************************************** ls_url = "; IF InternetConnected() = True THEN lb_httpResult = HTTPRequest(ls_URL) Info(HTTPGetResult(httpHeader)) ELSE Info("HTTP Error connecting web" + " Result : " + HTTPGetResult()) END *************************by sivakrith - WinDev Forum
Hello, I want to connect to "WbemScripting.SWbemLocator", connect to server " ('.','root\cimv2') ", query it with " Select * from Win32_LogicalDisk' " and read all the properties of hard disk(s) returned. I'm unaware of any OLE workings in Windev, would like to have directions or code snippets to connect and read the values is reby sivakrith - WinDev Forum
Thanks Argus, My bad. Don't know how I missed this part in the help. Thanks.by sivakrith - WinDev Forum
Thanks, AI But this is not working. I get the following error in the line Table_TrialBalanceAsOn.Sort(False) Error:'sort' element not found in 'Table_TrialBalanceAson' element. The other syntax is working fine TableSort(Table_TrialBalanceAson, "COL_SLNo") I add records to Table_trialBalanceAsOn only through nRow = TableAddLine(Table_TrialBalaby sivakrith - WinDev Forum
Hello, Using Windev 22 Searching for a way to disable sort [ eg. TableDisableSort], similar to TableDisableFilter. I add rows to a table, running a query, and adding rows to a table with TableAddLine. Rows get added as the last row. Then I loop through the table, 1. add a few column values, 2. sort it, 3. Display the table as a report Now when I re-run the rby sivakrith - WinDev Forum
Guenter, www.syspredl.com/datafiles/USB_Drive.zip The above tool is not listing connected external SSD harddisk and lists only non-ssd and pendrives in Win 10. In Win 7 it list external ssd hdd. Don't know why external ssd hdd doesn't appear in Win 10. Any idea ? Happiness Always BKR Sivaprakashby sivakrith - WinDev Forum
Hello, I have a nested report within the main report. The nested report is based on the following query *************************** SELECT b.usercode AS usercode, a.totalweight AS totalweight, a.amount AS amount FROM js_transaction_detail a, js_itemwise b WHERE b.itemwisepk = a.itemnamefk AND ( a.companycode = {Paramcompanycode} AND a.brby sivakrith - WinDev Forum
Thanks Guenter, Could you detail, how (&what) to write the line of code? I could see an event named "Resizing the <COLUMNNAME> column, in the code event of that particular column. And I think you mean that only by "whenever resizing the column". I could not imagine what to write to move the position of the total column, for the corresponding column. Any help?by sivakrith - WinDev Forum
Hello, Windev 22, Table Control I display a set of records in a table and created a break in the table to display, totals for the break. In the break footer, I display the total(s) for the required field(s) in the required format. I set the correct field name in the 'Anchor according to column' option in the properties of the total column [ Image file where I set this option isby sivakrith - WinDev Forum
Guenter www.syspredl.com/datafiles/USB_Drive.zip Got a different result when tried with the above code. Toshiba - Returned the same serial number as returned by wmic in Win 10. In Win 7, wmic returned a junk character. WD - returned a different serial number from the one returned by wmic in both Win 7 and Win 10. wmic returned the same serial number in both win 7 and win 10. When wby sivakrith - WinDev Forum
Current result Tried with 2 hdd (Toshiba and WD). Toshiba - returns junk in Win 7 and returns (correct) serial number in Win 10. WD - returns (correct) serial number in both Win 7 and Win 10. Seems there is an issue in Win 7, which was fixed in Win 10. Since Win 7 is not under active maintenance, we could not get the fix, any more, it seems.by sivakrith - WinDev Forum
Thanks Marijan Seems the hdd (Thoshiba) that I tried is not working as expected. I tried with another external hdd (WD), it works perfectly. Not sure why it returns junk characters for the first (Thosiba) hdd. Thanks again.by sivakrith - WinDev Forum
Thanks Guenter, I already tried with USB function, but no success. It returns the serial number of pendrives, not external / internal hdd. Nevertheless I'll check with your code too. Marijan, Tried with wmic get disk drive serial number. It returns internal hdd's serial number, not of external one. I get an error 'invalid xml format' when I attach an external hdd.by sivakrith - WinDev Forum
Hello, If it could not be done with Windev, is there any tool / ActiveX (free / paid) to read unique ID (like Manufacturer serial no ) of an external HDD ? Happiness Always BKR Sivaprakashby sivakrith - WinDev Forum
Hello, Is there any unique Id of an external HDD, like the one available for Pen drives, that won't change even if formatted ? I want to restrict the usaage of windev application to be used only from a particular external HDD only. Any solution ? Happiness Always BKR Sivaprakashby sivakrith - WinDev Forum