| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| 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:06:30 |
| Message-ID: | 1105563989.24795.52.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2005-01-12 at 14:59, MargaretGillon(at)chromalloy(dot)com wrote:
> 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?
Postgresql doesn't support updatable cursors.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josué Maldonado | 2005-01-12 21:14:39 | Re: Postgresql Text field / Visual FoxPro Memo and ODBC |
| Previous Message | MargaretGillon | 2005-01-12 20:59:28 | Postgresql Text field / Visual FoxPro Memo and ODBC |