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