Error when running processing

[Kenneth Brody]

Quoting Rod Caddy (Wed, 12 Oct 2005 08:36:45 -0500):
[...]
> During that process I write back out to those open lookups and I get
> an error that says the following:
>
> fpODBC exception trap
>
> Exception error in UpdateRecord
> This Field Can Only Be 0 or 1
> This Field Can Only Be 0 or 1
>
> State:S1000,Native:-3703,Origin:[Microsoft][ODBC Microsoft Access
> Driver]
> State:S1000,Native:-3703,Origin:[Microsoft][ODBC Microsoft Access
> Driver]
>
> RetCode = -1(0xffffffff)

Is there a field in this file that can only be 0 or 1, and what value
are you trying to put into that field?

> I click OK and I get this message:
>
> UpdateRecord for 'odbc_jrnl' failed: -1
>
> I press enter and then get a repeat of the same messages when it
> continues the processing and tries to write to a different file
> than it did the first time.
> At the end of the processing I receive this message:
>
> Deleted key is not found
>
> Index = odbc_jrnl/index.A
> key="ABC
>     "
> recno = 2802
> tptr = 3, 397, 3, 1, 0

Is index A built on a field that you changed when the update failed?

[...]
> I was under the impression that I could update not only the
> Filepro files but the Access files for simple manipulation.

You can.

> Any suggestions would be greatly appreciated.

filePro, of course, cannot do things that the ODBC source won't allow,
such as putting a "2" into a field that only allows "0" or "1".

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com