I don't know the structure of your DB but if i understand your problem correctly it looks like the problem is in the query. If you don't want duplicate values just use DISTINCT if the queryby pao - WinDev Forum
I have found the problem. The problem was running my app thru RDP, if I run it locally the BurnerList function return data.by pao - WinDev Forum
When i try ot use the BurnerList function in windows 10 the result is always empty. Anyone manage to burn DVD in windows 10 with windev?by pao - WinDev Forum
One windows service can access one remote DB without problems. We use it a lot, we normally use machine for the service and another for the DB and it works well. As i told you i don't know how to make the SSH tunnel. In our case we access the remote DBs using VPN connections and in this cases the firewall makes the IPSEC tunnel, for the service it's transparent.by pao - WinDev Forum
If you can connect to both databases (local and remote) from your windows server just create one service, in your code define two connections (one for the local DB the other for the remote D and use them to read/write the data. You can use the Native PostgreSQL Connector to access the DBs. Regarding the SSH tunnel i don't know if you can create it with windev or if it must be created iby pao - WinDev Forum
In the tools menu of WX you can find thw WDSQL try it to see if it fits your needs.by pao - WinDev Forum
Try using ENCODE/DECODE instead of the crypt/decrypt and use encodeBASE64URL instead of the encodeBASE64by pao - WinDev Forum
did you try with http:://server_name/your_app_nameby pao - WinDev Forum
I'm using datetime for all this type of columns because some of my clients still have mssql 2005.by pao - WinDev Forum
Arie, Is the code you paste here the same used in the your app? Tbl_Users.ModifiedDateTime = DateSys() - TimeSys() If it's the code used in your app is wrong it should be Tbl_Users.ModifiedDateTime = DateSys() + TimeSys()by pao - WinDev Forum
We have done something like that using the result of SysEnvironment("HTTP_HOST") Our site is in windows server 2012R2 and we use the anonymous Autehtication I don't know why you can't get results from SysEnvironment(), are you code in the Initializing the project after connection to the site?by pao - WinDev Forum
Anyone have experience signing PDF files in WINDEV using the CSC API? We use advanced certificates to sign pdf files but after 2020/12/31 the only suported certificates for invoices in Portugal (as far as we know in all the UE as well) are the qualified ones. We don't whant to use USB or smart cards tokens.The only remaining option is to use the Cloud Signature Consortium API as far as weby pao - WinDev Forum
If you need to run the dynamic procedure sevaral times you can use compile, if need to run the code once you can use the ExecuteCode function We use compile/executecode and ControlCreate to generate some forms,reports and queries. With this functions you can do a lot of stuff.by pao - WinDev Forum
Did you check the permissions in the share and in the security? The client app writes one file in the \\servername\Application setup folder\Application name\INSTALL\LOCK folderby pao - WinDev Forum
That user have write permissions in the INSTALL folder and sub-folders?by pao - WinDev Forum
As far as i know you can install mssql express in windows 10 home You can use the "MSSQL native access" (Windev 20) to access the data in the express edition the same way you do for the other editions.by pao - WinDev Forum
Did you try using timer and message functions in the browser code of the page to do someting while waiting Another sugestion is to use timer and AJAXExecuteAsynchronous to get something from the server while waitingby pao - WinDev Forum
The WCG filei s Information for compiling a set of procedures (re-created after each compilation) Did you try to open one procedure inside the GP_Alle set of procedures? Are this set of precedures shared wtih other projects?by pao - WinDev Forum
Yes, the hreadseekfirst opens one connection in the DB engine and it stays open. Hclose is your friend.by pao - WinDev Forum
You can find other example from Michael Drechsel using tracker-software here:by pao - WinDev Forum
In tle LST 93 you can find one example using tesseract. If you don't have the LST try to ask PCSOFT if they can share that.by pao - WinDev Forum
Your problem is the login to MSQLSERVER not in the INSERT. If it's Windows Authentication check the user defined in the schedule task. When you run it manually it uses the user logged in, when in schedule task it uses the user defined to run the task.by pao - WinDev Forum
I changed my program as it looks like zero is the way to go.by pao - WinDev Forum
It's possible to write session cookies in webdev 22? What is the Validity period to use for that? zero? Thanksby pao - WinDev Forum
I don't know what is the list of ciphers and the order for the ftpconnect command but if the ciphers are removed from the server it can't be used by the client software. If they remove the ciphers from the sftp server and leave only the supported ones the only thing you have to test is if you can connect or not. Usually in SFTP algorithms are negotiated during the handshake. Both cby pao - WinDev Forum
If you call your webservice using HTTPS instead of HTTP all the comms are encrypted. If need to encrypt the data itself you must do it by programming.by pao - WinDev Forum
Ok now i think i get it. The problem is with the download of the files and not the generation. The easier way is to generate the two pdf files, put them in one ZIP and FileDisplay of the ZIP instead of the PDFs Other option, generate the two pdf files, merge them in one PDFMerge and FileDisplay of the result fileby pao - WinDev Forum
With the same data? If the data is different your procedure can have some conditions that exits without any result. Just guessing.by pao - WinDev Forum
It looks like your procedure doesn't send any result. Check your procedure to see where it ends.by pao - WinDev Forum