RE: [RBASE-L] - ERASE filespec

2017-02-03 Thread Javier Valencia
Hello Claudine, The two options are there for a reason. One option allows you to quickly view the document using the R:Base PDF browser and once you exit, the file is closed. The other option allows you to see the document using Acrobat Reader and it has a lot more option and allows you to

RE: [RBASE-L] - ERASE filespec

2017-02-03 Thread Claudine Robbins
Buddy, et al… and Javier, I think I have figured it out. The files in question are pdfs. I’m using a form Javier created and it has two “viewing” button options for the pdf file being viewed and replaced, one to view in Adobe Reader and one to view in PDF viewer. I wondered about that

[RBASE-L] - DB TreeView - trying to highlight nodes

2017-02-03 Thread Stuart Hellman
I’ve been racking my brain over this one for a while. Would appreciate any and all help. Using a DB TreeView control, I am trying to highlight/position a specific node within the tree. I know my logic is good that gets me the node ID that I want. However when I refresh the table/control, the

RE: [RBASE-L] - ERASE filespec

2017-02-03 Thread Buddy Walker
Claudine As a last resort you could add the following to your code I’m assuming you are running this from R:Base X Buddy *Add to your code** OUTPUT doerasfile.bat WRITE 'DEL' .vfilename2 WRITE 'COPY' .vfilename1 .vfilename2

RE: [RBASE-L] - ERASE filespec

2017-02-03 Thread Claudine Robbins
Nothing works so I’m just going to wait until next Wednesday and see if a new Windows Update isn’t released to fix whatever the problem is. I’m experiencing the same behavior on the cloud server too… From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr

RE: [RBASE-L] - Another question relating to LOAD/UNLOAD

2017-02-03 Thread Stephen Markson
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

Re: [RBASE-L] - Another question relating to LOAD/UNLOAD

2017-02-03 Thread Alastair Burr
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

Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

2017-02-03 Thread Alastair Burr
I had what I hoped might be a brainwave to solve the data type mismatch on this view by forcing my non-column data to the type it needed to be. I amended the view definition to: CREATE VIEW `LiveAlbumsViewTEST` + (DiscIdNum, TrackNumber, Concert_Date, Venue,

RE: [RBASE-L] - Another question relating to LOAD/UNLOAD

2017-02-03 Thread Stephen Markson
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:

Re: [RBASE-L] - Another question relating to LOAD/UNLOAD

2017-02-03 Thread Mohammed
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 wrote: > > Hopefully an easier one: > > I noticed and "corrected" the following line in the output files from all my > unloads

Re: [RBASE-L] - ERASE filespec

2017-02-03 Thread Alastair Burr
I think, "technically" you DELete records from a database and ERASE files from the directory/folder. I usually make sure that I have the DOS command correct and then in R:Base create a variable & activate that: SET VAR vEraseFile TEXT = 'ERASE C:\Temp\*.*' and SET VAR vEraseFile TEXT =

[RBASE-L] - Another question relating to LOAD/UNLOAD

2017-02-03 Thread Alastair Burr
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