Hans, Time to download the latest command reference PDF from RBase and print it. So much has been added/changed since v5.5.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ----- Original Message ---- From: Doug Hamilton <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Friday, December 19, 2008 4:36:24 PM Subject: [RBASE-L] - RE: Weekly imports with date Also, the Windows functionality of Shift and Ctrl works with the F3 Data Dictionary key. If you click a column name and Shift-Click another column name, all columns in between will be selected. Click OK and they will all be pasted. You can Ctrl-Click columns to select multiple, non-contiguous colmns. Doug Hans Manhave/Jackson-Lloyd wrote: >Thank you, I have seen the F3 result, but do not think I used it that way. >I must say 'WOW'. That is too cool, enormous time saver. > >The .#DATE * was my attempt not to have to list all the fields after the >.#DATE. > >I spend my evenings reading the printed R:Base 5.5 reference manual in an >attempt to revive my knowledge. > >This is a great software, development environment and I learn lots from >reading the e-mails. I hope to attend a training seminar in 2009. > >Hans > >-----Original Message----- >From: [email protected] [mailto:[email protected]] On Behalf Of Ramsour Mike >Sent: Friday, December 19, 2008 2:55 PM >To: RBASE-L Mailing List >Subject: [RBASE-L] - RE: Weekly imports with date > >Hans: > >Have you used the F3 / Data dictionary key? > >When you hit the F3 key one of the tabs is "Columns". Click on the >"Columns" tab. This will display a list of tables, views and attached >tables in the left hand pane. Find your table/view in the left pane and >click on it. The list of columns from the selected table/view will show up >in the right pane. > >Simply click on each column that you want and click OK. The list will be >copied to the R> and to the Windows clipboard which means you can copy the >columns into your program file. > >I'm not sure if you meant to include the "*" after the .#DATE reference. >Otherwise, using the .#DATE reference in the SELECT command will simply put >the current system date in the corresponding column in your table. > >Hope that helps. > >Mike Ramsour > >-----Original Message----- >From: Hans Manhave/Jackson-Lloyd [mailto:[email protected]] >Sent: Friday, December 19, 2008 3:46 PM >To: [email protected] >Subject: [RBASE-L] - RE: Weekly imports with date > >This is good. Is there an easy way to get all 74 of my field names after >the SELECT command? I notice that .#DATE * is not an acceptable syntax. >I guess I could type them all into a text file for reference and copy & >paste them whenever needed, but I thought I'd ask. > >Thanks, > >Hans > >-----Original Message----- >From: [email protected] [mailto:[email protected]] On Behalf Of Ramsour Mike >Sent: Wednesday, December 17, 2008 3:51 PM >To: RBASE-L Mailing List >Subject: [RBASE-L] - RE: Weekly imports with date > > > > >
