Data Adapter Configuration Wizard does not support over 100 columns ?

[Marina]

I think that is how that works. I recommend you don't use the wizard in any
case, as I think it is preferrable to code everything by hand. That way you
know exactly what the code is, and you don't have to deal with wizard bugs.

"RadekP" <radek@aldec.com> wrote in message
news:eawtXxEWDHA.484@TK2MSFTNGP09.phx.gbl...

> Hi All
>
> I encounter very limiting behavior of Data Adapter Configuration Wizard

when

> trying to select over 100 columns from SQL DB (either individually or by
> "*"). The error screen is attached. It is SQL 7.0 though. Is it just me ?
> Can anybody share similar experience ?
>
> Thanks. Best Regards
>
> Radek
>
>
>

[Brian P. Hammer]

I think with the wizards, you can use them to create selects but not any
update, insert or delete commands. The way I worked around it was to only
select 100 items, create another da and then select the rest. Use a ds to
display all records. Don't know if this will work in your case.

All this said, I went back to coding it all by hand.

--
Brian P. Hammer
"RadekP" <radek@aldec.com> wrote in message
news:eawtXxEWDHA.484@TK2MSFTNGP09.phx.gbl...

> Hi All
>
> I encounter very limiting behavior of Data Adapter Configuration Wizard

when

> trying to select over 100 columns from SQL DB (either individually or by
> "*"). The error screen is attached. It is SQL 7.0 though. Is it just me ?
> Can anybody share similar experience ?
>
> Thanks. Best Regards
>
> Radek
>
>
>

[RadekP]

Thanks. I will handle that. At least I know I'm not the only one
experiencing the problem. It's a rather cumbersome bug ..

Radek


"Brian P. Hammer" <bphammer@SpamMeNotCAAP.com> wrote in message
news:OJ6xl4UWDHA.3924@tk2msftngp13.phx.gbl...

> I think with the wizards, you can use them to create selects but not any
> update, insert or delete commands. The way I worked around it was to only
> select 100 items, create another da and then select the rest. Use a ds to
> display all records. Don't know if this will work in your case.
>
> All this said, I went back to coding it all by hand.
>
> --
> Brian P. Hammer
> "RadekP" <radek@aldec.com> wrote in message
> news:eawtXxEWDHA.484@TK2MSFTNGP09.phx.gbl...

> > Hi All
> >
> > I encounter very limiting behavior of Data Adapter Configuration Wizard

> when

> > trying to select over 100 columns from SQL DB (either individually or by
> > "*"). The error screen is attached. It is SQL 7.0 though. Is it just me

?

> > Can anybody share similar experience ?
> >
> > Thanks. Best Regards
> >
> > Radek
> >
> >
> >

>
>