On 04/16/2015 12:24 PM, TonyS wrote:
I am in the process of porting some routines from using FoxPro to PostgreSQL 9.3.6. While the long term goal is to entirely rewrite everything in the system, in order to get items transferred as soon as possible I am having to try to convert some of the modules in place. For the most part, this has happened with a minimum of issues and the majority of changes I have been able to make by just writing a tool to slightly alter query syntax. I am experiencing a problem saving new records in a couple of cases, and I don't understand why. I execute the AddNew command on a dynaset that is opened with dbOpenDynaset and dbOptimistic values to make it updateable. I assign values to the new record, and the perform the Update function. On this particular recordset it returns the error: S1000: positioned_load in pos_newload failed I received the same message on a recordset I had opened using "Select *" because I was operating on all of the columns. When I changed the query to list the individual names, the error went away. On this particular recordset, that did not the solve the problem. I searched for this particular error and found very little. Can anyone give me an idea as to how I should proceed?
What are the configuration settings for your ODBC connection?
Here is the section of the ODBC driver log from when the error occurred:
Not seeing the log entries, this post coming from Nabble?
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
