Hi Dean,
The code looks like this:
DataTable dt = new DataTable("Balance");
String strsql = "SELECT UID, uname, date_start,
value_start, totalin, totalout, date_end, value_end " +
" FROM
BALANCE(@UID,@StartDate, @EndDate); " ;
FbCommand cmd = new FbCommand(strsql, fbConn);
FbDataAdapter da = new FbDataAdapter(cmd);
cmd.Parameters.AddWithValue("@StartDate",
dtpStart.Value.ToShortDateString());
cmd.Parameters.AddWithValue("@EndDate",
dtpEnd.Value.ToShortDateString());
cmd.Parameters.AddWithValue("@UID",
cmbUID.SelectedValue.ToString());
da.Fill(dt);
dgv.DataSource = dt;
Paul
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf
> Of Dean Harding
> Sent: Wednesday, March 26, 2008 1:28 PM
> To: For users and developers of the Firebird .NET providers
> Subject: suspect - [SPAM] Re: [Firebird-net-provider] Where from I get
> so many decimals?
>
> Mercea Paul wrote:
> > If I execute this SP in ISQL I get all results as numeric (15,4) but
> > from c# I get more than 4 decimals (1013,7557642)!
>
> What does your C# code look like?
>
> Dean.
>
>
> -----------------------------------------------------------------------
> --
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/market
> place
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
