Changing ADO Recordset Field Type

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB Databases
Changing ADO Recordset Field Type

Pro VB Databases Advanced-level VB coding questions specific to using VB with databases. Beginning-level questions or issues not specific to database use will be redirected to other forums.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

January 18th, 2004, 02:54 AM

Niaz

Authorized User

Join Date: Jun 2003

Posts: 25

Thanks: 0

Thanked 0 Times in 0 Posts

Changing ADO Recordset Field Type

I have an ADO Recordset extracted from Oracle Database Connection. Although the Table was created with Integer Column, Oracle mapped this Column as NUMBER(38). I was unable to modify the field as Integer. ADO recordset uses adNumeric for this field. I need to convert this to adInteger. Can anyone suggest a solution of this problem

Thanks in advance.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clone DAO Recordset into ADO Recordset	kamrans74	VB How-To	0	March 6th, 2007 11:57 AM
Reference ADO Recordset Field after CommitTrans	U.N.C.L.E.	Classic ASP Professional	5	November 21st, 2006 03:20 AM
Chapter 3 : type changing	frjacquemin	BOOK: Beginning Mac OS X Programming	3	November 14th, 2005 10:02 PM
Changing data type	JLN	Pro VB 6	1	July 13th, 2004 12:49 PM
Convert ADO recordset to DAO recordset	andrew_taft	Access	1	May 5th, 2004 02:31 PM