Search results

It is there for Rob and I.

No, I was only listing JSON as one of many ways to pass data. In order to make a recommendation of the preferable way to exchange the data, I would have to know more about your actual requirements. I might note that I tend to frown on passing temp-tables regardless. Better to encapsulate them...

For starters, I would recommend that you *not* do big complicated things in constructors. If they fail, you are left with a class that doesn't exist and the error handling is consequently more complicated. Better to initialize the class with a minimal constructor and then use an Initialize...

"Looks like" is not confidence inspiring. One should "know" what will happen.

It is very unclear what you are trying to do or expecting to happen. As Stefan said the USING statement has no function than to allow the use of an unqualified class name in the remaining body of the class. I.e., being able to reference just "base" instead of "ProcedureLibraries.base"...

Never have seen ads, but then I use AdBlock Plus.

Is it even Progress? Hard to imagine someone upgrading in 2020 from 4 to 9.

There are many different answers, depending. Is the time you have a string or a date-time datatype or what. Are you looking for seconds since midnight?

Or better a bcc.

Point being, based on the code you supplied, the error message is reasonable.

In your code, you never set yesno, so it will be false and so you will not have opened the stream.

Tom, what about the wisdom of writing in chunks vs using LOBs?

This is a plus for other uses of substitute as well, e.g., some kind of slice and dice where one could assemble pieces, but it would require additional logic to detect and handle unknown values.

And, to emphasize, if mandatory is not checked, then there can be multiple records all with the same ? value even if the index is marked as unique.

Plus, you need to mark it mandatory since, if it can have multiple null values without violating uniqueness.

Note that one can scope a buffer or transaction to a DO loop, but one has to state it explicitly instead of it being implicit like with REPEAT.

I.e., if you are in a context where you can use SQL-92, you have no temp-tables.

How long until version 3.14159?

More info would be useful as usual. What version of Progress. What license model? Do you have replication? If not, why not? Might it be a solution to run the read-only users on the replicate? If you are refreshing these temp-tables every 5 minutes to have current data for reporting, then...

If you have a top level procedure which is not connected to the DB ... and I am not particularly sympathetic that it is sensible to be so stingy with licenses ... then the usual thing is to connect to the DB and transfer control to a subprocedure since it is only in that subprocedure that the DB...