We are using SMALLINT type in our project.
FB EF provider also generates tables with SMALLINT fields for
code-first class fields.
On 26 June 2015 at 14:49, Christian Waldmann
<christian.waldm...@rte-ag.ch> wrote:
> 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
------------------------------------------------------------------------------
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
