Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297 Josué Maldonado <josue@xxxxxxxxxxxx> wrote on 01/12/2005 01:50:07 PM: > El 12/01/2005 3:38 PM, MargaretGillon@xxxxxxxxxxxxxx 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 I just downloaded and installed the lastest PGADMIN III, but I didnt' get a new ODBC driver. The only file in the download was pgadmin3.msi. The driver I have is ODBC version 7.03.02.00 dated 10-22-2003. That is the newest driver I see listed on the Postgresql site. Where can I get the 8 version? Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
