Can't access MSSQL numeric(16~19)

ADO can't access MSSQL numeric(16~19) if that over Currency range -922337203685477 and 922337203685477!
The ftBCD internal data is currency? If it does! Please fix source code.

unit ADODB
....
function ADOTypeToFieldType(const ADOType: DataTypeEnum;
  Precision, Scale: Integer; EnableBCD: Boolean = True): TFieldType;
begin
  case ADOType of
    ...
    adGUID: Result := ftGUID;
    adDecimal, adNumeric, adVarNumeric:
      if EnableBCD then
      begin
        // Use TFMTBcd for precision and numeric scale values that are out of
        // the range of what is supported by TBCDField and the Currency type.
       
//*********************** Please fix precision 19 to 14 ***********************//

        if (Scale > 4) or (Precision > 19) then 
          Result := ftFMTBcd else
          Result := ftBcd;
      end
      else
        Result := ftFloat;
  else
    Result := ftUnknown;
  end;
end;
....
0
jackie
11/20/2008 6:07:37 PM
embarcadero.delphi.ado 597 articles. 1 followers. Follow

0 Replies
426 Views

Similar Articles

[PageSpeed] 12

Reply:

Similar Artilces:

I can't get no cache, I can't get no cache. 'Cause I try and I try and I try and, I can't get no, I can't get no cache.
I have fiddled out for days tinkering with the setting in about:config trying to get FireFox 12 to use the disk cache. I have NOT found the trick. This One Trick Pony ain't doing it like it used to up until recently. Pray tell anyone, What information can I share that will point a knowledgeable person to aid me in getting FF to disk.cache? I have also tried restarting FF with add-ons disabled, (There were NOT too many to do this to, so it was quick and easy) Here is my stab at trying to convey the information that MIGHT govern matters Using about:cache Informatio...

Re: I can't get no cache, I can't get no cache. ' Cause I try and I try and I try and, I can't get no, I can't get no cache.
<div>please com e see me about htis<br /> <br /> ------- Original Message f= rom the Global Relay Archive -------<br /> From: Hp &lt;ferd@farkel.net&gt;= <br /> To: "support-firefox@lists.mozilla.org" &lt;support-firefox@lists.mo= zilla.org&gt;<br /> Sent: Sun, 27 May 2012 18:30:18 -0700<br /> Subject: I = can't get no cache, I can't get no cache. 'Cause I try and I try and I try = and, I can't get no, I can't get no cache.<br /> <br /></div> <pre class=3D"gr-maex-body-pre&qu...

2010: Can't register - can't download the software - can't register until I have the software
I have active maintenance on Rad Studio: From: Vicky Rassmisaengthong [mailto:Vicky.Rassmisaengthong@EMBARCADERO.COM] Sent: Wednesday, February 25, 2009 1:58 PM To: rgrossman Cc: amer.supportadmin@codegear.com; Ashley Cosentino Subject: Software Assurance Support for Tech III Inc PO# Credit Card Dear Embarcadero Technologies Support Customer, Welcome! You have been registered as the primary contact on support account number AM####### Herewith we confirm your Embarcadero Technologies support agreement covering: Qty 1 RAD Studio Enterprise Named User licens...

Can't access suse, and can't seem to reinstall it either.
Everything worked somewhat OK for about a day, since i got it installed (had problems with opening yast and couldn't update). Then today it started freezing for no reason; desktop icons disappeared, and that bottom panel too. Then when i restarted (by clicking the restart button on the machine cause nothing responded on the desktop), i got this message: "Grub read error" and could no longer get into suse. So I thought maybe if i reinstall, (this time entering a root password, cause the first time i didn't) maybe it'll work fine. But i can't seem to be abl...

Can't install Email-Send & Can't access Bugzilla in Browser
Hi All I am facing this problem for many days now and actually am stuck at this point can somebody please help me in resolving this (platform is Windows Server 2003, perl 5.8.8, Apache 2.2.4) 1) When I runchecksetup.pl command it give me error that Email Send and Emil MIME Modifier are not installed ..... I followed the instructions and run the commands but am unable to install these two C:\Bugzilla\bugzilla-3.0>ppm install Email-Send Downloading ActiveState Package Repository packlist...not modified Downloading theory58S packlist...redirect Downloading theory58S packlist...

