RE: More Re: [RBASE-L] - Can't export any data

2016-11-08 Thread Buddy Walker
Patti Have you tried using the UNLOAD DATA OUT myCSVfile.CSV UNLOAD DATA FOR tablename USI columnList AS CSV WHERE yourWhereClause OUT TERM This won’t give you the Column Names but you can highlight and copy the columNames from the above UNLOAD. Open Excel and then

More Re: [RBASE-L] - Can't export any data

2016-11-08 Thread 'Patti Jakusz' via RBASE-L
I still get the error message, but now I get it 90 minutes later, after it pretended to export everything.Patti From: 'Patti Jakusz' via RBASE-L To: "rbase-l@googlegroups.com" Sent: Tuesday, November 8, 2016 2:58 PM Subject: Re:

Re: [RBASE-L] - Can't export any data

2016-11-08 Thread 'Patti Jakusz' via RBASE-L
Yes, the where clause is fine.  I can try to create another table using it and export the other table.Patti From: karentellef via RBASE-L To: rbase-l@googlegroups.com Sent: Tuesday, November 8, 2016 2:45 PM Subject: Re: [RBASE-L] - Can't export any data

Re: [RBASE-L] - Can't export any data

2016-11-08 Thread karentellef via RBASE-L
Whew, that's some "where" clause!!! Have you tried copy/paste of that where clause and run it from the R> prompt as a "browse"? Do you get all your data up that way? Karen -Original Message- From: 'Patti Jakusz' via RBASE-L To: rbase-l

RE: [RBASE-L] - Can't export any data

2016-11-08 Thread Javier Valencia
Are you using the Gateway Wizard or a command file? If it is the second, maybe you can post the code and we might be able to figure out the issue. I export all the time using both methods without any issues. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From:

[RBASE-L] - Can't export any data

2016-11-08 Thread 'Patti Jakusz' via RBASE-L
Hello, I'm still using RBase 9.5 extreme.  We have Microsoft Office 2013 on the office PC   I get this error message when I try to export to Excel using gateway. Error of Data Export: Access Violation at Address 00405E34 in module 'RGB95_32.exe' Read of address FFF7 I sometimes get a 4KB

Re: [RBASE-L] - Printing opinions?

2016-11-08 Thread karentellef via RBASE-L
Yes I certainly could have a PDF file as a "backup", couldn't I? But I am worried about the issues that you brought up -- whether the PDF will fit properly on the envelope, relying on them to choose the proper tray and orientation, etc Karen -Original Message- From: Dan

Re: [RBASE-L] - Printing opinions?

2016-11-08 Thread Dan Goldberg
You could always do both... Dan Goldberg Lance Camper On Tue, Nov 8, 2016 at 6:44 AM -0800, "karentellef via RBASE-L" > wrote: Yeah, you're probably right about the PDF. The only advantage to that would be that they could search the

Re: [RBASE-L] - Printing opinions?

2016-11-08 Thread karentellef via RBASE-L
Yes, this is a "report". And nope, this issue is not replicable. It could happen anywhere in the 500 envelopes, on any random page. The font is Courier New, so should be okay. GREAT idea on the lastname thing!!! I was thinking of putting the data into a temp table and assigning an

Re: [RBASE-L] - Printing opinions?

2016-11-08 Thread karentellef via RBASE-L
Yeah, you're probably right about the PDF. The only advantage to that would be that they could search the PDF for the pages they are missing and reprint (but chances are for an envelope or two they would just type them manually) Karen -Original Message- From: Bill Downall

RE: [RBASE-L] - Printing opinions?

2016-11-08 Thread Dan Goldberg
It sounds like a printer issue. Even if the printer memory gets full the windows queue will hold it until it has freed up some memory to take more. PDF’s can be tricky, especially with items that need to print inside of preprinted docs. You need to select actual size instead of fit or it will

RE: [RBASE-L] - Printing opinions?

2016-11-08 Thread Buddy Walker
Karen I’m assuming this is a report. If it is the same address messing up and the report was upgraded and not re-done check the font size. If it was re-done or even it wasn’t then print by Last name Instead of sending 500 individual print statements try changing/add the WHERE

Re: [RBASE-L] - Printing opinions?

2016-11-08 Thread Bill Downall
And a 500 page PDF will overwhelm printer memory just as easily as a 500 page pcl stream. Bill On Tue, Nov 8, 2016 at 9:16 AM, Bill Downall wrote: > I think you have a good solution. Once you have the cursor set up, it will > be little effort to create and adjust a timing loop

Re: [RBASE-L] - Printing opinions?

2016-11-08 Thread Bill Downall
I think you have a good solution. Once you have the cursor set up, it will be little effort to create and adjust a timing loop to wait for the printer to catch up. A new printer, with a lot of memory and nice envelope handling, would probably cost little more than the time they would pay you for.

[RBASE-L] - Capturing a shift + tab key combination

2016-11-08 Thread Hodges, Dennis
How can I capture a shift+tab keystroke combination in n EEP? Dennis Hodges Maintenance Management Manager FDOT Office of Maintenance MS #52 PH: (850) 410-5635 FAX: (850) 410-5511 dennis.hod...@dot.state.fl.us "You don't stop laughing when you grow old, you