Using PROJECT I get the same result. The structure does not carry forward the default values. I also projected the table with data and the result was the same. Whilst this doesn't present any problems as UNLOAD achieves what I need, I thought I'd mention it.
"A. Razzak Memon" <[email protected]> Sent by: [email protected] 12/05/2009 03:55 p.m. Please respond to [email protected] To [email protected] (RBASE-L Mailing List) cc Subject [RBASE-L] - Re: Copy table verse unload structure At 01:32 AM 5/12/2009, Tony Luck wrote: >Just for general interest, I need to mirror a table that I use for EDI >file creation as it has a default of " " for blank rows (Instead of >changing quotes and so on I import the data to the table which basically >fills in the blank bits for me saves a ton of time) anyway, coping the >table didn't bring along the defaults, this is a 232 column table and I >didn't want to retype all the default values again. I used unload >structure and when run back into the database , the defaults are all >happily there. Just a point for interest sake incase anyone runs into it. G'day Tony, Just curious ... what result do you get when PROJECTing a table? >(P.S) I am placing my order for 9 eXtreme tomorrow Razzak, I can't stand >the wait anymore !! It will be worth the wait! Very Best R:egards, Razzak. Tony Luck IT / Logistics Manager Tel: +61 7 3866 4902 Fax: +61 7 3857 0031 Mob: +61 420 936 464 Morris / Invacare 6 Armada Place Banyo, QLD 4014 ______________________ ________________________ ____________________________ Wherever life takes you, you can rely on Invacare. Click here to view the NEW-generation mobility scooters... ____________________________________________________________________________ This e-mail is confidential. If it is not intended for you please do not read, distribute or copy it or any attachments. Please notify the sender by return e-mail and delete the original message and any attachments. Any views expressed in this e-mail may be those of the individual sender and may not necessarily reflect the views of Invacare Australia. ____________________________________________________________________________ This e-mail message has been scanned and cleared by MailMarshal at www.invacare.com.au
