ODBC Error

[Nancy Palmquist]

Rod Caddy wrote:
> 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.
Roddy,

Sounds like the field is a true/false and is being displayed as Y/N. 
Also make sure that you have established a read/write connection and not 
a read only connection.

I have always used low level connections with my ODBC work, and it is 
not clear from your posting what kind of connection you are attempting.

I never had good success with the high level connection in our 
application.  The work data was too big, I think.

Nancy

-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com