Vince, how about running GENDBC on Quack, copying out the code that creates the Quack table, run that code against Moo, then inserting into Moo Select * from Quack!table?
Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com/ Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would appreciate the opportunity to work with them. Vince Teachout wrote: >> -----Original Message----- >> From: [email protected] [mailto:[email protected]] On >> Behalf Of Grigore Dolghin >> Sent: 08 October 2009 23:40 >> To: [email protected] >> Subject: Re: Move a table from one DBC to another? >> >> What about Copy To <fullpath>\<tablename> Database Moo >> Set Database To Quack >> Drop Table <tablename> ? >> > > I think Grigore wins the cigar! That works for 95% of the stuff - > doesn't get the comments, which is the main reason I'm using a DBC, but > I can just rebuild them with setcursor props. > > I didn't know about the DATABASE clause in COPY. Thanks, Grigore! > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

