SQL Alternative to cursor: newsgroup

Saturday, February 25, 2012

AMO: refresh DSV and accept changes..

I tried the sql server OLAP newsgroup, but without success... this is fairly urgent, so will try in here:
I am stumped on this, how can I programmatically do what can be done in
Visual Studio by:
1. Right clicking inside datasource view
2. Choosing refresh
3. Accepting the changes

I am trying to get new fact table columns into the DSV, obviously
without doing the manual steps above.

I have tried dsv.Refresh() and dsv.Update() but it is not as simple as
that or the sequencing is incorrect (or, most likely, I am looking in
entirely the wrong place).

Thanks for any help.

There is no programmatiic way to do refresh on DSV. However, You can use data adapter to fill schema and get a new datatable and merge the table yourself.

For adding a column, you can use data adapter to do FillSchema() with the table you want to refresh and add the new column into existing table. Finally, call DSV.Update().

|||Thanks for the response - this was pretty much the only way we could solve this as well.... but why isn't the method that MS uses to do this exposed for our use as well? It seems like they have a pretty efficient way of doing this. Nearly everything else allows you to "script the action", why not this?
|||This refresh of DSV from relational DB is part of the execution of DSV but not on AMO. Although we found that it is useful if we move the code to AMO, it is to late of the cycle. Since it has work around, so we cut this feature. We will consider it in next release. Thanks

Thursday, February 16, 2012

am i in the right place?

I would like to find a newsgroup where I could get some basic querying help.
Is this the right place, or can you reccomend another group?
Thanks,
Dana WannerThis is a multi-part message in MIME format.
--=_NextPart_000_0183_01C35B57.3F9E30C0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Actually, microsoft.public.sqlserver.programming is the place for query =help.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dana Wanner" <dwanner@.westportofficefurniture.com> wrote in message =news:eOFXsg3WDHA.652@.TK2MSFTNGP10.phx.gbl...
I would like to find a newsgroup where I could get some basic querying =help.
Is this the right place, or can you reccomend another group?
Thanks,
Dana Wanner
--=_NextPart_000_0183_01C35B57.3F9E30C0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Actually, =microsoft.public.sqlserver.programming is the place for query help.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Dana Wanner" wrote in message news:eOFXsg3WDHA.652@.T=K2MSFTNGP10.phx.gbl...I would like to find a newsgroup where I could get some basic querying =help.Is this the right place, or can you reccomend another group?Thanks,Dana Wanner

--=_NextPart_000_0183_01C35B57.3F9E30C0--|||This is a multi-part message in MIME format.
--=_NextPart_000_0027_01C35B4E.5C99DCF0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Thanks Tom!
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:%23vkaej3WDHA.2312@.TK2MSFTNGP10.phx.gbl...
Actually, microsoft.public.sqlserver.programming is the place for =query help.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dana Wanner" <dwanner@.westportofficefurniture.com> wrote in message =news:eOFXsg3WDHA.652@.TK2MSFTNGP10.phx.gbl...
I would like to find a newsgroup where I could get some basic querying =help.
Is this the right place, or can you reccomend another group?
Thanks,
Dana Wanner
--=_NextPart_000_0027_01C35B4E.5C99DCF0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Thanks Tom!
"Tom Moreau" = wrote in message news:%23vkaej3WDHA.=2312@.TK2MSFTNGP10.phx.gbl...
Actually, =microsoft.public.sqlserver.programming is the place for query help.
-- Tom

=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql

"Dana Wanner" wrote in message news:eOFXsg3WDHA.652@.T=K2MSFTNGP10.phx.gbl...I would like to find a newsgroup where I could get some basic querying help.Is this the right place, or can you reccomend another group?Thanks,Dana =Wanner

--=_NextPart_000_0027_01C35B4E.5C99DCF0--

Saturday, February 25, 2012

AMO: refresh DSV and accept changes..

Thursday, February 16, 2012

am i in the right place?

SQL Alternative to cursor

Blog Archive

About Me