SQL Data Adapter, limited to 100 fields?

  • Thread starter Thread starter Al Gerharter
  • Start date Start date
A

Al Gerharter

Hi,

I'm building a form, and tying it to a database via SQL connection,
SQLdataadapter, and a Dataset. It appears that the data adapter will not let
me select more than 100 fields in the SQL statement. Is this limit
adjustable? Thanks in advance. Al
 
Hi,

I'm building a form, and tying it to a database via SQL connection,
SQLdataadapter, and a Dataset. It appears that the data adapter will not let
me select more than 100 fields in the SQL statement. Is this limit
adjustable? Thanks in advance. Al
Click to expand...

Are you doing "SELECT *" or "SELECT col1,col2,col3,..."?
 
Hi, thanks for the quick response.

I am using the Data Adapter Configuration Wizard, which builds a select
statement like:

SELECT TBLTKT.BuyID AS Expr1, TBLTKT.Tkt AS Expr2, TBLTKT.Brn AS Expr3,
etc.

and using the query builder option, which selects files from a list, and
fields from a graphic display.


Al
 
It appears that the data adapter will not let
me select more than 100 fields in the SQL statement.
Click to expand...

<Sorry for the delay in responding...>

What makes you think the limit is 100? Are you getting errors running
the command? Pulling the data out? Accessing fields?

I don't know of any limits to the number of columns that can be
returned.
 
Back
Top