Can't find EDM wizard (can't add ADO.NET Entity Data Model)
I'm having trouble getting started with EDM.  I'm ultimately trying to experiment with ASP.NET Data Services.  I have never installed any ASP.NET 3.5 Extensions CTPs.  However, I have installed VS2008 SP1 Beta1 and .NET 3.5 SP1 Beta 1.  Based on the list of features in SP1 Beta 1 (http://www.microsoft.com/downloads/details.aspx?familyid=8C36ACA4-E947-4760-9B05-93CAC04C6F87&displaylang=en ) I believe I should have both EDM support and Data Services support. When I try to add a new item to my VS2008 project, ADO.NET Entity Data Model is not in the list.&nb...

Easy question, but I can't figure it out. Gridview nested in datalist .. I need to access the Gridview caption, but can't
To be more clear ...The datalist contains ItemIds, the gridview contains applications ids. When the page loads I need to check the database to see if the itemid / application id link already exists and if so check the checkbox. Everyhting works, except I can't get the itemid to check the DB with. Any suggestions, what am I doing wrong? I'm getting the object reference not set to the instance of an object error. TIA,Kyle 1 <asp:DataList ID="ItemsDataList" runat="server" DataSourceID="ObjectDataSource1"> 2 <ItemTemplate> 3 <h2>Part...

Two things,Why do I keep getting emails that I don't want. can't get rid of them? Why can't I get my email when I am out of town? Or can I?
Name: Ed Leech Email: ELCraftatzoominternetdotnet Product: Thunderbird Summary: Two things,Why do I keep getting emails that I don't want. can't get rid of them? Why can't I get my email when I am out of town? Or can I? Comments: I am getting frusted with all the emails coming in that I do not want, I am using the tools to get thme out but they keep coming. They just use different names or whatever. I have been thinking of just switching to something else but my business intrusts know this email and it is tooo confusing to change. Every time I go out of town on bu...

superreview requested: [Bug 300642] Fastback regression: screen readers can't load pages : [Attachment 189358] 1) Use active window for root accessible that we return, 2) don't cache accessible root
Aaron Leventhal <aaronleventhal@moonset.net> has asked Brian Ryner <bryner@brianryner.com> for superreview: Bug 300642: Fastback regression: screen readers can't load pages https://bugzilla.mozilla.org/show_bug.cgi?id=300642 Attachment 189358: 1) Use active window for root accessible that we return, 2) don't cache accessible root since we already cache it elsewhere https://bugzilla.mozilla.org/attachment.cgi?id=189358&action=edit ...

Can't base report on stored procedure--'Can't create Datawindow'
I installed IM65 today to give it a try. I made a db config to our local ASE 11.9.2 engine via Sybase' odbc driver that came with 11.9.2. I start a new report, tell it to be tabular and to get data from a SP. It asks which SP and I tell it. The result is an odbc error: Cannot create DataWindow Intersolv SQL ODBC driver: Incorrect syntax near '='. 1 execute dbo.sp_si_addressbest_;0 RETURN_VALUE = :RETURN_VALUE' I can execute the SP fine from SQL Advantage or from Crytal Reports. Thanks. -- Frank Burleigh Indiana University School of Law Bloomi...

superreview granted: [Bug 300642] Fastback regression: screen readers can't load pages : [Attachment 189358] 1) Use active window for root accessible that we return, 2) don't cache accessible root si
Brian Ryner <bryner@brianryner.com> has granted Aaron Leventhal <aaronleventhal@moonset.net>'s request for superreview: Bug 300642: Fastback regression: screen readers can't load pages https://bugzilla.mozilla.org/show_bug.cgi?id=300642 Attachment 189358: 1) Use active window for root accessible that we return, 2) don't cache accessible root since we already cache it elsewhere https://bugzilla.mozilla.org/attachment.cgi?id=189358&action=edit ...

Can access class during debugging but can't access class on server
I have a class Test.cs with some methods in the root directory of my web application project along with my other aspx & cs files (class source is displayed below). When I try to access those methods on my local machine, I can access them fine and it works fine for me when I run debug. But when I publish the web app to a folder and copy the stuff on to the server,  I get the error printed below: Compiler Error Message: CS0246: The type or namespace name 'Test' could not be found (are you missing a using directive or an assembly reference?)  ///////////This is how I...

Can't Access Tree By Name, but I can access tree by IP
We recently updated all servers in the tree to NW6.5 SP7. Now the tree or server can't be found by name from client login, but if we input the ip address of the server it will connect. Here is the information from SLP from our DA server. SERVER_PHX:slp info SLP NLMs on this server: SLPDA.NLM majorVersion = 2 minorVersion = 13 revision = 0 SLPTCP.NLM majorVersion = 2 minorVersion = 13 revision = 0 SLP.NLM majorVersion = 2 minorVersion = 13 revision = 0 Known SLP NetWork Service Addresses (Network Order): 10.84.177.4:0427 SLP DA Address: FIRST SLP LOOPBACK ...

I can read from a XML file on my ASP.NET 2.0 page, but I can't write to it
Hello, this is the code I'm using.  I got it from a tutorial website but I can't remember.  Anyway, it reads the XML file just fine, but XMLTextWriter reports the following exception: "Access to the path 'C:\inetpub\wwwroot\wikicde\applicant.xml' is denied."=== Start of Code === <script language="VB" runat="server" ID=Script1>    Sub btnReadXML_OnClick(sender As Object, e As EventArgs)  'Read and display existing file   ReadXML(Server.MapPath("menu.xml"))End SubSub btnWriteXML_OnClick(se...

Web resources about - Can't access MSSQL numeric(16~19) - embarcadero.delphi.ado

Resources last updated: 12/10/2015 7:52:04 PM