Refresh SQL_CURSOR_FORWARD_ONLY

Hi,
I'm trying to refresh (re-read) the current row of an forward only cursor
but SQLFetchScroll and SQLSetPos will fail for this kind of Cursor. Is there
any way to do that?
Regards,
Michael Sterzl[GSD]"Michael Sterzl" <msterzl@.gsd-software.com> wrote in message
news:%23dBdajxtGHA.4752@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I'm trying to refresh (re-read) the current row of an forward
> only cursor but SQLFetchScroll and SQLSetPos will fail for this
> kind of Cursor. Is there any way to do that?
> Regards,
> Michael Sterzl[GSD]
No. You can't scroll a forward only cursor.
- Arnie

Reference report outside of current project

Hi, I am migrating across some reports from 2000 and some of the
reports reference reports outside of the current project when a person
clicks on a value.
In the report designer under Navigation -> Jump to report the report
has the following value
\parentFolder\Report Name
Under 2005, when I try to do this I get the following error
Item names cannot contain the following reserved characters ;?:@.&=+$,
\*<>|"
So, how can I navigate to a report outside the current folder/
project?
Thanks for any help
MarkusOn May 1, 8:52 pm, Markus...@.gmail.com wrote:
> Hi, I am migrating across some reports from 2000 and some of the
> reports reference reports outside of the current project when a person
> clicks on a value.
> In the report designer under Navigation -> Jump to report the report
> has the following value
> \parentFolder\Report Name
> Under 2005, when I try to do this I get the following error
> Item names cannot contain the following reserved characters ;?:@.&=+$,
> \*<>|"
> So, how can I navigate to a report outside the current folder/
> project?
> Thanks for any help
> Markus
You can either add the report to the current project (via right-
clicking the Reports folder in the Solution Explorer and select Add ->
Existing Item) -or- you can access the outside report via Jump to URL
(assuming you have already uploaded it to the Report Server). Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On May 2, 12:30 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On May 1, 8:52 pm, Markus...@.gmail.com wrote:
>
>
> > Hi, I am migrating across some reports from 2000 and some of the
> > reports reference reports outside of the current project when a person
> > clicks on a value.
> > In the report designer under Navigation -> Jump to report the report
> > has the following value
> > \parentFolder\Report Name
> > Under 2005, when I try to do this I get the following error
> > Item names cannot contain the following reserved characters ;?:@.&=+$,
> > \*<>|"
> > So, how can I navigate to a report outside the current folder/
> > project?
> > Thanks for any help
> > Markus
> You can either add the report to the current project (via right-
> clicking the Reports folder in the Solution Explorer and select Add ->
> Existing Item) -or- you can access the outside report via Jump to URL
> (assuming you have already uploaded it to the Report Server). Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
Hi Enrique, I need to pass parameters between the reports so I doubt
that I will be able to use the "Jump to URL"
So, there is no way of climbing up a directory like I did in 2000/
2003?
Thanks
Markus

Refer to ROWGUID col in update trigger

