Delphi BDE ('Type mismatch for field "xxxx", expecting: Integer actual: Float')

2010-05-21  来源:本站原创  分类:Tech  人气:515 

Encountered this problem, the database of a field, such as l_id type is number (10)
IDE: delphi5;
Database connection: BDE
Database: oracle 10.2.0

Problem when adding fields, l_id is number (10) fair to say add fields should correspond to the TIntegerField
But the results are elected TFloatField.
Pas and dfm manually edit the file type field, will be set to true error TQuery
('Type mismatch for field "xxxx", expecting: Integer actual: Float')
Connection is not the

For here, there should be a type conversion problem, why would have been a integer delphi, bde to identify precisely, into float. google about Chinese web page first, some people have encountered the problem, but no one answers, or not fully buttoned
CodeGear, finally found suggests:
http://www.tek-tips.com/viewthread.cfm?qid=75814&page=352

Highlights in this section:
There is an TIntegerField which is receiving a field from a query. The declaration of the field in the database is number (10, 0). It is a known attribute of Oracle that all number fields are stored internally as floats. The automatic conversion of these fields in BDE is governed by settings in the BDE Admin utility under the Configuration / Drivers / Native key. For Oracle 8i to enable the return of integers you must change the entries for DLL32, Vendor Init and enable integers. This much I think is true.

Check my BDEADMIN, drivers in the native-oracle, the will enable integer set to true, shut down restart effect, to D5 pilot, NND, still does not work. Then check the database of built examples, there is also a enable integer, to edit and try again, finally able to identify TIntegerField the.

