Have you thought about doing the other way? Using the "append from" command.
Rick Q quilh...@gmail.com On Tue, Oct 25, 2011 at 1:49 PM, Jeff Johnson <j...@san-dc.com> wrote: > > On 10/25/2011 10:23 AM, Fred Taylor wrote: > > I just tried a SCATTER MEMO NAME test from origtable and then did a > INSERT > > INTO newtable FROM NAME test and it worked fine. > > > > Are you sure you've got the same structures in your tables? Possibly a > > field name that's a reserved word? > > > > Fred > > > > > > On Tue, Oct 25, 2011 at 10:04 AM, Jeff Johnson<j...@san-dc.com> wrote: > > > >> I am importing a very large database from one version of a table to > >> another version of a table with a few conversions. I use the scatter > >> name object blank and fill the objects with the data I want. Then I do > >> an append blank and gather name object. This works fine. I wanted to > >> speed things up by using an insert into. > >> > >> I tried scatter memo name object and then doing a insert into newtable > >> from name o and I get a data type mismatch on the insert. It appears to > >> be from the memo field. > >> I tried scatter name object and then insert into newtable from name o > >> and got the same message. > >> > >> Is there any way to optimize this when using a memo field? There are 72 > >> fields and I don't really want to go the route of a full insert into > >> command. > >> > >> Any ideas? > >> > >> -- > >> Jeff > >> > >> --------------- > >> > >> Jeff Johnson > >> j...@san-dc.com > >> (623) 582-0323 > >> > >> www.san-dc.com > >> > >> > That helped Fred. I was using the same object reference for two > different tables. ;^) > > > Jeff > > --------------- > > Jeff Johnson > j...@san-dc.com > (623) 582-0323 > > www.san-dc.com > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/CADaZP2nhOD8ZsG-_ED=sx5OPk2SwJ-GaERnBo==X2W=vzvo...@mail.gmail.com ** 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.
