Patty:
For years, passive-aggressive hardware engineers have designed AI-driven
"Critical Detector Sensors" into our computers.
This ensures system failure severity increases proportionately with a
user's anxiety about untimely interruption of his/her work.
Stepping beyond the sensor's range (e.g. out for a hot dog) cooled the
sensor and allowed your innocent software to do its job.
Happy to help! : )
Bruce Chitiea
SafeSectors, Inc.
California, USA
909.238.9012 Mobile
------ Original Message ------
Sent: 11/14/2016 7:48:54 AM
Subject: Re: More Re: [RBASE-L] - Can't export any data
From: "'Patti Jakusz' via RBASE-L" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
I stepped outside to buy a hotdog. When I came back, there was a dialog
box asking if I wanted to save Book1 and another to save Book2. So it
did work. I'm not sure why it won't save as the file I designated in
the beginning, but it did work so I'm happy.
Thanks,
Patti
--------------------------------------------------------------------------------
From: Tony IJntema <[email protected]>
To:[email protected]
Sent: Monday, November 14, 2016 10:42 AM
Subject: RE: More Re: [RBASE-L] - Can't export any data
Maybe a workaround, but it works
A couple of week ago I had a big spreadsheet too, which did not work.
Export the file as a CSV and open it with Excel
Tony
From: 'Patti Jakusz' via RBASE-L [mailto:[email protected]]
Sent: maandag 14 november 2016 16:30
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
Have a look at the Help gateway export
For a Workbook it should be: XLSW
Tony
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 Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251
From: 'Patti Jakusz' via RBASE-L [mailto:[email protected]
<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.
