As I reported earlier, removing the form variable (vComments NOTE = P_Comments) has solved the problem. Furthermore, the variable is now TEXT and captured on exit with GETPROPERTY.
Thanks to all. Good ideas to store for future workarounds if this gremlin returns. Claudine From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Markson Sent: Monday, February 27, 2017 11:48 AM To: [email protected] Subject: RE: [RBASE-L] - NOTE field …maybe (assuming you don’t want “y umlaut” as the 1st character of your column data): SET V vLike=(CHAR(255)+’%’) SET CASE ON UPDATE Table SET Column = NULL WHERE Column LIKE .vLike SET CASE OFF Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Stephen Markson Sent: February-27-17 9:38 AM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - NOTE field Hi Claudine, Chances are there is some “garbage” in the column. “Y” with an umlaut is CHAR(255) which, I believe, is/was used by R:Base to store a NULL value. So, I would try this: UPDATE Table SET Column = NULL WHERE Column=NULL. If it doesn’t work, you may need to change the WHERE clause to find the offensive rows. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: February-26-17 1:00 AM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - NOTE field Buddy, The NOTE field is a table column. The font may indeed have had something to do with it although neither Arial nor Courier solved the problem. However, I had a form variable defined as NOTE and when I removed it and replaced it with a TEXT variable and a GETPROPERTY command in an exit eep from the field, the garbage disappeared… NULL and character settings are all fine. So, thanks for getting me started looking. Claudine From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Friday, February 24, 2017 7:41 PM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - NOTE field Claudine Is the NOTE field NULL when starting. If so I would look at the font. Is the Note field a column in the table or variable. If a column in the table browse the table and make sure you are on the same row. If a var then show var at the R:>. Also check the NULL and all characters settings. Buddy From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Friday, February 24, 2017 7:43 PM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - NOTE field Hello everyone! This has been baffling me for some time. What AM I doing to create garbage in a Note field before any data is entered? Like this… [cid:[email protected]] TIA, Claudine -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
