"ID= '" + Encoding.Default.GetString(((Guid)table.Rows[i]["Id"]).ToByteArray()) + "'"
sorry,For a example,I must use "Select * From Table Where ID= '薳[\0\rC?-p=呖\r'",It Can't Get The Record.I know I can Use FbCommand with parameterTo do it,but I use Dbcommand with parametar to do it. So I want to know,How Do the fbcommand to do this? as a example,I Get The Where Clause By "ID= '" + Encoding.Default.GetString(((Guid)table.Rows[i]["Id"]).ToByteArray()) + "'" Is There Any Error? sure I use a field by char[16],and the charset is octecs. thanks -- View this message in context: http://www.nabble.com/How-to-use-sql-to-insert-record-with-guid--t1427996.html#a3876674 Sent from the firebird-net-provider forum at Nabble.com. ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider