Development Center

[Anthony Robinson]

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.

[Pete H]

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.

[ansonee]

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