Recent content by PatrickTingen

The best way to handle include files is to burn them with fire. Kill them first and tear them in pieces. Just to be sure ☠ Include files are super handy, but nowadays mostly for temp-table / dataset definitions so you have one definition that is used when using tt / ds as parameter. Using...

In the meantime I got an answer from Sil Boydens on discord to use the native .net libraries for http connections since that one uses the windows cert store instead of he OE certs folder. This works as a charm, see below for some code METHOD PUBLIC DataDumper sendData(): /* Stuur via...

On our 11.7 server we try to connect to an api that runs on another server, but we encounter this error: Secure Socket Layer (SSL) failure. error code -54: self signed certificate in certificate chain: for aff19c05.0 in c:\dlc11.7\certs (9318) To resolve this, we opened a browser, navigated...

This is what chatgpt came up with:

I would love to see some screenshots if you have a more or less stable example...

You could combine functions in one button with an arrow on the right side of the button, giving the user a choice in copying just the top record or the whole collection, something along this lines: A second option would be to pop up a context menu with the separate options. I do this in...

Oof, that's a good question. This is probably done when something in production went wrong. Find the problem, find a solution, implement and go on and if it works, don't look back. If WinExec gives less overhead or is better in any way, I can replace it

Yes! That works indeed. The below pulls the data over without errors, thanks @Stefan ! /* File : c:\temp\showData.p */ DEFINE TEMP-TABLE ttData FIELD cKey AS CHARACTER FIELD cValue AS CHARACTER. DEFINE DATASET dsData FOR ttData. DEFINE VARIABLE hDataSet AS HANDLE NO-UNDO. RUN...

One addition: my "problem" is that I want to loosen the call to the server and make it possible to update the dataset in two steps. Since a lot of code is operation-critical I don't like the idea of changing that to dynamic handling of the dataset contents, so I'd like to keep a static dataset...

In our codebase we have a dataset as a bridge between two different systems. Data is passed via an appserver call. When we want to add new fields or tables to the dataset, we need to change it on both sides in order to avoid errors like this: Changing both sides while business is running is...

Starting something via OS-COMMAND is a real pain. I used to generate a batch file and then start that, but now I use this: /*----------------------------------------------------------------------- File : startSession.p Desc : Start a new session PARAMETERS: - pcProgram : The startup...

I don't think it is possible. A workaround might be to use &IF and then do a normal MESSAGE VIEW-AS ALERT-BOX &IF DEFINED(UIB_IS_RUNNING) = 0 &THEN MESSAGE 'Hello world' VIEW-AS ALERT-BOX INFORMATION BUTTONS OK. &ENDIF

Haha, every now and then its good to have a reality check. That was your 1st point on the list. Our db server indeed has enough memory to keep the complete db in memory. Our buffer hit ratio is constantly 100%, no matter what we do. Even during our data purge where we read the oldest records, we...

I didn't even know the -csoutput flag existed at all, let alone that is supported in 11.7 :) I know, I have some scripts lying around that I created back in 2003 to replicate a database purely based on AI extents. It's not that hard to do and I mentioned it more than once, but "not needed"...

Yes, see attached zip