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
"Patrick Steele [MVP]" <pa*****@mvps.org> wrote in message
news:MP************************@msnews.microsoft.c om...
In article <ba******************************@news.teranews.co m>,
ag******@nospam.paccomm.net says... 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
Are you doing "SELECT *" or "SELECT col1,col2,col3,..."?
--
Patrick Steele
Microsoft .NET MVP
http://weblogs.asp.net/psteele