Storing text marks, sub-text marks, etc., in a table (OpenInsight Specific)
At 14 JUL 1999 12:13:23PM Greg James, ISIS, Inc. wrote:
I have a table with a multi-valued column that contains a data string delimited by value marks, sub-value marks, text marks, and sub-text marks. The form that reads/writes to this table contains an invisible edit line bound to the column mentioned above. As a user navigates the form, enters and/or makes changes to the form's contents, the contents of the invisible edit line are updated via Set_Property.
I have noticed that when the record is read, text marks are converted to CR/LFs. When the record is written, the CR/LFs are stored in the record as text marks. Unfortunately, even if no changes are made (to the contents of the form by the user), the SAVEWARN flag gets set because the text marks are being changed to CR/LFs.
I suppose I could use a delimiter other than the text mark, but we need to be able to work with the records in either Arev or OI, and we need to maintain the existing record structure.
Is there a better way to accomplish what I am trying to do? Thanks.
At 14 JUL 1999 12:31PM John Gunther / Bucks vs Bytes wrote:
You can attach event code to SYSMSG to intercept the SAVEWARN message and modify the processing. There's been a lot written, search the discussion using SYSMSG and SAVEWARN.
At 14 JUL 1999 12:36PM John Gunther / Bucks vs Bytes wrote:
Sorry, clicked "Submit" by mistake before finishing (damn mice, anyway)…
Another approach is to swap the text marks in the offending fields to \0D0A\ as a post-read, and swap back as a pre-write. I think this would avoid the SAVEWARN message, but haven't tried it.
At 14 JUL 1999 02:28PM [email protected] wrote:
Greg,
If you know this behavior is happening at read/convert time then you could simply postread set savewarn to null (false?)
[email protected] onmouseover=window.status=imagine … ;return(true)"
David Tod Sigafoos ~ SigSolutions
Cell: 503-341-2983
At 14 JUL 1999 02:35PM [email protected] - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:
What we did was have a global close and clear event which reset focus to another prompt.
At 14 JUL 1999 06:00PM Cameron Revelation wrote:
Greg,
I wrote a KB article on this topic. See Binding multi-value long text columns.
Cameron Purdy
Revelation Software
At 14 JUL 1999 11:26PM Don Bakke wrote:
Greg,
So many people have already weighed in I'm not sure if this will contribute anything…
Are you sure the invisible control is an editline and not an editbox? The latter control will convert @TM's to CR/LF's depending on which property you use to set the text. If you use an editline, I don't believe it matters what property you use.
At 15 JUL 1999 09:46AM Greg James, ISIS, Inc. wrote:
Don,
Yes, it is an edit line. It behaves the same if I set the 'TEXT' or 'INVALUE' property.
At 15 JUL 1999 09:50AM Greg James, ISIS, Inc. wrote:
I used Forward_Event in the form's READ event (I suppose that this is what is meant by post-read processing?) and then swapped the CR/LFs for @TMs and it seems to work OK.
Thanks to everyone for the assistance.
Greg