At 10:51 AM 6/18/2014, Dr. Fritz Luettgens wrote:
Hi, I hav imported an access-db table into rbase. In the imported table exits a varchar and a datetime column. How can I change varchhar to TEXT and datetime to DATE Any idea helps
Fritz, You can easily convert the VARCHAR data to NOTE data! Here's how: Example: TableA: ColumnA INTEGER ColumnB VARCHAR TableB: ColumnA INTEGER ColumnC NOTE Routine to convert VARCHAR to NOTE Field: INSERT INTO TableB (ColumnA, ColumnC) SELECT ColumnA, ColumnB FROM TableA The resulting ColumnC in TableB will include the converted VARCHAR to NOTE. That's all there is to it! In reference to converting DateTime to DATE, use (DEXTRACT(datetime)) function to achieve your goal. Feel free to reach out to me with any questions. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
