Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 Expected type... error using ADO to access numbers in Oracle Table


Why am I getting "Expected type was..." error using ADO to access numbers in an Oracle table?   

    The problem lies in the fact that Integer fields in Oracle are being represented as TFloatfield in Delphi. The root of this issue is the translation done by the OLE DB PROVIDER. NUMBER and INTEGER fields in Oracle are being translated as DBTYPE_NUMERIC by the OLE DB PROVIDER. This can be verified by looking at the MDAC SDK documentation, which is available off the Microsoft web page. If the provider never returns an Integer OLE DB Data Type, you'll never get a TField that is a TIntegerField type.  



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use