[RBASE-L] - Still stumped

2017-02-08 Thread Tom Hart
I am going to post this again because I am totally stumped. Very simply I am trying to print a report directly to the printer using an external form as follows: PRINT PR_Testreport OPTION PRINTER return This works fine from R>, but pulls up the Print Preview screen if run from a compiled

Re: [RBASE-L] - Sample Applications: Report Output Options

2017-02-08 Thread Tom Hart
Javier, I have used this compiled rff for years under 95(32) and it has worked fine, since I have upgraded to XE it wont work Tom On Wed, Feb 8, 2017 at 9:10 AM, Javier Valencia < javier.valen...@vtgonline.com> wrote: > Tom, > > > > Are you compiling just the form into an .EXE file and running

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

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

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

2017-02-08 Thread Alastair Burr
Good idea, thanks, I'll give it a go. Regards, Alastair. On 08/02/2017 17:08, Stephen Markson wrote: It’s only my 1.52 cents worth (I’m in Canada), but here it is: Running with COLCHECK OFF is quite alright, but the column mismatch error may be a bit of a red herring. I think the problem might

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

2017-02-08 Thread Stephen Markson
TTBOMK the SYS_COLUMNS table does not have information on view column aliases. This makes sense. Only the view definition (query) is stored in the DB. The view is “executed” only when referenced. The COLCHECKing can only occur when the view query is executed. Why? Because the DB doesn’t know

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

2017-02-08 Thread gary.wend
Are you confusing the output command structure with the unload command? OUTPUT temp.txtUNLOAD ALL FOR table AS ASCIIOUTPUT SCREEN The only option I see for OUTPUT is PDF. Gary Sent from my Verizon, Samsung Galaxy smartphone Original message From: Stephen Markson

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

2017-02-08 Thread Stephen Markson
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: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr Sent: February-04-17 6:30 AM To: rbase-l@googlegroups.com

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

2017-02-08 Thread Stephen Markson
It’s only my 1.52 cents worth (I’m in Canada), but here it is: Running with COLCHECK OFF is quite alright, but the column mismatch error may be a bit of a red herring. I think the problem might be in the processing of the GROUP BY (in the second SELECT of the UNION). If that’s the case and you

RE: [RBASE-L] - Sample Applications: Report Output Options

2017-02-08 Thread Javier Valencia
Tom, Are you compiling just the form into an .EXE file and running it from there? I really have not worked much with .rff files but aren’t they designed to be used before you connect to the database and this is why you cannot have DB controls? Maybe this is what is causing the issue? Have you

Re: [RBASE-L] - Sample Applications: Report Output Options

2017-02-08 Thread Tom Hart
Razz, I tried the exact code you sent and it still pulled up the printer preview Tom Hart On Tue, Feb 7, 2017 at 9:03 PM, A. Razzak Memon wrote: > Tom, > > No worries! > > Here's the code behind the [Continue] button. > > Feel free to reach out to me if you need further help.