Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Question Unanswered: Problem with Procedure with gen from db

    Hi All
    I have problem with script which gen from
    " select text from syscomment where id = xxxxx (id of stor)"
    after run this command it have result like this
    select * from xxxtable where ye
    this problem some line not on correct row . How to check or fix it .Please help

    Ps: have more than 1000 procedure with I want to gen.

  2. #2
    Join Date
    Jan 2003
    Geneva, Switzerland
    The problem is that the text column from syscomments is a varchar(255), so a carriage return is added at the end of each row by isql or whatever tool you use to extract the text.

    What you need to do is to concatenate the text column values for each object and print them as a single string.

    Or use a tool such as ddlgen or to extract the procs instead of trying to roll your own...


Posting Permissions

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