Recent content by Latika6

@TomBascom , Thank you for the above query - Dynamic query explained in an easy to understand manner. I think, I am going beyond the scope of this post, I am tempted to ask another question here. I have to implement this with the help of dataset. and I do not clearly understand the role of a...

I think, I can explain the problem better having worked on it for the last two weeks. If the dashboard shows number, name, date, create-date, price, they go as fields on the temp-table as shown in one of my messages(#7) on this post. So, if an extra column is required on the dashboard, that will...

Hello @TomBascom, the reason is that when the user says I would like the see 'new field' on the dashboard, we do not need a programmer to add this to the temp table, we can just create a new record and the dashboard routine will pull the data in. Therefore, we do not need to wait for a release...

An example is- define temp-table ttQuote no-undo field quote-date as date field risk as character field client-name as character field address as character field product-code as character field risk-num...

I mean that temp-table is being removed. Instead, a table to database is added having the same fields as temp-table. my screen (used for display) and its queries, still use the temp-table as defined earlier. Now, I intend to remove the temp-table and have it as a database table.

Hello Stefan, could you please tell me what you mean by "why not just rename the temp-table and put it in its own namespace?" At the moment, I have a define temp-table in my program and all queries use the temp-table. Now the temp-table is in the database like any other table.

I have to replace static temp-table with a dynamic temp-table in my application because the table will now exist in the database. My question is- Do I now need to replace all the static queries with dynamic queries. I mostly work with static queries.

if we are not using dynamic query, will a static query with if condition cause the query to run slow? I can probably split it into two static queries?

open query query1 for <tablename> no-lock where <table.field1> = x and ( if var1 = 0 then field2 = y1 else field3 = y2) In order to build a where clause there is an if..then. with the where clause. Will this cause the query to run slow?

Progress version is 12.2.4 and OS Windows 11 PRO. Yes, I found errors in the pasname.agent.log saying that a program called by startup procedure was not found. I have removed my db change that involved creating a primary index on a table with few records and dropping the existing one also...

Also, looked at the logs for PAS and there is a startuperrors.txt with errors as- MSAS csMtAdjustSessionCounts : UNDERFLOW error incrementing user session count: user_sessions= 0 incr_user_sessions= -1" and a few more MSAS messages

I need to start databases and PAS to run my application. The application has a .Net front end. I added a field to a table as well as index. After making the change the PAS was not running. Although, rest of the services are running including the databases. The error that I get when I try to...

I have made a schema change in one of the tables by adding a field and creating primary index. PAS is not running now. I have tried idxbuilt and repair the database and that was successful. Any pointers are appreciated.

An update why PAS did not start - I had to install some telerik controls after which PAS started. AS we know the Logs are not very helpful but they were complaining about a few .p's and installing the Telerik controls and compiling the .p's again solved the problem.

I changed my network. PASOE does not start now, the databases, admin server and name server have started. Can someone help me with this one please. I am on OE 12 Windows10.