(Basics) Read a Record & MV column & verify with Msg (OpenInsight Specific)
At 07 SEP 1998 10:38:46AM Victor Gooch wrote:
I just know this is really stupid but here goes…
I am trying to open a file, read a record then using msg, verify
the contents of a MV column before passing the MV column to
a Popup.
There appears to be no problem opening the table and there is
no problem opening the dict (apparently) or even reading the
record, BUT I can't get msg to report the contents of a MV column and the popup doesn't work so I am getting voids for the column. ??
I have tried Read, ReadO, ReadV then for each have tried assigning @Record to a variable without success. I have also tried opening the dict and using calculate("fieldname") and I have tried using {fieldname} assignments
but in all cases msg reports nothing.
I can't seem to sort out whether this is a failure to (a) read the record (but no errors reported) (b) failure to read a mv column © failure to
show the contents of a mv column using msg or (d) combinations of
the above.
Any thoughts ? Don't spare the punches !
Regards,
Victor Gooch
At 07 SEP 1998 01:33PM Aaron Kaplan wrote:
data=xlate( File, Key, FieldNo, 'X', 2)
Resp=MSG( @Window, data)
The 2 will drop the delimiters down to textmarks so they can appear in the message definition window.
Otherwise,
vals=@record
Convert @VM to @TM in vals
Resp=MSG( @WINDOW, vals)
akaplan@sprezzatura.com
At 07 SEP 1998 03:54PM Victor Gooch wrote:
Aaron,
Thanks for the helpful hints. Looks simpler to xlate as you suggested.
FYI I was using an older 3.1 version that I brought back to 3.6.1 this
afternoon and the same code ran much differently. Many of the
problems that I mentioned disappeared !!!
THANKS for the help. I had just about given up on OI this year due to big-software-company distractions but I kept remembering Cam saying (last year) that he "saw the light" with respect to OI . I have now worked with other ( Access, VB, Java) enough to REALLY appreciate the speed (of development), efficiency, and flexibility of OI by comparison.
Regards,
Victor