From: tao l. <la...@ho...> - 2004-02-17 22:37:04
|
Hi, all I am using WinXP, VS2003, Fb.net 1.5 RC5 and Interbase 6.0.2.0 open = source edition. I found the FbCommand.ExecuteNonQuery() can not handle the email type = string. Here is a simple example base on Employee.gdb string sql =3D "update customer set ADDRESS_LINE2 =3D 'bi...@xt...' = where CUST_NO =3D 1001"; FbCommand myCommand =3D new FbCommand(sql, fbConnection1); fbConnection1.Open(); myCommand.ExecuteNonQuery(); fbConnection1.Close(); When I view the result from IBConsole, the ADDRESS_LINE2 become = 'bill?.com'. But if I put one space behide the @, like "update customer = set ADDRESS_LINE2 =3D 'bill@ xtra.com' where CUST_NO =3D 1001", it get = the correct result.=20 Do I miss something or FbCommand can not handle well with the '@'? Regards, Tao |