Search results

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.

True enough ... but testable. I just think that people forget about work-tables these days, but they are a good fit for some use cases.

By the same token, if the above satisfies your need, you could use a WORK-TABLE instead of a TEMP-TABLE.

Did you try just Break by Col1 by Col9 Why are you breaking on all of those columns?

Oh, and there is no trademark symbol in ibm850 either. https://en.wikipedia.org/wiki/Code_page_850

8859-1 has no trademark symbol ... which might be contributing to your problem. I suggest you dump that record and look at what is in it with a hex editor. I am also curious about what you are doing in that code. You initialize trademark as "(ä)". This is three valid characters in 8859-1...