Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Andrew A. (JIRA) <tr...@fi...> - 2017-05-09 05:06:20
|
FbScript not parsing comments in SQL script.
--------------------------------------------
Key: DNET-761
URL: http://tracker.firebirdsql.org/browse/DNET-761
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.9.0.0
Environment: NET45. Problem may exist is other versions as well.
Reporter: Andrew Ayre
Assignee: Jiri Cincura
Some older version of the .NET Data Provider seem to work OK.
This issues seems to be related to how comment are handled within an SQL script when it is parsed by FbScript.
Both multiline comments as well as single line comments are impacted.
Multiline comments seem to have an issue if the comment contains a "@" character.
The below is an example of valid SQL that fails to parse correctly with FbScript:
====== Begin SQL Example 1 ======
/*@@Metadata
<Title Metadata>
Summary: Metadata.
Description Metadata is the collection of scripts that create the structure and
supporting business rules for the Firebird Database.
All scripts are written in ANSI92 SQL language which is the language used by the Firebird Server.
* *
Developers please consult the SDK for coding and documentation standards.
*/
CREATE EXCEPTION ACTUAL_DATE_CANCELLATION
'Actual Date must be null if Cancellation Reason is set.';
====== End SQL Example 1======
The error returned is:
Exception thrown: 'FirebirdSql.Data.FirebirdClient.FbException' in FirebirdSql.Data.FirebirdClient.dll
Additional information: Must declare command parameters.
Single line comments seem to have an issue with comments occurring after the last SQL statement.
The below is an example of valid SQL that fails to parse correctly with FbScript:
====== Begin SQL Example 2 ======
CREATE EXCEPTION ACTUAL_DATE_CANCELLATION
'Actual Date must be null if Cancellation Reason is set.';
-- This is a test
====== End SQL Example 2======
Exception thrown: 'System.ArgumentException' in FirebirdSql.Data.FirebirdClient.dll
Additional information: The type of the SQL statement could not be determined. See also UnknownStatement event.
Statement:
-- This is a test
.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2017-05-08 11:59:18
|
Suppprt for CREATE/ALTER FUNCTION in FirebirdSql.Data.Isql
----------------------------------------------------------
Key: DNET-760
URL: http://tracker.firebirdsql.org/browse/DNET-760
Project: .NET Data provider
Issue Type: Sub-task
Components: ADO.NET Provider
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2017-05-07 12:43:17
|
License URL is wrong
--------------------
Key: DNET-759
URL: http://tracker.firebirdsql.org/browse/DNET-759
Project: .NET Data provider
Issue Type: Bug
Components: NuGet packages
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Trivial
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiří Č. <ji...@ci...> - 2017-05-07 08:46:46
|
OK, there doesn't seem to be any more discussion around this. And because, as stated before, MS is not going to support 4.0 (and also 4.7 is now out for all systems), the minimum supported version in next major version will be 4.5.2. If somebody wants the 4.0 the previous versions are always available. Any questions? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2017-05-07 07:56:16
|
NuGet reference to Microsoft.Extensions.PlatformAbstractions is outdated
------------------------------------------------------------------------
Key: DNET-758
URL: http://tracker.firebirdsql.org/browse/DNET-758
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.9.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiří Č. <ji...@ci...> - 2017-05-07 07:33:33
|
More info: https://www.tabsoverspaces.com/233620-ado-net-provider-5-9-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2017-05-07 07:27:17
|
FbRemoteEvents rework
---------------------
Key: DNET-757
URL: http://tracker.firebirdsql.org/browse/DNET-757
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 5.8.1.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Full description at: https://www.tabsoverspaces.com/id/233621/
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Daniel R. <da...@ac...> - 2017-05-02 12:05:49
|
Hi, At April 24, 2017, 12:39 PM, Jiří Činčura wrote: >> But, what could cause it not to recognize those fields properly? >> Because when I look in the database's system tables, the >> RDB$FIELD_TYPE and RDB$FIELD_LENGTH both have values in them, one >> would be VARCHAR(132) and the others would be CHAR(1). > Don't know. If you can confirm it's really those fields, put it to > tracker and I'll look at it. Sorry for the late reply, I'm under a time crunch to complete a project. Once I have the time(hopefully within a month), I'll try to reproduce it with a database that contains one table with those kind of computed fields. There was another table that had one computed field, and that one was simpler in construct, and the Code First from Database wizard didn't have any problems with that table. So, it must be something with that one table in particular and the complexities of its computed fields. As soon, as I have a reproducible test case, I'll enter an issue in the tracker. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) |
|
From: Daniel R. <da...@ac...> - 2017-05-02 11:58:50
|
Hi,
At May 2, 2017, 7:55 AM, Jiří Činčura wrote:
>> Can you please add 1 line to describe the difference between using {0}
>> vs. @p0 ?
> Well, AFAIK only the @p0 is supported. Maybe the {0} works as well, but
> I know only about the @p0 from documentation. Of course we can check EF6
> sources, but I'm too lazy to do that. :D
Actually, it's not. I'm using the Firebird's default parameter syntax,
the question mark. And, I use "new object[] {paramValue1, paramValue2,
etc..}" to pass the parameters, and paramValueX are just simple
variables or object properties, don't have to be FbParameter. I don't
remember trying @p0, although I did try with actual names(i.e.:
@PDate), since it was also documented in the MSDN documentation, but I
was getting an invalid field error coming from Firebird.
But, as you mentioned, one might have to look at the EF6 sources to
find out the real behavior.
--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
|
|
From: Jiří Č. <ji...@ci...> - 2017-05-02 10:56:05
|
> Can you please add 1 line to describe the difference between using {0}
> vs. @p0 ?
Well, AFAIK only the @p0 is supported. Maybe the {0} works as well, but
I know only about the @p0 from documentation. Of course we can check EF6
sources, but I'm too lazy to do that. :D
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
|
|
From: Nikolaus K. <par...@gm...> - 2017-05-02 10:21:24
|
Hello Jiri,
its my fault: AUSLASTUNG_GEHOERT_ZU is Varchar(20), the parameter "Halle 6 - Schlosserei" is 21 chars long.... After correcting the length to 30 it works fine. Interessting the slq console does not compain about the too long input for the query.
Thanks for answering to my posting that fast.
Can you please add 1 line to describe the difference between using {0} vs. @p0 ?
Thanks
Niko
-----Ursprüngliche Nachricht-----
Von: Jiří Činčura [mailto:ji...@ci...]
Gesendet: Dienstag, 2. Mai 2017 11:57
An: fir...@li...
Betreff: Re: [Firebird-net-provider] EF handling - as string parameter
What's the AUSLASTUNG_GEHOERT_ZU's datatype?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Tue, May 2, 2017, at 11:55, Nikolaus Kern wrote:
> Hello Jiri,
>
> thanks for the response.
>
> I guess I am missing something here. The code below produces the same
> error as {0}.
>
> ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE
> PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND
> AUSLASTUNG_GEHOERT_ZU = @p0 ORDER BY PRODUKTIONSAUFTRAG_ID"; tmpPPA =
> this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, new
> object[]{this.CurrentHalle}).ToList();
>
> If I copy the query to the SQL tool and execute the query it works
> fine (even when it does not return a record, which is also the case in
> other working queries).
> SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN
> ('Abgeschlossen','Storno') AND AUSLASTUNG_GEHOERT_ZU = 'Halle 6 -
> Schlosserei' ORDER BY PRODUKTIONSAUFTRAG_ID
>
> Do you have an idea whats missing?
>
> Thanks
>
> Niko
>
> -----Ursprüngliche Nachricht-----
> Von: Jiří Činčura [mailto:ji...@ci...]
> Gesendet: Dienstag, 2. Mai 2017 10:02
> An: fir...@li...
> Betreff: Re: [Firebird-net-provider] EF handling - as string parameter
>
> You should use @p0 instead of {0}
> (https://msdn.microsoft.com/en-us/library/system.data.entity.dbset.sqlquery%28v=vs.113%29.aspx).
> Optionally you can also specify the Size in FbParameter.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> On Tue, May 2, 2017, at 09:58, Nikolaus Kern wrote:
> > Hi,
> >
> > I just saw that the query and the execution do not match correct.
> > This is the query with the parameter that creates an exception if
> > the parameter is "Halle 6 - Schlosserei".
> >
> > ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE
> > PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND
> > AUSLASTUNG_GEHOERT_ZU = {0} ORDER BY PRODUKTIONSAUFTRAG_ID"; tmpPPA
> > = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery,
> > this.CurrentHalle).ToList();
> >
> > Niko
> >
> > -----Ursprüngliche Nachricht-----
> > Von: Jiří Činčura [mailto:ji...@ci...]
> > Gesendet: Dienstag, 2. Mai 2017 09:43
> > An: fir...@li...
> > Betreff: Re: [Firebird-net-provider] EF handling - as string
> > parameter
> >
> > What parameter? I don't see any parameter in the query.
> >
> > --
> > Mgr. Jiří Činčura
> > https://www.tabsoverspaces.com/
> >
> >
> > --------------------------------------------------------------------
> > --
> > -------- Check out the vibrant tech community on one of the world's
> > most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> >
> > --------------------------------------------------------------------
> > --
> > -------- Check out the vibrant tech community on one of the world's
> > most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
> ----------------------------------------------------------------------
> -------- Check out the vibrant tech community on one of the world's
> most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ----------------------------------------------------------------------
> -------- Check out the vibrant tech community on one of the world's
> most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiří Č. <ji...@ci...> - 2017-05-02 09:57:34
|
What's the AUSLASTUNG_GEHOERT_ZU's datatype? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, May 2, 2017, at 11:55, Nikolaus Kern wrote: > Hello Jiri, > > thanks for the response. > > I guess I am missing something here. The code below produces the same > error as {0}. > > ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE > PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND > AUSLASTUNG_GEHOERT_ZU = @p0 ORDER BY PRODUKTIONSAUFTRAG_ID"; > tmpPPA = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, new > object[]{this.CurrentHalle}).ToList(); > > If I copy the query to the SQL tool and execute the query it works fine > (even when it does not return a record, which is also the case in other > working queries). > SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN > ('Abgeschlossen','Storno') AND AUSLASTUNG_GEHOERT_ZU = 'Halle 6 - > Schlosserei' ORDER BY PRODUKTIONSAUFTRAG_ID > > Do you have an idea whats missing? > > Thanks > > Niko > > -----Ursprüngliche Nachricht----- > Von: Jiří Činčura [mailto:ji...@ci...] > Gesendet: Dienstag, 2. Mai 2017 10:02 > An: fir...@li... > Betreff: Re: [Firebird-net-provider] EF handling - as string parameter > > You should use @p0 instead of {0} > (https://msdn.microsoft.com/en-us/library/system.data.entity.dbset.sqlquery%28v=vs.113%29.aspx). > Optionally you can also specify the Size in FbParameter. > > -- > Mgr. Jiří Činčura > https://www.tabsoverspaces.com/ > > On Tue, May 2, 2017, at 09:58, Nikolaus Kern wrote: > > Hi, > > > > I just saw that the query and the execution do not match correct. This > > is the query with the parameter that creates an exception if the > > parameter is "Halle 6 - Schlosserei". > > > > ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE > > PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND > > AUSLASTUNG_GEHOERT_ZU = {0} ORDER BY PRODUKTIONSAUFTRAG_ID"; tmpPPA = > > this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, > > this.CurrentHalle).ToList(); > > > > Niko > > > > -----Ursprüngliche Nachricht----- > > Von: Jiří Činčura [mailto:ji...@ci...] > > Gesendet: Dienstag, 2. Mai 2017 09:43 > > An: fir...@li... > > Betreff: Re: [Firebird-net-provider] EF handling - as string parameter > > > > What parameter? I don't see any parameter in the query. > > > > -- > > Mgr. Jiří Činčura > > https://www.tabsoverspaces.com/ > > > > > > ---------------------------------------------------------------------- > > -------- Check out the vibrant tech community on one of the world's > > most engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > ---------------------------------------------------------------------- > > -------- Check out the vibrant tech community on one of the world's > > most engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most engaging > tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Nikolaus K. <par...@gm...> - 2017-05-02 09:55:50
|
Hello Jiri,
thanks for the response.
I guess I am missing something here. The code below produces the same error as {0}.
ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND AUSLASTUNG_GEHOERT_ZU = @p0 ORDER BY PRODUKTIONSAUFTRAG_ID";
tmpPPA = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, new object[]{this.CurrentHalle}).ToList();
If I copy the query to the SQL tool and execute the query it works fine (even when it does not return a record, which is also the case in other working queries).
SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND AUSLASTUNG_GEHOERT_ZU = 'Halle 6 - Schlosserei' ORDER BY PRODUKTIONSAUFTRAG_ID
Do you have an idea whats missing?
Thanks
Niko
-----Ursprüngliche Nachricht-----
Von: Jiří Činčura [mailto:ji...@ci...]
Gesendet: Dienstag, 2. Mai 2017 10:02
An: fir...@li...
Betreff: Re: [Firebird-net-provider] EF handling - as string parameter
You should use @p0 instead of {0}
(https://msdn.microsoft.com/en-us/library/system.data.entity.dbset.sqlquery%28v=vs.113%29.aspx).
Optionally you can also specify the Size in FbParameter.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Tue, May 2, 2017, at 09:58, Nikolaus Kern wrote:
> Hi,
>
> I just saw that the query and the execution do not match correct. This
> is the query with the parameter that creates an exception if the
> parameter is "Halle 6 - Schlosserei".
>
> ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE
> PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND
> AUSLASTUNG_GEHOERT_ZU = {0} ORDER BY PRODUKTIONSAUFTRAG_ID"; tmpPPA =
> this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery,
> this.CurrentHalle).ToList();
>
> Niko
>
> -----Ursprüngliche Nachricht-----
> Von: Jiří Činčura [mailto:ji...@ci...]
> Gesendet: Dienstag, 2. Mai 2017 09:43
> An: fir...@li...
> Betreff: Re: [Firebird-net-provider] EF handling - as string parameter
>
> What parameter? I don't see any parameter in the query.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
>
> ----------------------------------------------------------------------
> -------- Check out the vibrant tech community on one of the world's
> most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ----------------------------------------------------------------------
> -------- Check out the vibrant tech community on one of the world's
> most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiří Č. <ji...@ci...> - 2017-05-02 08:02:06
|
You should use @p0 instead of {0}
(https://msdn.microsoft.com/en-us/library/system.data.entity.dbset.sqlquery%28v=vs.113%29.aspx).
Optionally you can also specify the Size in FbParameter.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Tue, May 2, 2017, at 09:58, Nikolaus Kern wrote:
> Hi,
>
> I just saw that the query and the execution do not match correct. This is
> the query with the parameter that creates an exception if the parameter
> is "Halle 6 - Schlosserei".
>
> ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE
> PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND
> AUSLASTUNG_GEHOERT_ZU = {0} ORDER BY PRODUKTIONSAUFTRAG_ID";
> tmpPPA = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery,
> this.CurrentHalle).ToList();
>
> Niko
>
> -----Ursprüngliche Nachricht-----
> Von: Jiří Činčura [mailto:ji...@ci...]
> Gesendet: Dienstag, 2. Mai 2017 09:43
> An: fir...@li...
> Betreff: Re: [Firebird-net-provider] EF handling - as string parameter
>
> What parameter? I don't see any parameter in the query.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Nikolaus K. <par...@gm...> - 2017-05-02 07:58:25
|
Hi,
I just saw that the query and the execution do not match correct. This is the query with the parameter that creates an exception if the parameter is "Halle 6 - Schlosserei".
ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND AUSLASTUNG_GEHOERT_ZU = {0} ORDER BY PRODUKTIONSAUFTRAG_ID";
tmpPPA = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, this.CurrentHalle).ToList();
Niko
-----Ursprüngliche Nachricht-----
Von: Jiří Činčura [mailto:ji...@ci...]
Gesendet: Dienstag, 2. Mai 2017 09:43
An: fir...@li...
Betreff: Re: [Firebird-net-provider] EF handling - as string parameter
What parameter? I don't see any parameter in the query.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiří Č. <ji...@ci...> - 2017-05-02 07:43:22
|
What parameter? I don't see any parameter in the query. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Nikolaus K. <par...@gm...> - 2017-05-02 07:39:29
|
Hello,
I am using following query to get all workitems for a specific organisation
unit:
ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS
NOT IN ('Abgeschlossen','Storno') ORDER BY PRODUKTIONSAUFTRAG_ID";
tmpPPA = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery).ToList();
This works fine, unless the parameter contains a -. In this case I receive
an exception "arithmetic exception, numeric overflow, or string
truncation\r\nstring right truncation"
In the case I concatenate the sql query it works fine:
ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS
NOT IN ('Abgeschlossen','Storno') AND AUSLASTUNG_GEHOERT_ZU = '" +
this.CurrentHalle + "' ORDER BY PRODUKTIONSAUFTRAG_ID";
tmpPPA = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery,
this.CurrentHalle).ToList();
Its EF 6.13 and Firebird .net Provider 4.10 (I am aware of the newer
versions but need to migration a big number of assemblies).
I would like to understand if there is a way to resolve this problem in a
more elegant way.
Thanks
Niko
|
|
From: Farhan W. (JIRA) <tr...@fi...> - 2017-05-02 00:31:10
|
FirebirdSql.Data.EntityFramework6.FbProviderServices..cctor() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbProviderServices.cs:line 64
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: DNET-756
URL: http://tracker.firebirdsql.org/browse/DNET-756
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Affects Versions: 5.8.1.0
Environment: Windows
Reporter: Farhan Wazir
Assignee: Jiri Cincura
On EF6 Model
public MyContext : base("TestConnectionString") <<
Stack Trace::
Exception thrown: 'System.Reflection.TargetInvocationException' in mscorlib.dll
Exception has been thrown by the target of an invocation.
>>>>>>>> Inner Exception <<<<<<<<<<<<<<<
System.TypeInitializationException: The type initializer for 'FirebirdSql.Data.EntityFramework6.FbProviderServices' threw an exception. ---> System.TypeLoadException: Could not load type 'System.Data.Entity.Infrastructure.Interception.IDbConnectionInterceptor' from assembly 'EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
at FirebirdSql.Data.EntityFramework6.FbProviderServices..ctor()
at FirebirdSql.Data.EntityFramework6.FbProviderServices..cctor() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbProviderServices.cs:line 64
--- End of inner exception stack trace ---
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiří Č. <ji...@ci...> - 2017-04-25 08:37:39
|
After a lot of thinking and considering pros and cons, I decided to do the change. It's going to be painful, especially for people already using it, but the least surprise principle here is strong argument in my head. Also because there are some big changes in Firebird 3 itself (like this https://www.tabsoverspaces.com/233552-gotcha-with-firebird-3-count-and-executescalar-common-casting-pattern/), it's better to do it sooner than later. Thus very likely next _major_ version will contain this change. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Jiří Č. <ji...@ci...> - 2017-04-24 15:39:38
|
> But, what could cause it not to recognize those fields properly? > Because when I look in the database's system tables, the > RDB$FIELD_TYPE and RDB$FIELD_LENGTH both have values in them, one > would be VARCHAR(132) and the others would be CHAR(1). Don't know. If you can confirm it's really those fields, put it to tracker and I'll look at it. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Daniel R. <da...@ac...> - 2017-04-24 15:16:58
|
Hi, At April 22, 2017, 10:09 AM, Jiří Činčura wrote: >> I was starting to suspect that, since the other tables that I was able >> to generate the code for didn't have computed fields. Are there any >> hints that I can use? >> >> I can try to look at the code to see if I can fix the problem. And, >> since I never did look inside the ADO.Net driver code. Can you guide >> me to what would be the area of code that I would need to look at? >> >> I'm willing to try to fix the problem, since this is not the only >> table in that database that has computed fields. > You can create a table without computed field, generate the CF for it. > And then do the same for a table with computed field. But, what could cause it not to recognize those fields properly? Because when I look in the database's system tables, the RDB$FIELD_TYPE and RDB$FIELD_LENGTH both have values in them, one would be VARCHAR(132) and the others would be CHAR(1). -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) |
|
From: Jiří Č. <ji...@ci...> - 2017-04-22 13:09:39
|
> I was starting to suspect that, since the other tables that I was able > to generate the code for didn't have computed fields. Are there any > hints that I can use? > > I can try to look at the code to see if I can fix the problem. And, > since I never did look inside the ADO.Net driver code. Can you guide > me to what would be the area of code that I would need to look at? > > I'm willing to try to fix the problem, since this is not the only > table in that database that has computed fields. You can create a table without computed field, generate the CF for it. And then do the same for a table with computed field. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Daniel R. <da...@ac...> - 2017-04-22 12:58:26
|
Hi, At April 22, 2017, 4:47 AM, Jiří Činčura wrote: > My *guess* is that it's the computed columns and the length is not > discovered properly. I was starting to suspect that, since the other tables that I was able to generate the code for didn't have computed fields. Are there any hints that I can use? I can try to look at the code to see if I can fix the problem. And, since I never did look inside the ADO.Net driver code. Can you guide me to what would be the area of code that I would need to look at? I'm willing to try to fix the problem, since this is not the only table in that database that has computed fields. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) |
|
From: Jiří Č. <ji...@ci...> - 2017-04-22 07:48:08
|
My *guess* is that it's the computed columns and the length is not discovered properly. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Daniel R. <da...@ac...> - 2017-04-21 18:32:29
|
Hi,
I'm using Visual Studio 2015, with all updates, Firebird ADO.Net
5.8.1 and Entity Framework 6.1.3.
I'm trying to generate an EF6 object by using Code First from Database.
One table is causing an error when it is trying to generate the code.
Up to now, the other tables that I generated the EF6 code for, by
using the Code First from Database template, worked properly.
Here's the call stack generated within Visual Studio:
Microsoft Visual Studio
An error occurred generating the Code First model. The error occurred
generating the contents of TempModel1.cs.
System.ArgumentOutOfRangeException: MaxLength must be greater
than zero.
Parameter name: maxLength
at System.Data.Entity.Core.Metadata.Edm.TypeUsage.ValidateMaxLength(Int32 maxLength)
at System.Data.Entity.Core.Metadata.Edm.TypeUsage.CreateStringTypeUsage(PrimitiveType primitiveType, Boolean isUnicode, Boolean isFixedLength, Int32 maxLength)
at FirebirdSql.Data.EntityFramework6.FbProviderManifest.GetStoreType(TypeUsage emeype) in C:\Users\JirflDocuments\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbProviderManifest.cs:line 350
at Microsoft.Data.Entity.Design.CodeGeneration.ColumnDiscoverer.Discover(Ederoperty property, DbModel model)
at Microsoft.Data.Entity.Design.CodeGeneration.Edeelper.<> c_DisplayClass5_0.< GetConfigurations> b_0(IPropertyConfigurationDiscoverer f)
at System.Linq.Enumerable.WhereSelectArraylterator‘ZMoveNextO
at System.Linq.Enumerable.WhereEnumerablelterator‘l .MoveNextO
at System.Linq.Enumerable.< 0FI'ypelterator> d_92‘1 .MoveNextO
at System.Linq.Enumerable.WhereEnumerablelterator‘l .MoveNextO
at Microsoft.Data.Entity.Design.CodeGeneration.DefaultCSharpContextGenerator.TransformText0
at Microsoft.Data.Entity.Design.CodeGeneration.DefaultCSharpContextGenerator.Generate(DbModel model, String codeNamespace, String contextClassName, String connectionStringName)
at Microsoft.Data.Entity.Design.CodeGeneration.CodeFirstModelGenerator.< Generate) d_3.MoveNext0
And, here's the definition of the table that I'm having a problem with:
CREATE TABLE CLAIMSDETAIL (
SERVICENO INTEGER NOT NULL,
FILOPTOHCFACLAIMNO INTEGER,
DATESTART TIMESTAMP,
DATEEND TIMESTAMP,
PLACEOFSERVICE VARCHAR(2),
TYPEOFSERVICE VARCHAR(2),
HCPCS_CPTCODE VARCHAR(5),
MODIFIER1 VARCHAR(2),
MODIFIER2 VARCHAR(5),
DIAGNOSISCODE VARCHAR(1),
CHARGES CURRENCY,
DAYSORUNITS VARCHAR(2),
EPSDTFAMILYPLAN VARCHAR(2),
EMG VARCHAR(2),
COB VARCHAR(2),
LOCALUSE VARCHAR(8),
MODIFIEDDATE TIMESTAMP,
MODIFIEDBY USERNAMETYPE,
INVOICEDETAILITEMNO INTEGER,
MODIFIER3 CPT_CODE_MODIFIER,
MODIFIER4 CPT_CODE_MODIFIER,
DIAGNOSTIC_CODE VARCHAR(10),
DIAGNOSIS_CODE_POINTER_1 INTEGER,
DIAGNOSIS_CODE_POINTER_2 INTEGER,
DIAGNOSIS_CODE_POINTER_3 INTEGER,
DIAGNOSIS_CODE_POINTER_4 INTEGER,
SERVICE_SEQUENCE_NO INTEGER DEFAULT 1,
ESPDT CHAR(2),
SUPPLEMENTAL_INFORMATION VARCHAR(80),
UC_DIAGNOSIS_CODE_1 ICD9_CODE,
UC_DIAGNOSIS_CODE_2 ICD9_CODE,
UC_DIAGNOSIS_CODE_3 ICD9_CODE,
UC_DIAGNOSIS_CODE_4 ICD9_CODE,
DIAGNOSIS_CODES COMPUTED BY ( coalesce(iif(diagnosis_code_pointer_1>0, diagnosis_code_pointer_1, ''),'')||coalesce(iif(diagnosis_code_pointer_2>0, diagnosis_code_pointer_2, ''),'')||coalesce(iif(diagnosis_code_pointer_3>0, diagnosis_code_pointer_3, ''),'')||coalesce(iif(diagnosis_code_pointer_4>0, diagnosis_code_pointer_4, ''),'') ),
DIAGNOSIS_02_12_CODE_POINTER_1 COMPUTED BY ( case diagnosis_code_pointer_1
when 1 then 'A'
when 2 then 'B'
when 3 then 'C'
when 4 then 'D'
when 5 then 'E'
when 6 then 'F'
when 7 then 'G'
when 8 then 'H'
when 9 then 'I'
when 10 then 'J'
when 11 then 'K'
when 12 then 'L'
end ),
DIAGNOSIS_02_12_CODE_POINTER_2 COMPUTED BY ( case diagnosis_code_pointer_2
when 1 then 'A'
when 2 then 'B'
when 3 then 'C'
when 4 then 'D'
when 5 then 'E'
when 6 then 'F'
when 7 then 'G'
when 8 then 'H'
when 9 then 'I'
when 10 then 'J'
when 11 then 'K'
when 12 then 'L'
end ),
DIAGNOSIS_02_12_CODE_POINTER_3 COMPUTED BY ( case diagnosis_code_pointer_3
when 1 then 'A'
when 2 then 'B'
when 3 then 'C'
when 4 then 'D'
when 5 then 'E'
when 6 then 'F'
when 7 then 'G'
when 8 then 'H'
when 9 then 'I'
when 10 then 'J'
when 11 then 'K'
when 12 then 'L'
end ),
DIAGNOSIS_02_12_CODE_POINTER_4 COMPUTED BY ( case diagnosis_code_pointer_4
when 1 then 'A'
when 2 then 'B'
when 3 then 'C'
when 4 then 'D'
when 5 then 'E'
when 6 then 'F'
when 7 then 'G'
when 8 then 'H'
when 9 then 'I'
when 10 then 'J'
when 11 then 'K'
when 12 then 'L'
end ));
ALTER TABLE CLAIMSDETAIL ADD CONSTRAINT PK_CLAIMSDETAIL PRIMARY KEY (SERVICENO);
CREATE UNIQUE INDEX CLAIMSDETAIL0 ON CLAIMSDETAIL(FILOPTOHCFACLAIMNO,SERVICENO);
CREATE INDEX IDX_CLAIMSDETAIL ON CLAIMSDETAIL(FILOPTOHCFACLAIMNO);
CREATE INDEX IDX_CLAIMSDETAIL1 ON CLAIMSDETAIL(INVOICEDETAILITEMNO);
CREATE INDEX I_CLAIMSDETAIL_DATESTART ON CLAIMSDETAIL(DATESTART);
Any help would be appreciated.
Also, this table is used as is within our Delphi code for at least 5
years, and we do not want to change that code.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
|
211 messages has been excluded from this view by a project administrator.
