In my company we use LDAP in order to use SSO (Single-Sign-On) to access our ERP software.

Is it possible that the client can choose the apllication server (PASOE) agent to connect?
I want to hold data for specific groups of clients to reduce db requests.

I am trying to pass multiple input parameters using prowin32 . But i am not able to find out the way of passing multiple parameters.

I am new to progress 4GL and want to know how to write a query which parse below json file and store it into temp table.

I have a custom table which has no trigger events for write. I could sense some of the data often modified from particular fields but not sure what is the exact fields in table. Is there way to track or check the table fields affecting during assignment? I understand protop can give us some info but I would like to have a small query which helps to identify fields. Thanks in advance

I am getting below error after dump and load data from a table(int32) to the same table(int64) and run the program. Any Idea how to solve this?

From below query I have given all the components for index vdmod_idx1. But when I checked XREF, I can see the compiler choose vdlist since it is primary unique. May I know why it is behaving like this. I would like to know what’s happening here

I have a below simple query which causes a performance issue. a table xxdata has huge records and it’s getting often hits based on total records available in table xxfin.(i.e Available records 1000 in table xxfin, then 1000 times hits table xxdata).

From below query, a table tdfmstr uses two indexes and conditions added (All conditions are mandatory). After the compilation, I checked XREF of the query. I could see compiler chose 2 indexes opvdor and opsellord.

I understand FIELDS option allows you to explicitly specify the fields we want to work with, which can be useful for optimizing performance and reducing unnecessary processing. It’s particularly handy when dealing with large records.