Showing posts with label front-end. Show all posts
Showing posts with label front-end. Show all posts

Monday, March 19, 2012

Dumb Stored Procedure Question

I've designed a very basic SQL Server Stored Procedure that I'm using
via a Visual Basic 6.0 front-end file in retrieving records into a
data entry form.

I can't for the life of me get the records retrieved via the Stored
Procedure to be edited.

I can't even run the stored procedure in MSDE's T-SQL utility and then
edit any of the records shown to me.

Any ideas?

Thanks!

Brad McCollum
bmccoll1@.midsouth.rr.comBrad H McCollum (bmccoll1@.midsouth.rr.com) writes:
> I've designed a very basic SQL Server Stored Procedure that I'm using
> via a Visual Basic 6.0 front-end file in retrieving records into a
> data entry form.
> I can't for the life of me get the records retrieved via the Stored
> Procedure to be edited.
> I can't even run the stored procedure in MSDE's T-SQL utility and then
> edit any of the records shown to me.

Since I don't know how your procedure looks like, I have to guess.

The problem is likelyl to be that ADO is to smart for its own good.
It thinks that each column must be associated with a table, so if you
say:

SELECT a, b + 'j' FROM tbl

The first column will be editable, the second not.

If you get the result set into a temp table and return from that, you
are OK. Nevermind that the temp table dies with the procedure. ADO is
easy to fool.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Sunday, March 11, 2012

Dumb Question

I know it sounds kind of dumb. Is there supposed to be a front-end portal
for "Browser" level users? Where can I find them?Yes. It is called report manager. If you have a default installation using
http://<servername>/reports should get to it.
Please see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_webui_v1_9c4u.asp
for additional information.
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JL" <JL@.discussions.microsoft.com> wrote in message
news:66452C1F-B8C9-472D-9FD6-5C5E55050020@.microsoft.com...
> I know it sounds kind of dumb. Is there supposed to be a front-end portal
> for "Browser" level users? Where can I find them?|||The Report Manager can be used to browse reports (//machine/Reports if you
kept the defaults) as well as just going to //<machine name>/reportserver.
Just make sure users have permissions to see the reports and folders the
reports are contained in.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"JL" <JL@.discussions.microsoft.com> wrote in message
news:66452C1F-B8C9-472D-9FD6-5C5E55050020@.microsoft.com...
> I know it sounds kind of dumb. Is there supposed to be a front-end portal
> for "Browser" level users? Where can I find them?|||Thanks for your response. I did install the RS successfully. I know there
is a report manager console. But I remember my instructor (RS class) once
showed us a screen with the url like "someServer/portal"..'.. That
interface has report links on the left and blue in the background. Could
this be another Microsoft product'
"Daniel Reib [MSFT]" wrote:
> The Report Manager can be used to browse reports (//machine/Reports if you
> kept the defaults) as well as just going to //<machine name>/reportserver.
> Just make sure users have permissions to see the reports and folders the
> reports are contained in.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "JL" <JL@.discussions.microsoft.com> wrote in message
> news:66452C1F-B8C9-472D-9FD6-5C5E55050020@.microsoft.com...
> > I know it sounds kind of dumb. Is there supposed to be a front-end portal
> > for "Browser" level users? Where can I find them?
>
>|||I have not seen something like you are describing. Perhaps this was
something they wrote?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"JL" <JL@.discussions.microsoft.com> wrote in message
news:20D9119D-A817-407C-878E-D01B3208367D@.microsoft.com...
> Thanks for your response. I did install the RS successfully. I know
there
> is a report manager console. But I remember my instructor (RS class)
once
> showed us a screen with the url like "someServer/portal"..'.. That
> interface has report links on the left and blue in the background. Could
> this be another Microsoft product'
> "Daniel Reib [MSFT]" wrote:
> > The Report Manager can be used to browse reports (//machine/Reports if
you
> > kept the defaults) as well as just going to //<machine
name>/reportserver.
> > Just make sure users have permissions to see the reports and folders the
> > reports are contained in.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "JL" <JL@.discussions.microsoft.com> wrote in message
> > news:66452C1F-B8C9-472D-9FD6-5C5E55050020@.microsoft.com...
> > > I know it sounds kind of dumb. Is there supposed to be a front-end
portal
> > > for "Browser" level users? Where can I find them?
> >
> >
> >