Thread: Re: Data Migration Wizard & FoxPro memo questio

Re: Data Migration Wizard & FoxPro memo questio

From
Dave Page
Date:

> -----Original Message-----
> From: Paul Haddon [mailto:paullist@hartingdale.com.au]
> Sent: 11 March 2002 00:12
> To: Dave Page
> Subject: Re: [pgadmin-support] Data Migration Wizard & FoxPro
> memo question
>
>
> > No, this is not normal - text fields should work fine. Do
> you have a
> > sample (or can you create one) of your database that you
> can send me
> > for testing?
>
> I've attached a test database (foxtest.dbf) with memo file
> (foxtest.fpt). Also attached is the log file created by pgAdmin.
>
> The field not working is 'a_memo'. The 'create table' creates
> it as a text-type, but doesn't copy the data with it.

Paul,

I've just spent some time playing with this in the debugger, and it seems
that there is something odd about the Foxpro ODBC driver. Basically, the
second time a LongVarChar column is accessed, it's value gets set NULL.

Anyway, I've committed a fix to CVS to work around this - if you're happy to
use development code, you can get the updated binaries from
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/binaries/ (I'd suggest using the
'Download Tarball' link).

To install them, use the following procedure:

1) Backup your system.
2) From the tarball, copy the .ocx, .dll's and .exe over the existing copies
which are
   normally installed under one of the following directories:

     C:\Program files\pgAdmin2
     C:\Program files\pgAdmin2\Exporters
     C:\Program files\pgAdmin2\Plugins

3) From the Start -> Run box, for each file you installed run a command
similar to:

   regsvr32 "C:\Program Files\pgAdmin2\<filename>"

   NOTE: pgSchema.dll must be registered first.

Regards, Dave.