Max column limits in Query Builder of a data adapter? -- c#

MR
3/4/2004 11:19:52 PM

Is there a limitation to the number of columns you can define in the Query
Builder of a data adapter? it seems the limit is around 96. i know i can
split the query into two parts, but then it would increase the number of
total queries i have to make by a factor or 2.
i tried using Select * but that didn't work.
is this a real limit? can i work around it somehow?
thanks for your help
m

adam.pridmore NO[at]SPAM threex.co.uk
3/5/2004 8:55:55 AM

In short there is a limit to the total number of colums that it can
generate an Adapter for. But don't forget the Query Builder just
generate Command/Adapter objects with appropriate sql loaded - which
you can do manually.

I've never been that big a fan of the Query Builder, and I usually end
up writting my own objects to access the date. Do any other people
actually use the Query Builder in real applications? Just curious...

Adam

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about c#

c# : Max column limits in Query Builder of a data adapter?