> -----Original Message-----
> From: Paul Haddon [mailto:paullist(at)hartingdale(dot)com(dot)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.
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
normally installed under one of the following directories:
3) From the Start -> Run box, for each file you installed run a command
regsvr32 "C:\Program Files\pgAdmin2\<filename>"
NOTE: pgSchema.dll must be registered first.
pgadmin-support by date
|Next:||From: Masse Jacques||Date: 2002-03-11 14:44:08|
|Previous:||From: Tim Finch, FosterFinch Ltd||Date: 2002-03-08 11:04:02|
|Subject: Re: Can not connect with PG Admin after|