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
