Results 1 to 2 of 2

Thread: retrieve stored procedures code

  1. Mar 29th, 2008, 06:34 AM #1
    edogar
    edogar is offline

    Thread Starter
    New Member
    Join Date
    Feb 2008
    Posts
    2

    retrieve stored procedures code

    Hi,

    Within an ADO/VBA environment, I'm already able to call a stored procedure of a Sybase Database.

    Now I'd like to retrieve the code of this stored procedure.
    It's is possible, anybody knows how?
    Reply With Quote Reply With Quote
  2. Mar 29th, 2008, 06:47 AM #2
    PilgrimPete
    PilgrimPete is offline
    Frenzied Member PilgrimPete's Avatar
    Join Date
    Feb 2002
    Posts
    1,313

    Re: retrieve stored procedures code

    I'd be surprised if it was possible using ADO.

    Does Sybase provide an object library? For example, SQL Server comes with SQLDMO, which has a StoredProcedure object that has a Text property, and an Alter method.

    The only way that I can think of in ADO is to use ADOX, and look at the Command property of the Procedure object. It's been a while since I played with ADOX though, so that may be a dead end...
    How much does it really cost to run your car?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width