Re: [RBASE-L] - gateway export to xlsx

2018-04-05 Thread A. Razzak Memon
Dan, Here's how ... Try the example below using the sample RRBYW19 database. -- Example -- Create XLSX file with Header, Footer, Style and Tab Name -- Author: A. Razzak Memon -- Date Created: April 5, 2018 -- Last Updated: IF (CVAL('DATABASE')) <> 'RRBYW19' OR (CVAL('DATABASE')) IS NULL THEN

RE: [RBASE-L] - gateway export to xlsx

2018-04-05 Thread Buddy Walker
Dan Try changing GATEWAY EXPORT XLS Customers_123.xls to GATEWAY EXPORT XLSW Customers_123.xlsx If you want a small file you could trying exporting to CSV then have Excel open the csv file. Buddy From: rbase-l@googlegroups.com On Behalf Of Dan Goldberg Sent: Thu

[RBASE-L] - gateway export to xlsx

2018-04-05 Thread Dan Goldberg
I am using a command line export to xls like the sample. GATEWAY EXPORT XLS Customers_123.xls + SELECT + Company AS `Company Name`, + CustID AS `Customer ID`, + CustAddress AS `Company Address`, + (CustCity+','&CustState&CustZip) AS `City, State, and Zip Code` + FROM Customer ORDER by Compa

Re: [RBASE-L] - Re: SV: updating many columns in a table

2018-04-05 Thread Albert Berry
Further to John’s note, I suspect that your system, or the university’s system, has spam checking enabled. I had this happen on one account, and the problem was that the spam/spoof checker detected that you had sent yourself the message. The solution is to white list this site. Albert > On Ap

[RBASE-L] - Re: SV: updating many columns in a table

2018-04-05 Thread John Minyo II
Hello Claes-Robert Julander, The spoof warning in the message only appears in email messages that you receive, after sending your message to the list. The warning does not appear in your original post to the list, so you are considered a safe sender to the group. If you wish to investigate

[RBASE-L] - SV: updating many columns in a table

2018-04-05 Thread Claes-Robert Julander
Hallo Bo Nice to hear that there is more than one rbase user in the Stockholm area. Rbase 2.11 - those were the days... All the best Claes- Robert Från: rbase-l@googlegroups.com för Bo Franzén Skickat: den 5 april 2018 10:06:37 Till: rbase-l@googlegroups.com Ämne

[RBASE-L] - SV: updating many columns in a table

2018-04-05 Thread Bo Franzén
Glad to hear Claes-Robert that there are more professionals than me in Stockholm that has been using R:BASE in research since the days of Microrim (remember R:BASE 2.11 Swedish version!). Y s Bo Franzén Department of Economic History Stockholm University Frå

Re: [RBASE-L] - 2018 R:BASE March Madness Promotion

2018-04-05 Thread Gunnar Ekblad
Hell John It has a been long time But now has The timecome to Unsubscribe it did not workshop when i tredje so i hopen That you can assist med onekligen last time Den tis 13 mars 2018 3:15 emJohn Minyo II skrev: > Tuesday, March 13, 2018 > > Dear R:BASE Community, > > R:BASE Technologies has ann

[RBASE-L] - VB: updating many columns in a table

2018-04-05 Thread Claes-Robert Julander
Från: Claes-Robert Julander Skickat: den 3 april 2018 12:25:38 Till: rbase-l@googlegroups.com Ämne: updating many columns in a table Hallo, I used rbase since it was called Microrim, but with long intervals between each usage occasion (all depending on what ty