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
