Search results

@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.

Hi Tom, read-json and write-json was pretty simple to use..created a json format from write-json, with the help of data in the temp-tables. This format was different from the one I originally had. and this could read the data in different tables.

Yes, I am trying to dig out out on how Json Object and Array works. If I simply use read-Json, the store the extent as an array and moreover I do not want to hard code the array as 4

I wanted to store valuelist in a separate table, so that the valuelist given as an array is stored as separate records and not hardcode the extent as 4. The above code helps me in reading the json in a single temp-table (I want to store the valuelist in a separate table and then link both tables...

Thank you Stefan! Is it possible by creating 2 separate temp-tables and a relation between them- define dataset dsPrRateValueUpload for ttUploadRateValues, ttUploadRateValues1 data-relation valuedata for ttUploadRateValues, ttUploadRateValues1 relation-fields(tableId, tableId) nested...