I believe date is a reserved word that cannot be used for a column name, also, you may wan to put quotes around the dates. Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX
-----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On Behalf Of Farnsworth Midge D Contr 388 RANS/JT3 Sent: Thursday, October 31, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: Moving Tables I am running R:Base 6.5++ for Windows and am having a difficult time trying to combine tables from one database into another database. I went out to the archive list and can't find a way to do it. I have copied forms and reports from one database to another, but can't do tables. I finally resorted to exporting the table from one database into Excel and importing it back to another database in R:base. When I do this, for some reason, it changes the date format somehow and doesn't recognize the date. When you look in the table, the data is there, but when you try browse * from History Where date BETWEEN 01/01/02 AND 10/30/02 it says there are no qualifying rows. Does anyone know how to do this, and what the problem might be with the dates? ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