When writing an Update trigger on a table that has a UniqueIdentifier as the
primary key, how to I refer to the current row being updated.
I am used to using @.@.identity when working with primary keys that are of
type int but a UniqueIdentifier cannot be an identity column. I suspect it
has something to do with the "Is ROWGUID" property but I can't find the
function for getting the GUID of the row being updated.
Thanks,
Andrew.There isn't one. If you need to know this then you should generate the Guid
beforehand and use it in the insert statement.
--
Andrew J. Kelly
SQL Server MVP
"Andrew" <sql@.ses.ca> wrote in message
news:u3lnbAiRDHA.2636@.TK2MSFTNGP10.phx.gbl...
> When writing an Update trigger on a table that has a UniqueIdentifier as
the
> primary key, how to I refer to the current row being updated.
> I am used to using @.@.identity when working with primary keys that are of
> type int but a UniqueIdentifier cannot be an identity column. I suspect
it
> has something to do with the "Is ROWGUID" property but I can't find the
> function for getting the GUID of the row being updated.
> Thanks,
> Andrew.
>|||I want to access the row that is being updated, not inserted. The GUID is
already there.
Does this mean it is not possible to use a trigger to update a
"DateOfLastUpdate" field if the primary key is a GUID? I realize date could
be updated if the update was performed using a stored procedure but I feel
it would be safer to have this functionality on the table itself.
Thanks,
Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%237WJLGiRDHA.1552@.TK2MSFTNGP10.phx.gbl...
> There isn't one. If you need to know this then you should generate the
Guid
> beforehand and use it in the insert statement.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Andrew" <sql@.ses.ca> wrote in message
> news:u3lnbAiRDHA.2636@.TK2MSFTNGP10.phx.gbl...
> > When writing an Update trigger on a table that has a UniqueIdentifier as
> the
> > primary key, how to I refer to the current row being updated.
> >
> > I am used to using @.@.identity when working with primary keys that are of
> > type int but a UniqueIdentifier cannot be an identity column. I suspect
> it
> > has something to do with the "Is ROWGUID" property but I can't find the
> > function for getting the GUID of the row being updated.
> >
> > Thanks,
> > Andrew.
> >
> >
>|||> You threw me off when you mentioned @.@.IDENTITY. @.@.IDENTITY has nothing to
> do with an UPDATE, it is only useful for Inserts. Any time you want to
> reference a row that is being updated in a trigger you can use the
Inserted
> table. To update a datetime column you would simply do this:
> UPDATE YourTable SET ModDate = GETDATE()
> WHERE PK IN (SELECT i.PK FROM Inserted as i)
> This way it works when more than 1 rows is updated and there is no need to
> know what the actual value of the PK is.
I tend to use a wrapper like:
IF NOT UPDATE(ModDate)
Just to prevent recursion. :-)|||Thanks for your help. I had just "discovered" the inserted table but the
method I came up with is not as clean as yours.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uiAkt8iRDHA.3236@.TK2MSFTNGP10.phx.gbl...
> You threw me off when you mentioned @.@.IDENTITY. @.@.IDENTITY has nothing to
> do with an UPDATE, it is only useful for Inserts. Any time you want to
> reference a row that is being updated in a trigger you can use the
Inserted
> table. To update a datetime column you would simply do this:
> UPDATE YourTable SET ModDate = GETDATE()
> WHERE PK IN (SELECT i.PK FROM Inserted as i)
> This way it works when more than 1 rows is updated and there is no need to
> know what the actual value of the PK is.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Andrew" <sql@.ses.ca> wrote in message
> news:u53MXdiRDHA.2424@.tk2msftngp13.phx.gbl...
> > I want to access the row that is being updated, not inserted. The GUID
is
> > already there.
> >
> > Does this mean it is not possible to use a trigger to update a
> > "DateOfLastUpdate" field if the primary key is a GUID? I realize date
> could
> > be updated if the update was performed using a stored procedure but I
feel
> > it would be safer to have this functionality on the table itself.
> >
> > Thanks,
> > Andrew
> >
> >
> > "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> > news:%237WJLGiRDHA.1552@.TK2MSFTNGP10.phx.gbl...
> > > There isn't one. If you need to know this then you should generate
the
> > Guid
> > > beforehand and use it in the insert statement.
> > >
> > > --
> > >
> > > Andrew J. Kelly
> > > SQL Server MVP
> > >
> > >
> > > "Andrew" <sql@.ses.ca> wrote in message
> > > news:u3lnbAiRDHA.2636@.TK2MSFTNGP10.phx.gbl...
> > > > When writing an Update trigger on a table that has a
UniqueIdentifier
> as
> > > the
> > > > primary key, how to I refer to the current row being updated.
> > > >
> > > > I am used to using @.@.identity when working with primary keys that
are
> of
> > > > type int but a UniqueIdentifier cannot be an identity column. I
> suspect
> > > it
> > > > has something to do with the "Is ROWGUID" property but I can't find
> the
> > > > function for getting the GUID of the row being updated.
> > > >
> > > > Thanks,
> > > > Andrew.
> > > >
> > > >
> > >
> > >
> >
> >
>