470,636 Members | 1,462 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

Development Center

I'm used to working with the old reliable Stored Procedure Builder in
Version 7. You created a project and made your database connection -
just like version 8.

Here's where I am running into confusion/issues:
I wrote an SQL stored procedure built it and it compiled just fine. I
go to the Server View in the Development Center and there it is - fat
and happy. Even the object count reflects the difference between what
is visible in Control Center and what is displayed in the Server View.
I go into Control Center and do not see it anywhere. I have refreshed,
disconnected, restarted, chanted, and still do not see the stored
procedure anywhere!?!?!

There are no filters on in Control Center...WHERE IS THIS STORED
PROCEDURE?!?

ANY help would be greatly appreciated.
Nov 12 '05 #1
2 2052
Does the stored procedure have any parameters? If not, you may have
run into a bug that stunped me for awhile... Not sure if it got fixed
with FP3, but there was a problem with SPs being "invisible" when they
had no parms. HTH

Pete H
an*****@yahoo.com (Anthony Robinson) wrote in message news:<d1**************************@posting.google. com>...
I'm used to working with the old reliable Stored Procedure Builder in
Version 7. You created a project and made your database connection -
just like version 8.

Here's where I am running into confusion/issues:
I wrote an SQL stored procedure built it and it compiled just fine. I
go to the Server View in the Development Center and there it is - fat
and happy. Even the object count reflects the difference between what
is visible in Control Center and what is displayed in the Server View.
I go into Control Center and do not see it anywhere. I have refreshed,
disconnected, restarted, chanted, and still do not see the stored
procedure anywhere!?!?!

There are no filters on in Control Center...WHERE IS THIS STORED
PROCEDURE?!?

ANY help would be greatly appreciated.

Nov 12 '05 #2

Pete H:

My man, you are awesome!!!!! That is EXACTLY what my stored procedure
does. It just does a big select. The procedure was actually just
something I threw together to test my environment to make sure I could
build/compile stored procs.

I'm actually going to be installing FixPak 3 later today. Let's hope
that does the trick!!

Thanks again!

Anthony R.
--
Posted via http://dbforums.com
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Claude Shea | last post: by
3 posts views Thread by Henry Reardon | last post: by
1 post views Thread by Henry Reardon | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.