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"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.