Postgresql Text field / Visual FoxPro Memo and ODBC

From: MargaretGillon(at)chromalloy(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql Text field / Visual FoxPro Memo and ODBC
Date: 2005-01-12 20:59:28
Message-ID: OF65CB1304.6CDFA738-ON88256F87.00728068-88256F87.0072AE3E@CHROMALLOY.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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?

Thanks.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-01-12 21:06:30 Re: Postgresql Text field / Visual FoxPro Memo and ODBC
Previous Message Joost Kraaijeveld 2005-01-12 20:48:48 How to return a resultset/table from a sql function?