> CREATE TABLE FSBSRun ( > ... > Maintenance CHAR NOT NULL, > Availability CHAR NOT NULL, > ... > )
I think the problem is that CHAR in the database is not the same as the char data type in code. In the database, a CHAR is actually a string that is one character long (i.e. CHAR === CHAR(1) [I believe]). So, instead of: > command->Parameters->Add(S"@maint", __box(run.maintenance)); > command->Parameters->Add(S"@avail", __box(run.availability)); Try: String __gc* maint = (run.maintenance ? S"T" : S"F"); command->Parameters->Add(S"@maint", maint); String __gc* avail = (run.availability ? S"T" : S"F"); command->Parameters->Add(S"@avail", avail); However, I would question the value of using a CHAR data type here. You might want to try a SMALLINT or something and set to 0 or 1. Dean. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
