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
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? |