Recent content by PatrickTingen

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

What we want to improve is "performance". Now since that is a wide term, we are not facing an actual problem, at least not that we know, but I am just wondering whether our configuration could be much better than what it is now. If we could speed up the application that would benefit our users...

Thanks for all of your feedback. Today we ran the data purge during normal business hours. Because: why not, yolo! Our db server did not give a single f**k and users did not even notice the purge was running at all. Yes, the RPB column is the theoretical # records/block We might still do that...

We are in the middle of a clean-up of old data in our database, deleting approximately 25-30% of the contents. I ran a tabanalys on the db and noticed that more than half of the tables have very small records, thus not filling up our 8k blocks. Here is a screenshot of some of our offenders...