Development Center

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Anthony Robinson
    #1

    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.
    Tags: None
    • Pete H
      #2
      Re: Development Center

      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
      ansonee@yahoo.c om (Anthony Robinson) wrote in message news:<d18e85f8. 0310301035.6b67 9b27@posting.go ogle.com>...[color=blue]
      > 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.[/color]

        Comment

        • ansonee
          #3
          Re: Development Center


          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

            Comment

            Previous template Next
            Working...