I am using Firebird 2.5.4, superServer and embedded, Visula Studio 2013,
.Net Framework 4.5.1, .Net Provider 4.6.2
//==========================================================================
=================
I have defined a table with "CyclePassed" CHAR(1) to store a boolean result
CREATE TABLE "SampleSummaries" (
"UniqueId" BIGINT DEFAULT 0 NOT NULL,
"EndTestRunId" BIGINT NOT NULL,
"Cycle" BIGINT NOT NULL,
"LoadPressure" FLOAT,
"LoadPressureMin" FLOAT,
"LoadPressureMax" FLOAT,
"ShutoffPressure" FLOAT,
"ShutoffPressureMin" FLOAT,
"ShutoffPressureMax" FLOAT,
"TravelTime" FLOAT,
"TravelTimeMin" FLOAT,
"TravelTimeMax" FLOAT,
"CyclePassed" CHAR(1)
);
//==========================================================================
=================
// access to table from C#
bool cyclePassed = true;
FbCommand command = new FbCommand();
command.CommandText =
"INSERT INTO \"SampleSummaries\" (" +
"\"EndTestRunId\", \"Cycle\", " +
"\"LoadPressure\", \"LoadPressureMin\", \"LoadPressureMax\", " +
"\"ShutoffPressure\", \"ShutoffPressureMin\", \"ShutoffPressureMax\",
" +
"\"TravelTime\", \"TravelTimeMin\", \"TravelTimeMax\",
\"CyclePassed\"" +
") VALUES (@EndTestRunId, @Cycle, " +
"@LoadPressure, @LoadPressureMin, @LoadPressureMax, " +
"@ShutoffPressure, @ShutoffPressureMin, @ShutoffPressureMax," +
"@TravelTime, @TravelTimeMin, @TravelTimeMax, @CyclePassed )";
command.Connection = samplesTableAdapter.Connection;
command.Transaction = transaction;
command.Parameters.Add("@EndTestRunId", FbDbType.BigInt).Value = channelId;
...
// PROBLEM A:
============================================================================
==============
// works with stand alone server,
// but SQL error "string conversion error '49'"
// {Remark: 49 is the decimal ASCII code of '1'}
command.Parameters.Add("@CyclePassed", FbDbType.Boolean).Value = cyclePassed
? '1' : '0';
// PROBLEM B:
============================================================================
==============
// works with embedded server,
// but "string truncation error" with stand alone server
command.Parameters.Add("@CyclePassed", FbDbType.Boolean).Value =
cyclePassed;
// REMARK:
============================================================================
==============
// works with embedded server and standalone server Firebird 2.5.3, with
.Net Provider 2.0, .Net Framework 2.0, Visual Studio 2008
command.Parameters.Add("@CyclePassed", FbDbType.Boolean).Value =
cyclePassed;
// QUESTION
============================================================================
================
Is this a bug or am I missing the correct usage of storing a 'bool'?
Happy coding
Christian Waldmann
------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors
network devices and physical & virtual servers, alerts via email & sms
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
