PC Review


Reply
Thread Tools Rate Thread

Could not retrieve schema info

 
 
Robert Bravery
Guest
Posts: n/a
 
      14th Nov 2007
Hi all,
Using VS 2005 and MSSQL 2005.
I created a view with the following:
select Brandid
, products = left(o.list, len(o.list)-2)
from lstBrand
cross apply
(
select Convert(varchar(200), ProductName)+', ' as [text()]
from lstProduct
where lstBrand.BrandId = lstProduct.BrandId
for XML Path('')
) o (list)

I then tried to add this view to a typed dataset, but get an error "Could
not retrieve schema from table or view"
But as soon as I remove the apply operator, it works.
Can some one shed some light and help

Thanks
Robert


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How To Retrieve Database Schema? Axel Dahmen Microsoft ADO .NET 4 18th Nov 2008 09:22 PM
Retrieve schema from ADP or ADE =?Utf-8?B?SmFtZXNFTA==?= Microsoft Access External Data 0 8th Nov 2005 04:07 PM
Can't retrieve any schema info in UDB =?Utf-8?B?RGF2eSBD?= Microsoft ADO .NET 1 10th Feb 2005 05:09 PM
Re: Retrieve Schema Information by Using GetOleDbSchemaTable Paul Clement Microsoft ADO .NET 0 26th May 2004 07:17 PM
Re: Retrieve Schema Information by Using GetOleDbSchemaTable Val Mazur Microsoft ADO .NET 0 26th May 2004 02:16 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:01 AM.