Get 'Print' results from ExecSql command

From: Richard (abbeyroad_at_mindspring.com)
Date: 10/29/04

  • Next message: Jeremy Collins: "Re: Get 'Print' results from ExecSql command" 
    Date: Fri, 29 Oct 2004 12:54:54 -0400

    Hello,

    I have a large SQL script that is used to update a database (add new
    indexes, fields, etc.). The script outputs its progress using the 'Print'
    command, which if you run the script in SQL Analyzer you'll see the
    statements fine. I need to put this script in my Delphi program to run in
    an ADO query, but is there a way for me to get the results of the 'Print'
    statements and output them to the user so they'll see the progress? Any
    tips would be great, thanks!

  • Next message: Jeremy Collins: "Re: Get 'Print' results from ExecSql command"

    Relevant Pages

    • Re: Looking for a code snippet
      ... progress as well. ... by the searching CGI script. ... text file was written that was accessible by a client-side script through ... chunks of script code for that. ...
      (comp.lang.javascript)
    • Re: Looking for a code snippet
      ... progress as well. ... by the searching CGI script. ... (originates from DOM Level 0), DOM Level 2 methods and proprietary CSS ... support for each feature. ...
      (comp.lang.javascript)
    • Re: [SLE] Backup to CD/DVD -- recommended software?
      ... Paul W. Abrahams wrote: ... A script is. ... K3B has a nice progress bar, ...
      (SuSE)
    • Re: Copy folder with progress window
      ... in 30,000 folders seven levels deep in a script. ... but shows no sign of progress while ... parse StdOut for errors. ...
      (microsoft.public.scripting.vbscript)
    • Re: Streaming javascript and XP Service Pack 2
      ... but there was output an extra tag in my progress page. ... it seems that the script can run correctly on my side. ... here is a kb article mentioned the script in local html which ... > reference a local htc or xml file will not work, you may have a look to ...
      (microsoft.public.dotnet.framework.aspnet)