Re: Insert Into with memo fields - Followup

2011-10-25 Thread Jeff Johnson
I was unable to use insert with memo fields so I used append blank & gather memo. This worked fine on the small files but my concern was two huge files. One was a dbf and the other was an Access table. When I converted the Access data I used nvl() on each field. I also appended blank and ga

Re: Insert Into with memo fields

2011-10-25 Thread Jeff Johnson
On 10/25/2011 10:59 AM, Richard Quilhot wrote: > 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 wrote: > >> On 10/25/2011 10:23 AM, Fred Taylor wrote: >>> I just tried a SCATTER

Re: Insert Into with memo fields

2011-10-25 Thread Richard Quilhot
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 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

Re: Insert Into with memo fields

2011-10-25 Thread Jeff Johnson
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 > > >

Re: Insert Into with memo fields

2011-10-25 Thread Fred Taylor
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 wrote: > I

RE: Insert Into with memo fields

2011-10-25 Thread Richard Kaye
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, October 25, 2011 1:04 PM To: profoxt...@leafe.com Subject: Insert Into with memo fields I am importing a very large database from one version of a table to another version of a table with

Insert Into with memo fields

2011-10-25 Thread Jeff Johnson
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 u