Re: Postgresql Text field / Visual FoxPro Memo and ODBC - Mailing list pgsql-general

From Josué Maldonado
Subject Re: Postgresql Text field / Visual FoxPro Memo and ODBC
Date
Msg-id 41E59B8F.4000406@lamundial.hn
Whole thread Raw
In response to Re: Postgresql Text field / Visual FoxPro Memo and ODBC  (MargaretGillon@chromalloy.com)
Responses Re: Postgresql Text field / Visual FoxPro Memo and ODBC
List pgsql-general
El 12/01/2005 3:38 PM, MargaretGillon@chromalloy.com en su mensaje escribio:

> I am using updatable cursors. I set up the cursor and set the cursor
> properties to updateable and set the key field property so it knows the key
> on the Postgresql table. The cursors are managed by a VFP class written by
> a programmer named Andy Kramek. He uses this class to manage updateable
> cursors in UI's for Oracle databases, I think on Unix servers. I have also
> used the class to talk to an SQLServer on Windows2000.
>
> The advantage with cursors is that I can pull down a set of 100-200
> records, edit them, and send them back to the server and only one round
> trip has occured. Saves a lot of time when loading new tables, which is
> what I'm doing currently.

True, I also use SPT cursors in VFP and haven't had any issues with text
/memo columns so far.

> I looked in the archives and there are messages about this problem but the
> fix for it was in the PGAdmin software. I didn't see anything that talked
> about the same problem / fix for ODBC.

How about ODBC version conflicts, I have Postgresql ODBC driver version
8, I got it downloading latest pgadmin 3 version.


--
Sinceramente,
Josué Maldonado.

"El aspecto más triste de la vida actual es que la ciencia gana en
conocimiento más rápidamente que la sociedad en sabiduría." -- Isaac Asimov

pgsql-general by date:

Previous
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: Postgresql Text field / Visual FoxPro Memo and ODBC
Next
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: Postgresql Text field / Visual FoxPro Memo and ODBC