Thanks, I'll have to come back to this one later.
Regards, Alastair. On 08/02/2017 17:13, Stephen Markson wrote: My comments are based on the current version, 10.0.2.20126. 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 Alastair Burr Sent: February-04-17 6:30 AM To: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - Another question relating to LOAD/UNLOAD Thanks, Unfortunately and despite the help confirming the validity of the syntax I get an error: R>OUTPUT temp.txt ANSI -ERROR- Syntax is incorrect for the command OUTPUT (2045) Example 08: The commands unload the data from the Customer table with ANSI file encoding OUTPUT Customer.dat ANSI UNLOAD DATA FOR Customer OUTPUT SCREEN R>show version R:BASE X, U.S. Version, Build: 10.0.2.11227 (The newer release gives me a problem which I haven't attempted to correct yet, preferring to get known problems sorted first.) Even more puzzled! Regards, Alastair. On 03/02/2017 21:11, Stephen Markson wrote: I can’t replicate your issue. I can tell you that “£” is the UTF8 encoding for “£”, ie CHAR(163). So there must be some setting’s causing this. Try this: OUPUT temp.txt ANSI UNLOAD STRUCTURE FOR whatever OUTPUT SCREEN Then look at temp.txt. 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 Alastair Burr Sent: February-03-17 1:31 PM To: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - Another question relating to LOAD/UNLOAD Thanks, I'm using UNLOAD STRUCTURE just to the screen I tried UNLOAD STRUCTURE ANSI but, not surprisingly, no luck. Regards, Alastair On 03/02/2017 14:48, Stephen Markson wrote: Are you unloading to a file like this? OUTPUT filename UNLOAD… OUTPUT SCREEN If so, try this: OUTPUT filename ANSI This is new syntax to accommodate both ANSI and UTF-8 encoding schemes. 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 Alastair Burr Sent: February-03-17 8:18 AM To: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - Another question relating to LOAD/UNLOAD Thanks - that's actually the way I'm seeing it. In RBENGINEX.CFG it shows as: CURRENCY £ PREFIX 2 B and only £ appears in the Configuration Settings applet. Regards, Alastair. On 03/02/2017 12:59, Mohammed wrote: Try unload structure only separately without data and see Mohammed Sattar Sent from my iPhone On Feb 3, 2017, at 6:06 PM, Alastair Burr <[email protected]<mailto:[email protected]>> wrote: Hopefully an easier one: I noticed and "corrected" the following line in the output files from all my unloads yesterday: SET CURRENCY '£' PREF 2 B which I changed to: SET CURRENCY '£' PREF 2 B but I also noticed that it got changed back in subsequent unloads. Presumably there's an simple explantation? Thanks for any clarity offered, Regards, Alastair. -- 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]<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.
