Patti, two things I noticed and both deal with date. first, what is your date
format set to, your code indicates mm/dd/yy. Normal is mm/dd/yyyy. Second,
you do not need single quotes around the date.
Gary
Sent from my Verizon Wireless 4G LTE smartphone
-------- Original message --------
From: 'Patti Jakusz' via RBASE-L <[email protected]>
Date: 11/14/2016 9:29 AM (GMT-06:00)
To: [email protected]
Subject: Re: More Re: [RBASE-L] - Can't export any data
Oh. It's in help under Export but not under Gateway. I had been looking at
Gateway help.
But I tried it twice and no file was generated.
GATEWAY EXPORT XLSW pjtry35.xlsx SELECT * FROM ParticipantID WHERE
IDO02DAT>'05/01/16' OPTION COL_NAMES ON
Thank you, though.Patti
From: Tony IJntema <[email protected]>
To: [email protected]
Sent: Monday, November 14, 2016 9:39 AM
Subject: RE: More Re: [RBASE-L] - Can't export any data
#yiv9756482919 #yiv9756482919 --
_filtered #yiv9756482919 {panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered #yiv9756482919 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered #yiv9756482919 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered #yiv9756482919 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered #yiv9756482919 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}
_filtered #yiv9756482919 {font-family:HelveticaNeue;panose-1:0 0 0 0 0 0 0 0 0
0;}
#yiv9756482919
#yiv9756482919 p.yiv9756482919MsoNormal, #yiv9756482919
li.yiv9756482919MsoNormal, #yiv9756482919 div.yiv9756482919MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}
#yiv9756482919 a:link, #yiv9756482919 span.yiv9756482919MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv9756482919 a:visited, #yiv9756482919 span.yiv9756482919MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv9756482919 p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919MsoAcetate, #yiv9756482919
li.yiv9756482919MsoAcetate, #yiv9756482919 div.yiv9756482919MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}
#yiv9756482919 p.yiv9756482919msoacetate, #yiv9756482919
li.yiv9756482919msoacetate, #yiv9756482919 div.yiv9756482919msoacetate
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal0, #yiv9756482919
li.yiv9756482919msonormal0, #yiv9756482919 div.yiv9756482919msonormal0
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal, #yiv9756482919
li.yiv9756482919msonormal, #yiv9756482919 div.yiv9756482919msonormal
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msochpdefault, #yiv9756482919
li.yiv9756482919msochpdefault, #yiv9756482919 div.yiv9756482919msochpdefault
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal1, #yiv9756482919
li.yiv9756482919msonormal1, #yiv9756482919 div.yiv9756482919msonormal1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msochpdefault1, #yiv9756482919
li.yiv9756482919msochpdefault1, #yiv9756482919 div.yiv9756482919msochpdefault1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal2, #yiv9756482919
li.yiv9756482919msonormal2, #yiv9756482919 div.yiv9756482919msonormal2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal01, #yiv9756482919
li.yiv9756482919msonormal01, #yiv9756482919 div.yiv9756482919msonormal01
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal3, #yiv9756482919
li.yiv9756482919msonormal3, #yiv9756482919 div.yiv9756482919msonormal3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msochpdefault2, #yiv9756482919
li.yiv9756482919msochpdefault2, #yiv9756482919 div.yiv9756482919msochpdefault2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal11, #yiv9756482919
li.yiv9756482919msonormal11, #yiv9756482919 div.yiv9756482919msonormal11
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msochpdefault11, #yiv9756482919
li.yiv9756482919msochpdefault11, #yiv9756482919 div.yiv9756482919msochpdefault11
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 span.yiv9756482919msohyperlink
{}
#yiv9756482919 span.yiv9756482919msohyperlinkfollowed
{}
#yiv9756482919 span.yiv9756482919balloontextchar
{}
#yiv9756482919 span.yiv9756482919msohyperlink2
{}
#yiv9756482919 span.yiv9756482919msohyperlinkfollowed2
{}
#yiv9756482919 span.yiv9756482919msohyperlink11
{}
#yiv9756482919 span.yiv9756482919msohyperlinkfollowed11
{}
#yiv9756482919 span.yiv9756482919emailstyle1811
{}
#yiv9756482919 span.yiv9756482919emailstyle291
{}
#yiv9756482919 span.yiv9756482919emailstyle301
{}
#yiv9756482919 span.yiv9756482919emailstyle45
{}
#yiv9756482919 span.yiv9756482919emailstyle46
{}
#yiv9756482919 p.yiv9756482919msonormal4, #yiv9756482919
li.yiv9756482919msonormal4, #yiv9756482919 div.yiv9756482919msonormal4
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}
#yiv9756482919 span.yiv9756482919msohyperlink1
{color:blue;text-decoration:underline;}
#yiv9756482919 span.yiv9756482919msohyperlinkfollowed1
{color:purple;text-decoration:underline;}
#yiv9756482919 p.yiv9756482919msoacetate1, #yiv9756482919
li.yiv9756482919msoacetate1, #yiv9756482919 div.yiv9756482919msoacetate1
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}
#yiv9756482919 span.yiv9756482919balloontextchar1
{}
#yiv9756482919 p.yiv9756482919msonormal02, #yiv9756482919
li.yiv9756482919msonormal02, #yiv9756482919 div.yiv9756482919msonormal02
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal5, #yiv9756482919
li.yiv9756482919msonormal5, #yiv9756482919 div.yiv9756482919msonormal5
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msochpdefault3, #yiv9756482919
li.yiv9756482919msochpdefault3, #yiv9756482919 div.yiv9756482919msochpdefault3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal12, #yiv9756482919
li.yiv9756482919msonormal12, #yiv9756482919 div.yiv9756482919msonormal12
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msochpdefault12, #yiv9756482919
li.yiv9756482919msochpdefault12, #yiv9756482919 div.yiv9756482919msochpdefault12
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal21, #yiv9756482919
li.yiv9756482919msonormal21, #yiv9756482919 div.yiv9756482919msonormal21
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal011, #yiv9756482919
li.yiv9756482919msonormal011, #yiv9756482919 div.yiv9756482919msonormal011
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal31, #yiv9756482919
li.yiv9756482919msonormal31, #yiv9756482919 div.yiv9756482919msonormal31
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msochpdefault21, #yiv9756482919
li.yiv9756482919msochpdefault21, #yiv9756482919 div.yiv9756482919msochpdefault21
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msonormal111, #yiv9756482919
li.yiv9756482919msonormal111, #yiv9756482919 div.yiv9756482919msonormal111
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}
#yiv9756482919 p.yiv9756482919msochpdefault111, #yiv9756482919
li.yiv9756482919msochpdefault111, #yiv9756482919
div.yiv9756482919msochpdefault111
{margin-right:0cm;margin-left:0cm;font-size:10.0pt;}
#yiv9756482919 span.yiv9756482919msohyperlink21
{color:blue;text-decoration:underline;}
#yiv9756482919 span.yiv9756482919msohyperlinkfollowed21
{color:purple;text-decoration:underline;}
#yiv9756482919 span.yiv9756482919msohyperlink111
{color:blue;text-decoration:underline;}
#yiv9756482919 span.yiv9756482919msohyperlinkfollowed111
{color:purple;text-decoration:underline;}
#yiv9756482919 span.yiv9756482919emailstyle18111
{color:#1F497D;}
#yiv9756482919 span.yiv9756482919emailstyle2911
{color:windowtext;}
#yiv9756482919 span.yiv9756482919emailstyle3011
{color:windowtext;}
#yiv9756482919 span.yiv9756482919emailstyle451
{color:#1F497D;}
#yiv9756482919 span.yiv9756482919emailstyle461
{color:#1F497D;font-weight:normal;font-style:normal;}
#yiv9756482919 span.yiv9756482919BalloonTextChar
{}
#yiv9756482919 span.yiv9756482919EmailStyle69
{color:#1F497D;font-weight:normal;font-style:normal;}
#yiv9756482919 .yiv9756482919MsoChpDefault
{font-size:10.0pt;}
_filtered #yiv9756482919 {margin:72.0pt 72.0pt 72.0pt 72.0pt;}
#yiv9756482919 div.yiv9756482919WordSection1
{}
#yiv9756482919 Have a look at the Help gateway exportFor a Workbook it should
be: XLSWTony From: 'Patti Jakusz' via RBASE-L
[mailto:[email protected]]
Sent: maandag 14 november 2016 15:19
To: [email protected]
Subject: Re: More Re: [RBASE-L] - Can't export any data I just tried it now
and it didn't give me the correct version of Excel. My table has 433 columns.
If I export using the wizard, I can export it as a workbook in our newest
version of Excel with all the new columns it allows. I tried your statement
with .xlsx extension and it wouldn't open. Said it was the wrong extension.
Thank you, though. Patti From: Stephen Markson <[email protected]>
To: "[email protected]" <[email protected]>
Sent: Thursday, November 10, 2016 1:36 PM
Subject: RE: More Re: [RBASE-L] - Can't export any data Did you try this,
Patti? GATEWAY EXPORT XLS pjtry30.xls SELECT… FROM ParticipantID WHERE (your
where clause) OPTION COL_NAMES ON In the SELECT clause you can use alternate
column names, e.g.… ,IDO02DAT AS `IDO 2 Date`, … Regards, Stephen MarksonThe
Pharmacy Examining Board of Canada416.979.2431 x251 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.
