Re: Error using DAO with the ODBC driver S1000: positioned_load in pos_newload failed

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(dot)klaver(at)aklaver(dot)com