[RBASE-L] - SV: R:BASE 11 and R>CONVERT from 10.5

2024-07-29 Thread 'Bo Franzén' via RBASE-L
naming the columns , but I gues this will be solved in an update to come. Bo Franzén Stockholm University ____ Från: 'Bo Franzén' via RBASE-L Skickat: den 29 juli 2024 13:44:24 Till: rbase-l@googlegroups.com Ämne: [RBASE-L] - R:BASE 11 and R>CONVERT f

[RBASE-L] - R:BASE 11 and R>CONVERT from 10.5

2024-07-29 Thread 'Bo Franzén' via RBASE-L
Hi, A little bewildered during the weekend by the new R:BASE 11, that in the directories did not recognise my databases in 10.5. I made R>DIR to be sure that I had browsed to the right place. And then in HELP I found the command R>CONVERT dbname et voilà completely four new R:BASE RX1-4! (But f

SV: SV: [RBASE-L] - Second ORDER BY parameter?

2023-06-22 Thread 'Bo Franzén' via RBASE-L
i 2023 19:38:13 Till: rbase-l@googlegroups.com Ämne: Re: SV: [RBASE-L] - Second ORDER BY parameter? Just a case of not seeing the forest for the trees!! Hope all is well with you Karen -Original Message- From: 'Bo Franzén' via RBASE-L To: rbase-l@googlegroups.com Sent: T

SV: [RBASE-L] - Second ORDER BY parameter?

2023-06-22 Thread 'Bo Franzén' via RBASE-L
;m probably not understanding. Are you asking if you can sort by two columns? Like: ORDER BY commodity ASC, tran_id ASC Karen -Original Message- From: 'Bo Franzén' via RBASE-L To: R:BASE Sent: Thu, Jun 22, 2023 10:47 am Subject: [RBASE-L] - Second ORDER BY parameter

[RBASE-L] - Second ORDER BY parameter?

2023-06-22 Thread 'Bo Franzén' via RBASE-L
Dear R:BASE, I have a coming printed volume with ca 8000 rows with Medieval Swedish commodity prices in (of course) R:BASE. The rows are originally in Swedish alphabetical order and every commodity are sorted in chronological order. All thanks to a unique key, tran_id, where the lower tran_id

[RBASE-L] - SV: UPDATE column with the same column name FROM another table?

2022-07-28 Thread 'Bo Franzén' via RBASE-L
name FROM another table? I am not sure on what column names you want to copy over so you will need to change them below. Update Commoditytab set columnname = t2.columname from Commoditytab t1, johantab t2 where t1.tran_id = t2.tran_id Dan Goldberg From: 'Bo Franzén' via RBASE-L Sent

[RBASE-L] - UPDATE column with the same column name FROM another table?

2022-07-28 Thread 'Bo Franzén' via RBASE-L
Dear R:BASE, I have two tables of Medieval Swedish prices and one of them are for a translation into English since we have decided that the book we are planning should be published in English. While I was translating the eight thousand or so rows I used two variables in my form for (the Engli