That wouldn't have occurred to me to suggest! Karen
-----Original Message----- From: 'Patti Jakusz' via RBASE-L <[email protected]> To: rbase-l <[email protected]> Sent: Tue, Nov 8, 2016 1:51 pm Subject: Re: [RBASE-L] - Can't export any data OMG! I changed the date format and didn't change it in my where clause. Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! From: 'Patti Jakusz' via RBASE-L <[email protected]> To: "[email protected]" <[email protected]> Sent: Tuesday, November 8, 2016 2:49 PM Subject: Re: [RBASE-L] - Can't export any data 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 <[email protected]> To: [email protected] Sent: Tuesday, November 8, 2016 2:45 PM Subject: Re: [RBASE-L] - Can't export any data 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 <[email protected]> To: rbase-l <[email protected]> Sent: Tue, Nov 8, 2016 1:36 pm Subject: Re: [RBASE-L] - Can't export any data I'm not using the Wizard, but I am using the Gateway interface screen. I tried to use the wizard, but there's no option for CSV files in it. I attached a snip of the screen. Maybe there's a time limit on Gateway and I have to buy the new version of Rbase??? Patti From: Javier Valencia <[email protected]> To: [email protected] Sent: Tuesday, November 8, 2016 2:25 PM Subject: RE: [RBASE-L] - Can't export any data 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: 'Patti Jakusz' via RBASE-L [mailto:[email protected]] Sent: Tuesday, November 08, 2016 1:20 PM To: [email protected] Subject: [RBASE-L] - Can't export any data 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 FFFFFFF7 I sometimes get a 4KB file created, and if I click on it I get a messages that says "Do you want to save changes to Book1?" But no data shows up. This morning, when I tried, it would go through all 4000 records and then give me the error. Now I get the error immediately. When I try to export to a CSV file, I get the hourglass spinner thing for a while and then it stops. When I open the file it created, all I see are column headings. So I tried my laptop. I first exported into a CSV file and it was working - but I realized I forgot to change my date settings. So I cancelled the operation and started again. Now it won't work. I get the same results as when I tried it on the office PC - an hourglass then nothing but a file with column headings. I tried exporting to Excel on the laptop and I get the exact same error message as I did on the office pc. So I tried someone else's computer at work and it still wouldn't export. I replaced the database with a copy I had on a flashdrive and it didn't work. I have to get these files exported. I'm running out of ideas. The table has too many columns to use anything other formats. Can anyone figure out what is wrong? Thanks, Patti -- 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. -- 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. -- 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. -- 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. -- 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. -- 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. -- 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.
