Search results

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

Put the temp-table in a persistent procedure or class and provide methods to operate on it. Much cleaner.

There is a Syteline forum.

And, it should be noted that a transaction *is* active and anything you do inside that block *will* get undone if the transaction is not completed. You may not see this because there is no permanent record, but any undo variables, for example, will be returned to their starting state.

Related to this? Credit card payments not working

What is not accomplished by assigning the trimmed value to the database field?

Note also that the DECIMALS property of the field will determine how many decimals to the right can be assigned, regardless of the display format.

New Member .... ???

This is clearly a question about a specific software product. You should post it in the corresponding board.