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
