Precisely!

Sensors never sleep. Hope you likes them hot dogs.

Bruce Chitiea
SafeSectors, Inc.
California, USA
909.238.9012 Mobile


------ Original Message ------
Sent: 11/14/2016 8:19:07 AM
Subject: Re: Re[2]: More Re: [RBASE-L] - Can't export any data
From: "'Patti Jakusz' via RBASE-L" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:

LOL.

Is that how, a few weeks ago, the computer knew I was in a hurry and the windows updating message said "This is going to take a while"? The sensors were on extreme alert that day.

Patti



--------------------------------------------------------------------------------
From: Bruce Chitiea <[email protected]>
To:[email protected]
Sent: Monday, November 14, 2016 11:06 AM
Subject: Re[2]: More Re: [RBASE-L] - Can't export any data

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.



--
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.

Reply via email to