…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]] On Behalf Of Stephen Markson Sent: February-27-17 9:38 AM To: [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]. For more options, visit https://groups.google.com/d/optout.
