Recent content by KennyAround

Platform: Linux Language: Progress ABL It's about night report batches. There is a dynamically generated price file. It will be used by all the reports generated that night. My question is, is it possible to store the prices in a temp-table (to something to that effect) and share it across all...

OpenEdge 11.5.1 Linux define variable hQuery as handle no-undo. hQuery:set-buffers(BUFFER custom:HANDLE). hQuery:query-open(). . . . delete object hQuery. My question here is, after the "delete hQuery" command, does the buffer itself remain in memory or cleared? I ask this question...

I got it resolved somehow. Thanks guys. The file size is about 100 MB to 200 MB each. solution: define stream sBranchA. define stream sBranchB. define var cFile as char extent 20 no-undo. define var cName as char extent 2 no-undo. define var i as int no-undo. define var j as int no-undo. /*...

Progress Version: 11.x Progress Platform: Linux, character based Windows: Windows 8 I am using character based ABL. I have 2 branches of the company, I need to create 10 outputs for each branch for data in the past 10 years with 1 file for 1 year's data. I thus need to output files to 20...

Platform: Linux Version: 11.3 Text-based ABL I have a question. Does LINE-COUNT() only work for paged streams? Is there a built-in function keeping track of non-paged streams?

You are right. Changing the data type doesn't seem to be the way to go. Thanks very much.

The figures exceeded 50 digits. We have a package for our clients to use, they don't use the system correctly but refuse to change their practice. For example, they scale up all kind of rates, say, if the rate is 65.1245, it will be scaled up to 651245 in the database. If the amount is...

Platform: Linux Version: 10.1B I have a report summation which the decimal data type doesn't seem to be able to accomodate. Does Progress have a data type larger than "Decimal" ?

Ok, I understand what you meant to say now. You are right, if you mean that it has nothing to do with the use of "FOR order-control" as long as it is a transaction block then the scope of order-control will last through the block, the "FOR order-control" is just making it more precise. Then you...

I actually tested that. the "DO FOR order-control" followed by "find order-control exclusive-lock" will actually lock the record till the end of the transaction block, which is not what is expected as concurrent programs are using share-lock to request for the same record. order-control is a...

That depends. If the update block is to update the order-control table then "DO FOR order-control" can be used. However in my case, the update block is designated for the updating of the ORDER and ORDER-LINE tables, not the order-control table. So extending the scope of order-control actually...

Thanks. You are right. I consider that the bad coding practice of the ex-programmer who wrote the code. The "DO FOR order-control" shouldn't be used here, as the UpdateNo isn't strictly needed to be sequential. I asked simply because I am curious about what would happen during a rollback.

Thanks. It seems that I found where the problem is, DO FOR order-control TRANSACTION: FIND FIRST order-control EXCLUSIVE-LOCK. vUpdateNo = order-control.UpdateNo + 1. order-control.UpdateNo = vUpdateNo. FOR EACH ORDER EXCLUSIVE-LOCK where.... , EACH ORDER-LINE...

Progress: 10.2B Backend: Linux Frontend: Windows client A table lock is reported in the Appserver. I wonder if this is the cause of the problem, DO FOR order-control TRANSACTION: END. where order-control is a control table having only a single record for parameters used in order...

Thanks, will try this out.