Working on problem, thanks for driver help - Mailing list pgsql-odbc

From Fred Parkinson
Subject Working on problem, thanks for driver help
Date
Msg-id 47BC61AA020000A700006B65@groupwise.abag.ca.gov
Whole thread Raw
Responses Re: Working on problem, thanks for driver help
List pgsql-odbc
I tried 8.01.02 to replace my old one, but the problem persists.

I will keep trying newer versions, but I thought I might post a description of the problem in the meantime in case
someonehas seen it or has suggestions. 

In my app. I have a subform which has a tab control with student information, and the form source is table tStudents, a
postgrestable. 

This form is embeded in another form, fMain.

Odd thing is, if I do a Ctrl-V to paste text into a text box on the tab, the form moves to a new record and pastes the
datathere instead of to the original record that was displayed!  The form has moved to the new record before the
'beforeupdate' event of the text box has fired. 

This happens if I paste into a box on either tab page.  You don't notice it at first because all the rest of the boxes
continueto display the data of the original record, until you click on another tab.  Then all the boxes show the new
unwantedrecord, and there the pasted data is. 

Ctrl-X (cut) has the same problem.  Things look good at first, then you notice that you removed data from a different
recordthat the form has moved to! 

It doesn't happen when I copy all the postgres data into a local access table and then use it as the record source
insteadof the postgres table.  This is what makes me think it may be an odbc driver issue. 

Ctrl-V and Ctrl-X are windows functions (I'm on Win XP Professional, not sure which SP) so concievably Win is part of
theproblem.  I will set up a box with an earlier version of XP and see what happens. 

This app has been running smoothly for years, and through several updates to the backend postgres database.

Thanks in advance for any help, if I solve it I will post a solution.

Fred


pgsql-odbc by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: odbc driver for postgresql 8.1.8 available?
Next
From: "Dave Page"
Date:
Subject: Re: odbc driver for postgresql 8.1.8 available?