VB6 hidden SQL feature

Posted on 2007-07-25
Last Modified: 2013-12-25
I may be the only person who doesn't know this, here goes:  In my VB6 IDE, under "Query" there is a selection called 'Verify SQL syntax' - which sounds useful.  The problem is, it's always grayed out.  Under what conditions does Verify SQL syntax become an active feature?  How do I use it?  What does it do?  Is this another name for the Query Analyzer?  PLEASE enlighten me!  Thanks
Question by:wjshore
    LVL 53

    Expert Comment

    I guess that it only works if you are in teh query designer...

    Author Comment

    Don't be shy.  How do I get in the query designer?
    LVL 53

    Accepted Solution

    I can't test it here, but something like this:
    1. Open Visual Basic and create a new Standard EXE project.  
    2. On the Project menu, click Add a Data Environment.  
    3. Right click the connection, select Properties, and select OLEDB Provider for Jet 3.51.  
    4. Click the Connection tab and select the NWind.mdb by using the ellipsis button for item 1.  
    5. Right-click the connection and select "Add a Command."  
    6. Right-click Command1; select "SQL" as data source. Click SQL Build to launch the Query Designer.  

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now