Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
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
  #1 (permalink)  
Old February 24th, 2006, 11:28 AM
Authorized User
 
Join Date: Sep 2003
Location: Delhi, Delhi, India.
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to prabodh_mishra
Default Oracle Nested Tables

Hi all,

My VB program crashes everytime I select a table with nested
tables in it. I know we can fetch values from such tables
using stored procedure but I wanna know is there any way that we
can hold such data in a recordset(ADO)?

Thanks in advance

__________________
Prabodh
  #2 (permalink)  
Old April 26th, 2006, 12:15 PM
Authorized User
 
Join Date: Mar 2006
Location: Chennai, Tamil Nadu, India.
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Raghunathan
Default

hi,

we can fetch rows from nested tables in oracle or sqlsvr using the join conditions, with the help of ADO in VB.

in order to solve your problem, i need to know the exact scenario of wat you're trying to do.

so if u can send the queries, tables and the coding that u tried in vb. i can surely help u out with this problem ASAP


Regards,
Raghu


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to pull excel data into oracle tables yogeshyl Oracle 1 January 9th, 2008 12:38 PM
Write Nested XML document into SQL Server tables boondocksaint20 VB.NET 0 May 2nd, 2006 12:35 PM
Nested tables prabodh_mishra Oracle ASP 0 February 27th, 2006 09:59 AM
How do I get a list of all tables of Oracle DB? amjad_mahmood Excel VBA 0 August 5th, 2005 06:56 AM
Complex (to me) nested queries spanning 4 tables! bobburke SQL Language 1 April 23rd, 2004 10:54 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.