Re: Postgresql Text field / Visual FoxPro Memo and ODBC

From: Josué Maldonado <josue(at)lamundial(dot)hn>
To: MargaretGillon(at)chromalloy(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql Text field / Visual FoxPro Memo and ODBC
Date: 2005-01-12 21:14:39
Message-ID: 41E5933F.80807@lamundial.hn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

El 12/01/2005 2:59 PM, MargaretGillon(at)chromalloy(dot)com en su mensaje escribio:
> I am using ODBC to move Visual FoxPro7 tables (windows 2000 client) into
> Postgresql 7.x on a Redhat Linux server. All is working well except for
> Memo fields, which are Text fields in PostgreSql. I query the Postgresql
> table and get a cursor, update the cursor with the data, and send it back.
> The contents of the memo field never make it back to the Postgresql text
> field. Other changes to the record's fields are saved with no problem.

Are you using SPT or remote views?

> At this time all my UI's have to be written in VFP. Is there a work around
> for this or am I going to have to eliminate Text/Memo fields from my
> tables?

I use VFP8 against Postgresql with ODBC without any issue with the memo
fields.

--
Sinceramente,
Josué Maldonado.

"La TV es muy educativa. Cuando está encendida, me voy a otra habitación
y me pongo a leer un libro." --Groucho Marx.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MargaretGillon 2005-01-12 21:28:15 Re: Postgresql Text field / Visual FoxPro Memo and ODBC
Previous Message Scott Marlowe 2005-01-12 21:06:30 Re: Postgresql Text field / Visual FoxPro Memo and ODBC