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?
Here is the section of the ODBC driver log from when the error occurred:
--
View this message in context:
http://postgresql.nabble.com/Error-using-DAO-with-the-ODBC-driver-S1000-positioned-load-in-pos-newload-failed-tp5845887.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.