Your suggestion of trying the where clause is what did it though. I copied
that from something I was doing earlier so I knew it worked. But I always have
to change the date format when I export into excel and I forgot about doing it
in the where clause too.
Patti
From: karentellef via RBASE-L <[email protected]>
To: [email protected]
Sent: Tuesday, November 8, 2016 2:53 PM
Subject: Re: [RBASE-L] - Can't export any data
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
#yiv4838096150 #yiv4838096150AOLMsgPart_2_ffa84a30-1455-4922-8233-b407ebba0bff
td{color:black;}#yiv4838096150 .yiv4838096150aolReplacedBody
#yiv4838096150AOLMsgPart_1.yiv4838096150_49adb3eb-2df8-4fb3-9ea8-abad8702b7df
td{color:black;}#yiv4838096150 .yiv4838096150aolReplacedBody
.yiv4838096150aolReplacedBody -- filtered {font-family:Calibri;panose-1:2 15 5
2 2 2 4 3 2 4;}#yiv4838096150 .yiv4838096150aolReplacedBody
.yiv4838096150aolReplacedBody filtered {font-family:Tahoma;panose-1:2 11 6 4 3
5 4 4 2 4;}#yiv4838096150 .yiv4838096150aolReplacedBody
.yiv4838096150aolReplacedBody filtered {font-family:HelveticaNeue;panose-1:0 0
0 0 0 0 0 0 0 0;}#yiv4838096150 .yiv4838096150aolReplacedBody
.yiv4838096150aolReplacedBody p.yiv4838096150MsoNormal, #yiv4838096150
.yiv4838096150aolReplacedBody .yiv4838096150aolReplacedBody
li.yiv4838096150MsoNormal, #yiv4838096150 .yiv4838096150aolReplacedBody
.yiv4838096150aolReplacedBody div.yiv4838096150MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4838096150
.yiv4838096150aolReplacedBody .yiv4838096150aolReplacedBody a:link,
#yiv4838096150 .yiv4838096150aolReplacedBody .yiv4838096150aolReplacedBody
span.yiv4838096150MsoHyperlink
{color:blue;text-decoration:underline;}#yiv4838096150
.yiv4838096150aolReplacedBody .yiv4838096150aolReplacedBody a:visited,
#yiv4838096150 .yiv4838096150aolReplacedBody .yiv4838096150aolReplacedBody
span.yiv4838096150MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv4838096150
.yiv4838096150aolReplacedBody .yiv4838096150aolReplacedBody p
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv4838096150
.yiv4838096150aolReplacedBody .yiv4838096150aolReplacedBody
span.yiv4838096150EmailStyle18 {color:#1F497D;}#yiv4838096150
.yiv4838096150aolReplacedBody .yiv4838096150aolReplacedBody
span.yiv4838096150SpellE {}#yiv4838096150 .yiv4838096150aolReplacedBody
.yiv4838096150aolReplacedBody .yiv4838096150MsoChpDefault
{font-size:10.0pt;}#yiv4838096150 .yiv4838096150aolReplacedBody
.yiv4838096150aolReplacedBody filtered {margin:1.0in 1.0in 1.0in
1.0in;}#yiv4838096150 .yiv4838096150aolReplacedBody
.yiv4838096150aolReplacedBody div.yiv4838096150WordSection1 {}#yiv4838096150
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,
PEO: 913-829-0888H: 913-397-9605C: 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.
--
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.
