Max column limits in Query Builder of a data adapter?

  • Thread starter Thread starter MR
  • Start date Start date
M

MR

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
 
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
 
Back
Top