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: Jiri C. <di...@ci...> - 2013-02-13 14:16:27
|
On Wed, Feb 13, 2013 at 11:31 AM, Reinhard Gunacker <R.G...@bs...> wrote:
> Any Ideas how to speed up the creation of the Model?
With 650 tables it will be always slow. It's a huge query being
generated and Firebird doesn't like that. Basically only option is to
select only tables you're interested in.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Reinhard G. <R.G...@bs...> - 2013-02-13 10:32:51
|
Hi, I started so create an application using Entity Framework on an existing Database. This Database has about 650 Tables and about 1200 Foreign Keys. I tried to create an Entity Data Model with only one Table which has no Foreign Keys. Finishing the Wizard takes about 7 to 10 minutes. In this time the Firebird Server has full CPU load. Any Ideas how to speed up the creation of the Model? My Environment: Visual Studio 2010 .NET Framework 4.0 Firebird Server 2.5.1 .NET Provider 3.0.2.0 DDEX Provider 3.0.0 best regards Reinhard |
|
From: marius a. p. <ma...@gm...> - 2013-02-09 18:45:45
|
SplendidCRM (version C# of SugarCRM) ported from MSSQL over to FirebirdSQL 2.5.2 It is in a “testable” debug version on url http://zeos.tetrasys.eu http://www.linkedin.com/groups/SplendidCRM-on-FirebirdSQL-2078215.S.212283698 |
|
From: Sven W. (JIRA) <tr...@fi...> - 2013-01-30 14:07:27
|
FbDataAdapter stripped down SMALLINT values while updating a DataTable ...
--------------------------------------------------------------------------
Key: DNET-484
URL: http://tracker.firebirdsql.org/browse/DNET-484
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.6.5
Environment: Windows 32-Bit, .NET 3.5, Visual Studio 2010
Reporter: Sven Walter
Assignee: Jiri Cincura
Priority: Critical
Hey,
we have build a .NET 3.5 application upon the Firebird .NET Provider Version 2.6.5.
In our dataset we have designed a table and this table has columns of type "xs:short". The equivalent of "xs:short" in the firebird database is SMALLINT.
When we are updating rows in a .NET DataTable in one of these columns, the value is not correct transferred to the database.
For example we are putting a "108" into a "xs:short" column, the value will be written to the database as "10". We have no chance to fix this problem at the moment, because every values are fine until the FbDataAdapter receives the Table and Update Command. Update command is also fine.
I really hope, that someone has an idea, why this will happen or if someone could fix this issue soon, because we need to publish the next version of our product....
kind regards!
--
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: André K. <Kna...@be...> - 2013-01-28 10:31:15
|
OK, thanks. I took some time until I could even try, and now I probably understand that tracker software a bit better. So I first have to create a login plus a different filter definition. I guess it is an important tool when working with Firebird, so I will do so at the next opportunity. This specific matter though (DNET 483) obviously has been resolved meanwhile. > On Thu, Jan 24, 2013 at 5:34 PM, André Knappstein > <Kna...@be...> wrote: >> Yes-Sir! As soon as I find out where and how this works > Hack the tracker.firebirdsql.org. |
|
From: Jiri C. <di...@ci...> - 2013-01-25 07:55:16
|
On Thu, Jan 24, 2013 at 5:34 PM, André Knappstein <Kna...@be...> wrote: > Yes-Sir! As soon as I find out where and how this works :-) Hack the tracker.firebirdsql.org. :) -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com |
|
From: André K. <Kna...@be...> - 2013-01-24 16:33:41
|
> On Wed, Jan 23, 2013 at 2:18 PM, André Knappstein > <Kna...@be...> wrote: >> If my opinion also counts: > Maybe better to comment in tracker, because this email is from tracker. Yes-Sir! As soon as I find out where and how this works :-) mit freundlichen Grüßen, André Knappstein EDV und Controlling ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 140 Telefax: +49 2389 9240 150 e-mail: kna...@be... Amtsgericht Hamm Nr. B 420 Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus USt-IDNr.: DE 125215402 |
|
From: Jiri C. <di...@ci...> - 2013-01-24 07:29:09
|
On Wed, Jan 23, 2013 at 2:18 PM, André Knappstein
<Kna...@be...> wrote:
> If my opinion also counts:
Maybe better to comment in tracker, because this email is from tracker. :)
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: André K. <Kna...@be...> - 2013-01-23 13:17:20
|
> Given all that, I propose to change the current behavior from "one > commit after each execute" to "one commit after FbCommand disposal" > when using implicit transactions. This could bring some breaks in > compatibility, but it will bring the performance near to levels similar to the other providers. If my opinion also counts: hmmmh... no, better not :-) Too much existing code would break, especially taking into account that a lot of "disposal" of FbCommand only takes place on shutting down the application (static commands?). And I don't think that expected behaviour should be changed with a high risk of breaking indeed a lot of existing code "only" to make reverse engineering into EF faster. If Jiri finds a way to implement an optional switch or property of the FbCommand class to set behaviour this or that way, but without breaking existing code, okay. I still would not touch it myself unless I am absolutely certain that I could 100% guarantee the end-of-life/disposal of a command object. The risk of creating stuck transactions is too high for me. best regards, André |
|
From: <ram...@ma...> - 2013-01-20 21:52:11
|
Sehr geehrte Damen und Herren, die Adresse ram...@ma... ist nicht mehr verfügbar. Diese Mail wird NICHT weitergeleitet. Bitte nutzen Sie von nun an folgende Adresse: ram...@as... Vielen Dank! |
|
From: F.D.Castel (JIRA) <tr...@fi...> - 2013-01-20 21:24:29
|
New behavior for implicit transactions
--------------------------------------
Key: DNET-483
URL: http://tracker.firebirdsql.org/browse/DNET-483
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 3.0.2.0
Reporter: F.D.Castel
Assignee: Jiri Cincura
Priority: Minor
In the current implementation implicit transactions are being commited after each command execution (and restarted again on the next one). This is not the ideal since it causes a lot of overhead in Firebird.
Of course, with Firebird, the best practice IS to use explicit transactions. So, at first look, this is not a big problem.
However, in db-agnostic scenarios like ORMs the code is often NOT aware of this and expect to use DbCommands without transactions. So, in this case, they are taking a lot of time and server resources.
E.g.: It took me about 20 minutes to reverse engineer some moderately sized (400 tables) Firebird database into Entity Framework. At first I though it was EF fault, but after seeing the performance problems described in DNET-280 i did realize that was actually the provider fault.
Given all that, I propose to change the current behavior from "one commit after each execute" to "one commit after FbCommand disposal" when using implicit transactions. This could bring some breaks in compatibility, but it will bring the performance near to levels similar to the other providers.
--
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: Joseph M. <jo...@jm...> - 2013-01-14 07:18:01
|
Ok, I didn't realize that FBCommand wasn't something completely specific
to Firebird. I see now that it implements IDBCommand. I looked that up,
and found the docs and some sample code for using IDBCommand with output
parameters online, and I am now able to run my stored procedures, and
they're now working as expected!
Thank you Jiri for all your help this week. You have helped get me over a
major hurdle. I really appreciate it.
-Joe
On Fri, Jan 11, 2013 at 11:03 AM, Jiri Cincura <di...@ci...> wrote:
> On Fri, Jan 11, 2013 at 4:24 PM, Joseph Martinez <jo...@jm...>
> wrote:
> > How would I call the above SP and retrieve both the values of NEW_QTY and
> > AVG_COST?
>
> Define output parameters, as with any other ADO.NET. Nothing specific
> here for Firebird.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
> much more. Get web development skills now with LearnDevNow -
> 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122812
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
|
From: F.D.Castel (JIRA) <tr...@fi...> - 2013-01-12 04:14:31
|
Installer doesn't change Framework64 machine.config
---------------------------------------------------
Key: DNET-482
URL: http://tracker.firebirdsql.org/browse/DNET-482
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 3.0.2.0
Environment: Windwos 64-bit
Reporter: F.D.Castel
Assignee: Jiri Cincura
On 64-bit systems, the installer makes changes only in the 32-bit version of machine.config
C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config
but not in the 64-bit version
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config
--
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. <di...@ci...> - 2013-01-11 19:03:47
|
On Fri, Jan 11, 2013 at 4:24 PM, Joseph Martinez <jo...@jm...> wrote:
> How would I call the above SP and retrieve both the values of NEW_QTY and
> AVG_COST?
Define output parameters, as with any other ADO.NET. Nothing specific
here for Firebird.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Joseph M. <jo...@jm...> - 2013-01-11 15:24:38
|
I've figured out how to use FBConnect to call ExecuteScalar() to retrieve a
singe output parameter from a stored procedure that returns only one value,
like this:
FbCommand cmd = new FbCommand("PREDICT_COST_1");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@BARCODE", barcode);
cmd.Parameters.Add("@STOREID", storeid);
using (cmd.Connection = new FbConnection(ConnString))
{
cmd.Connection.Open();
var result = cmd.ExecuteScalar();
thecost = Convert.ToDouble(result);
}
I also have a stored procedure defined as follows:
create procedure PRODUCT_OUT_1
(BARCODE VarChar(25), QTY Double Precision, QTY_IS_DIFF Char(1))
returns (NEW_QTY Double Precision, AVG_COST Double Precision)
as
...
How would I call the above SP and retrieve both the values of NEW_QTY and
AVG_COST?
-Joe
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2013-01-11 11:48:18
|
Installer should modify also x64 machine config
-----------------------------------------------
Key: DNET-481
URL: http://tracker.firebirdsql.org/browse/DNET-481
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 3.0.2.0, 3.0.1.0, 3.0.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: Jiri C. <di...@ci...> - 2013-01-11 07:32:59
|
On Fri, Jan 11, 2013 at 8:00 AM, Joseph Martinez <jo...@jm...> wrote:
> Is there any way possible in .NET to call a stored procedure and retrieve
> the output parameter?
Sure. Just use FbCommand.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Joseph M. <jo...@jm...> - 2013-01-11 07:00:45
|
Ok, thanks. Is there any way possible in .NET to call a stored procedure
and retrieve the output parameter?
-Joe
On Thu, Jan 10, 2013 at 9:43 PM, Jiri Cincura <di...@ci...> wrote:
> On Thu, Jan 10, 2013 at 6:24 PM, Joseph Martinez <jo...@jm...>
> wrote:
> > Ok, so you're saying that without changing the SP, there's no way to
> > retrieve the result via ExecuteStoreQuery? If that's the case, do you
> know
> > of any other method to run the query and retrieve the scalar result from
> > .NET?
>
> This is not a scalar result. It's result it output parameter.
>
> > By the way, do you think this could also be the issue with me being
> unable
> > to import the SP's into Entity Framework (see other thread)?
>
> Yes.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
> much more. Get web development skills now with LearnDevNow -
> 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122812
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
|
From: Jiri C. <di...@ci...> - 2013-01-11 05:44:10
|
On Wed, Jan 9, 2013 at 7:27 PM, Joseph Martinez <jo...@jm...> wrote:
> Do you see anything about it that may cause it to not get imported?
The procedure is not selectable.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Jiri C. <di...@ci...> - 2013-01-11 05:43:53
|
On Thu, Jan 10, 2013 at 6:24 PM, Joseph Martinez <jo...@jm...> wrote:
> Ok, so you're saying that without changing the SP, there's no way to
> retrieve the result via ExecuteStoreQuery? If that's the case, do you know
> of any other method to run the query and retrieve the scalar result from
> .NET?
This is not a scalar result. It's result it output parameter.
> By the way, do you think this could also be the issue with me being unable
> to import the SP's into Entity Framework (see other thread)?
Yes.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Joseph M. <jo...@jm...> - 2013-01-10 17:24:42
|
Ok, so you're saying that without changing the SP, there's no way to
retrieve the result via ExecuteStoreQuery? If that's the case, do you
know of any other method to run the query and retrieve the scalar result
from .NET?
By the way, do you think this could also be the issue with me being unable
to import the SP's into Entity Framework (see other thread)?
-Joe
On Thu, Jan 10, 2013 at 2:39 AM, Jiri Cincura <di...@ci...> wrote:
> The procedure needs to be selectable.
>
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122712
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
|
From: Jiri C. <di...@ci...> - 2013-01-10 10:40:15
|
On Wed, Jan 9, 2013 at 6:03 PM, Joseph Martinez <jo...@jm...> wrote:
> What output log would I look at, and how?
Output from FirebirdClient, it uses TraceSource, so you can see it in
attached listeners. If you attach VS, the default listener is going to
write to Output Window.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Jiri C. <di...@ci...> - 2013-01-10 10:39:18
|
The procedure needs to be selectable.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Joseph M. <jo...@jm...> - 2013-01-09 22:19:25
|
I have a stored procedure in my database that returns a scalar value (a
double). I am trying to figure out how to get the results via
ExecuteStoreQuery, using Entity Framework. Here is my c# code:
var db = new MyEntities();
var oc = ((IObjectContextAdapter)db).ObjectContext;
string myquery = "execute procedure PREDICT_COST_1 ('12345',1)";
var result = oc.ExecuteStoreQuery<double>(myquery);
double thecost = result.First<double>();
If I set a breakpoint before the last line and inspect the result variable,
it is an empty ObjectResult. So, the last line raises an exception when I
call First() because it is empty.
I know that the stored procedure should be returning a value, because if I
execute it directly against the database with the same parameters, it
returns the correct value.
Here's the source for my stored procedure:
create procedure PREDICT_COST_1 (BARCODE VarChar(25), STOREID INTEGER)
returns (THE_COST Double Precision) as
DECLARE VARIABLE TEMP_COST Double Precision;
BEGIN
select first 1 itemcost from orderitems A inner join orders B on A.orderid
= B.orderid
where A.itembarcode = :BARCODE and A.itemqtyordered > A.itemqtyreceived
and A.itemcost > 0 order by B.orderdate desc into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 A.vpcost from vendorproducts A inner join products B
on A.VPUPC = B.PRODBARCODE and A.VPVENDOR = B.PRODSOURCE
where B.prodbarcode = :BARCODE and A.STOREID = :STOREID and A.vpcost > 0
into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 vpcost from vendorproducts
where vpupc = :BARCODE and STOREID = :STOREID and vpcost > 0 into
:TEMP_COST;
END
END
THE_COST = TEMP_COST;
END
What am I doing wrong?
-Joe
|
|
From: Joseph M. <jo...@jm...> - 2013-01-09 18:27:27
|
Just in case it helps, here's the source for one of my SPs:
create procedure PREDICT_COST_1 (BARCODE VarChar(25), STOREID INTEGER)
returns (THE_COST Double Precision) as
DECLARE VARIABLE TEMP_COST Double Precision;
BEGIN
select first 1 itemcost from orderitems A inner join orders B on A.orderid
= B.orderid
where A.itembarcode = :BARCODE and A.itemqtyordered > A.itemqtyreceived
and A.itemcost > 0 order by B.orderdate desc into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 A.vpcost from vendorproducts A inner join products B
on A.VPUPC = B.PRODBARCODE and A.VPVENDOR = B.PRODSOURCE
where B.prodbarcode = :BARCODE and A.STOREID = :STOREID and A.vpcost > 0
into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 vpcost from vendorproducts
where vpupc = :BARCODE and STOREID = :STOREID and vpcost > 0 into
:TEMP_COST;
END
END
THE_COST = TEMP_COST;
END
Do you see anything about it that may cause it to not get imported?
-Joe
On Wed, Jan 9, 2013 at 9:03 AM, Joseph Martinez <jo...@jm...>wrote:
> Jiri,
>
> I'm not familiar with Trace API. What output log would I look at, and how?
>
> -Joe
>
>
> On Wed, Jan 9, 2013 at 5:13 AM, Jiri Cincura <di...@ci...> wrote:
>
>> Without any further clue, it's hard to guess. Is the database queried
>> for SPs? Do you see the query (TraceAPI, Output log, ...)?
>>
>> --
>> Jiri {x2} Cincura (x2develop.com founder)
>> http://blog.cincura.net/ | http://www.ID3renamer.com
>>
>>
>> ------------------------------------------------------------------------------
>> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
>> and much more. Keep your Java skills current with LearnJavaNow -
>> 200+ hours of step-by-step video tutorials by Java experts.
>> SALE $49.99 this month only -- learn more at:
>> http://p.sf.net/sfu/learnmore_122612
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
|
211 messages has been excluded from this view by a project administrator.
