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