Hello,
El 12/01/2005 2:59 PM, MargaretGillon@xxxxxxxxxxxxxx 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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
