The expressions are..

patnumbr = .vpnum    (real)
rdate_   = .vdate    (date)
chiefcomp = chiefcomp IN newcc WHERE shortcut = shortcut OR 
  chiefcomp CONTAINS shortcut                                    (text)

Browsing the table directly shows some of the values in the shorcut 
column to be -0-, all other fields are filled with expected values.
The problem occurs when I am using the form, but it appears to be a
"cosmetic" problem...the data appears ok.  In fact, if I use the form
to edit data on one machine, and leave the yyyyy in place, and then go
to another machine on the same LAN and look at the table data directly,
the 
field that has the yyyyy in the form appears as -0- on the second
machine.
Further, if I go back to the first machine, and the cursor is the field
with good data (shortcut), and the yyyyy is in 2nd field (where it is 
supposed to be blank), and I then hit F7 to go up one line, the bad
field
with the yyyy fixes itself (disappear/turns into a blank)!

Any thoughts???

Mike Sinclair



RBTI Customer Support wrote:
> 
> At 09:53 AM 5/25/01, you wrote:
> >Good thoughts, but not the case.  This is new form, created in RBase for
> >Windows, 3 expressions, 2 fields, no picture format stuff, and
> >set blank = ' ' does not make it go away.  It's easy to reproduce.  The
> >1st field is the place where the user enters an abreviation such as
> >"HTN" for hypertension, the 2nd field is a look up field that ends up
> >with the
> >value 'HYPERTENSION'.  If I tab over to the second field, and erase it
> >by just hitting the space bar, and then tab out of the field, the goofy
> >looking yyyyy string is left behind.  The 2 fields are tiered.
> >
> >Any ideas?
> 
> Mike;
> 
> Do the yyyyy characters appear in both fields, or only the one?
> 
> Also, what are your 3 expressions?
> 
> If you browse the table directly, looking at the data that this form is
> calling, how does it appear? Any strange characters in there?
> 
> The ASCII characters must be coming from somewhere because
> R:BASE just won't create them.
> 
> Regards,
> 
> RBTI CUSTOMER SUPPORT

Reply via email to