DataAdapter: Maximum length SQL statement?

[Guest]

Hi,

I am trying to configure a dataAdapter in Visual Studio 2003, using the
wizard.
I tried using the SQL statement, "SELECT * FROM table"
When i preview the output in de Query builder everything seems to work fine.
But when i finish the wizard, i get an error: "There were errors generating
the dataadapter".
So i started adding the table fields one by one, and it kept working fine,
until i added about the 50th field, after that the error appeared again.
So to me it seems there is a maximum in the amount of fields you can add to
a dataadapter.
Maybe alot of fields cause the wizard to create a SQL statement(Select or
Update) wich is too long.

Anyone who knows anything about this?

 

[Val Mazur \(MVP\)]

Hi,

I believe it is an issue with the wizard, not with the DataAdapter itself.
Try to create it using code, not a wizard