ODBC Error
Rod Caddy
rcaddy at pro-set.com
Mon Jun 4 22:12:46 PDT 2007
I am running fpodbc 1.01. The database sits on a Windows 2000 server
but is accessed via an XP Pro system. I can read data out of the
database, I can run reports on the database, but if I try to change a
field from an N to a Y it will give the following error.
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)
In the database the field that is being written to is a text datatype.
Any help is always appreciated.
--
Rod Caddy
Pro-Set Systems
rcaddy at pro-set.com
More information about the Filepro-list
mailing list