View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 06:49 PM
=?ISO-8859-1?Q?Josu=E9_Maldonado?=
 
Posts: n/a
Default Re: Postgresql Text field / Visual FoxPro Memo and ODBC

Hello,

El 12/01/2005 2:59 PM, MargaretGillon@chromalloy.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.

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

Reply With Quote