"ftLargeInt expected but ftFmtBCD found" error in both Delphi 7 and the patched 7.1

From: Joe Gilkey (jgilkey_at_napcosecurity.com)
Date: 11/18/04

  • Next message: Del M: "Re: Copy a table to another on different DB" 
    Date: Thu, 18 Nov 2004 12:32:56 -0500

    I'm trying to fix a section of code that was written a long time ago, and is
    now giving me problems. I have an ADOQuery on a datamodule with persistent
    fields. A background thread runs a separate query to get the data, and
    copys the _Recordset property from the background query to the main query
    when the data is available. This is all working ok, except when I have to
    copy a recordset that has a BigInt field. When that happens, I get an error
    saying "ftLargeInt expected but ftFmtBCD found". I am using SQL Server 2000
    SP3 as the database server. I have tested this both with and without the
    patch for Delphi, and have the same results. This problem is only happening
    on Win2003 machines and a WinXP Pro machine that has previously had a beta
    copy of SQL Server 2005. I am thinking it is probably an MDAC problem, but
    I would like to know if anyone else has had this problem before, or knows of
    a solution.

    Thanks,
    Joe

  • Next message: Del M: "Re: Copy a table to another on different DB"

    Relevant Pages

    • Re: CONTAINS performance
      ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
      (microsoft.public.sqlserver.fulltext)
    • Re: Indexing Service, Openquery and sp_executesql
      ... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
      (microsoft.public.sqlserver.fulltext)
    • Re: Problem using Access or Query Designer to run queries in SQL Serve
      ... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ... >[ODBC SQL Server Driver] Timeout Expired ...
      (microsoft.public.sqlserver.odbc)
    • Re: Transaction Isolation Level
      ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
      (comp.databases.ms-sqlserver)
    • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
      ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
      (microsoft.public.dotnet.framework.adonet)