Search results

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.

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?

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.

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.

Is it possible to store a json file into master-child temp-tables. I wish to store the comma separated list in the child table as separate records { "dsPrRateValueUpload":{ "ttUploadRateValues":[ { "valuelist":[ "1,10,no,17,398"...