Instant Color Coding

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Goh (Goh_at_discussions.microsoft.com)
Date: 09/02/04 

Date: Wed, 1 Sep 2004 18:13:04 -0700

May I know how to develop application (Using Visual Basic) as like SQL Query
Analyzer that color code the text as user enter the script without any delay.
Currently I use 2 For loops (The outer one used to color string and comment
while the inner one used to color the keyword) and the drawback was it took 4
seconds to color a stored procedure of approx 2500 lines.

Thank you very much if you could suggest a better solution or is there any
references I can make use of it.

Relevant Pages

  • Re: Script per Code ausführen
    ... mit dem Shell befehl startet leider nur der Analyzer mit dem Script, ... Du musst das Script per PassThrough uebergeben, ... Ansonsten gibt's auch noch den Shell ...
    (microsoft.public.de.access.clientserver)
  • Re: Profiling
    ... methods are getting called on a given invocation of a script, ... I have done so many times before: no need for a profiler. ... If it turns out that the SQL query itself is consuming the extra time, AND you do care about the 1/10 sec, you can try to optimize the query or maybe change the database. ... "There are two ways of constructing a software design: One way is to make it so simple that there are obviously no deficiencies, and the other way is to make it so complicated that there are no obvious deficiencies. ...
    (comp.lang.php)
  • Re: [PHP] Newbie question, Which way is best?
    ... I have a script that contains a form and a pagination routine that calls ... I want to pass an sql query along with some other variables to the ... problems successfully passing the SQL query string within the url. ...
    (php.general)
  • Re: Color Chooser Amendment?
    ... The purpose of this script is to enable a user to click a generated ... color cell in a table and the color code ie: ... {// Iterate green color ...
    (comp.lang.javascript)
  • Re: Newbie trying to put SQL Query into a VBScript
    ... my script works great and I thank you for helping me ... run an SQL query on the database, rather than to have to log in to each ... I have a script that I'm making to help automate ...
    (microsoft.public.scripting.vbscript)