Error when running processing

Rod Caddy rcaddy at pro-set.com
Wed Oct 12 06:36:45 PDT 2005


Windows XP workstation, WINDOWS 2000 server, FpODBC.  I am running FpODBC from
the XP machine off of the server.  In other words the server has both program
and data housed on it.  I created a processing only posting routine and it is
run from a file called odbc_jrnl.  This file is the odbc source from access
that I have created in FpODBC.  In this process I do lookups into standard
Filepro files and pull data from them just fine.  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)

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

I press enter and it goes to the next record and starts the whole process over.

Some additional background, I had a problem at first getting a 'Too few
parameters' message but I resolved that by correcting some errors in my DSN and
making sure that I was connected to the Access driver.  That being resolved I
can do ddefine, dclerk, etc.  The failure seems to be in the way my processing
is updating other files that are standard Filepro files.  Am I mis-interpreting
the documentation?  I was under the impression that I could update not only the
Filepro files but the Access files for simple manipulation.  Any suggestions
would be greatly appreciated.

Rod Caddy
Pro-Set Systems
rcaddy at pro-set.com


More information about the Filepro-list mailing list