Analysis] [Oracle is not integral to this concept, only one data type, number, integer and floating-point can Definition, eventually the Oracle stored in Du Bei Cun to float (in the end Du Shi Qi Shi Zi Fuchuan ); the BDE data type conversion in the control switch is normally set to false (except integer addition there are BCD). Necessary to open.

[Comments] BDE Murder Case

[Conclusion] Delphi really goes down, the attention to those little ...

相关文章
  • Delphi BDE ('Type mismatch for field "xxxx", expecting: Integer actual: Float') 2010-05-21

    Encountered this problem, the database of a field, such as l_id type is number (10) IDE: delphi5; Database connection: BDE Database: oracle 10.2.0 Problem when adding fields, l_id is number (10) fair to say add fields should correspond to the TIntege

  • argument type mismatch FORMFILE 2008-08-09

    Upload pictures with the struts out of this error: argument type mismatch org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod ... Long time no read Cuoa ~ Only later did I find the original page FORM forgot to set the enctype value of the. Re

  • File upload using struts tags Times argument type mismatch 2010-04-13

    File upload using struts tags Times argument type mismatch 1. Must be in html: form below to add enctype = "multipart / form-data" 2. We should change the post method EG: FROM: public class CustomerForm extends ActionForm ( FormFile file; public

  • Execute VBA script code says "type mismatch" 2010-10-15

    Leadership meeting yesterday to talk about a report on the operation support system needs of data processing, that is, to an excel sheet in a excel copy data to another table, also can be operated manually, in order to liberate the workforce, Operati

  • argument type mismatch exception solution 2010-12-30

    We are using struts framework for project development, the Council passed the form to submit data. Data includes a text box to receive directly from the user input, but also the way by importing a file, and import of local pictures. Directly from the

  • Delphi's type and a pointer 2011-01-03

    First statement: Do not I say these things as a textbook, this is my humble opinion; also want correction. Delphi pointer into "pointer type" and "non-pointer type" categories. Delphi, the type commonly used there must be hundreds, we

  • LIBTUX_CAT: 590: ERROR: Unable to read the TUXCONFIG file, version type mismatch 2011-06-20

    Executive tmboot-y command, throwing the following error message: 174341.hp16042! BBL.3476.3086006480.0: 06-13-2011: Tuxedo Version 10.3.0.0, 32-bit, Patch Level (none) 174341.hp16042! BBL.3476.3086006480.0: LIBTUX_CAT: 590: ERROR: Unable to read the

  • TimeStamp type in the field of Hinbernate small example of processing 2010-08-11

    Suddenly came a demand for the system to change all the time all the TimeStamp field type, since the use of the Hibernate persistence layer technology; here to do a little of the demo.

  • System.Data.OleDb.OleDbException: standard expression data type mismatch 2010-08-19

    When you use the numeric type of variable, use @ ID this error occurs because the conversion into ID = '1 ' Access database is really good trouble. I remember this problem occurs when new to asp.net issue. Results again they encountered this problem

  • Update ", 65,67,68,69," this type of Id field 2011-01-20

    ---- Update remove hw_dmt_zdk_test table stuname field '67 ' update hw_dmt_zdk_test t set t.stuname = (case when instr (t.stuname, '67 ', 1,1)> 0 then replace (replace (t.stuname, '67',''),',,',',') else t.stuname end)

  • SQL-SERVER2000 field data type abbreviations 2010-11-18

    Table 1: SQL-SERVER2000 field data type abbreviation table field data type abbreviation meaning sql_variant sv values of different data types stored Numeric integer int integer value, with 4 bytes to store bigint bint integer value, with 8 bytes to s

  • Modify the oracle varchar2 type field length report "ORA-00904: invalid identifier" error 2010-12-20

    Today, I want to modify the oracle varchar2 type in the field length report "ORA-00904: invalid identifier" error, The original sql is alter table AC_ARCHIVESSCOPE modify SCOPE VARCHAR2 (1000); Later, the above statement into the following amend

  • Finishing: Oracle field type changes 2011-02-28

    1, if the field is simply a big change, such as numeric (16,2 )---> numeric (16,4), can be directly alter table table name modify (field name numeric (16,4) 2, due to changes in demand, now to a type NUMBER (8,2) field types to char. General idea is

  • MySQL field data type / length 2011-03-09

    1, the value type Column type storage needs TINYINT 1 byte SMALLINT 2 bytes MEDIUMINT 3 bytes INT 4 bytes INTEGER 4 bytes BIGINT 8 bytes FLOAT (X) 4 if X <= 24 or 8 if 25 <= X <= 53 FLOAT 4 bytes DOUBLE 8 bytes DOUBLE PRECISION 8 bytes REAL 8 byt

  • sqlite field type selection 2011-06-09

    char, varchar, text, and nchar, nvarchar, ntext difference 1, CHAR. Fixed-length CHAR data storage easy, CHAR field index on the high efficiency level, such as the definition of char (10), then regardless of whether you store the data of 10 bytes, ha

  • mysql command-line commands and SQL statements, MySQL modify delete increase the field type, field data, etc. 2011-06-15

    I. Common mysql command-line command 1 Start service net start mysql MYSQL Stop service net stop mysql MYSQL 2. Netstat-na | findstr 3306 view was listening port, findstr to find the back of the port for the existence of 3. MYSQL landing on the comma

  • [Transfer] mysql command-line commands and SQL statements, MySQL modify delete add field type, field data, etc. .. 2011-08-23

    I. Common mysql command-line command 1 Start service net start mysql MYSQL Stop service net stop mysql MYSQL 2. Netstat-na | findstr 3306 view was listening port, findstr to find the back of the port for the existence of 3. MYSQL landing on the comma

  • DELPHI based development skills 2011-05-03

    DELPHI basic development skills ◇ [DELPHI] My Network Places to copy files uses shellapi; copyfile (pchar ('newfile.txt'), pchar ('/ / computername / direction / targer.txt'), false); ◇ [DELPHI] the mouse drag effect produced by MouseMove event, Drag

  • hibernate mapping type 2010-03-03

    Hibernate mapping types are divided into two types: built-in mapping types and custom mapping types. Built-in mapping types for some common Java types mapped to the corresponding SQL type; In addition, Hibernate allows the user to achieve UserType or

  • Access to read and write in asp Notes (memo) type data 2010-04-06

    A while ago, to do with the Asp site, access the database to do, due to store large amounts of text information, so the type of a field to note, from this disaster will follow. When in this field to write notes or read content and the content of more