Code Inline SQL

Posted on 2005-05-10
Last Modified: 2012-05-05
What does it mean when asked "Is all code inline sql in your application?"  I am building a VB.NET application that stores into MS Access, and has not queries.
Question by:RenitlahHelp
    LVL 96

    Accepted Solution

    Example of a definition of inline SQL:

    An alternative to inline SQL for ADO developers:,39026552,20273274,00.htm

    "While inline SQL does work, it really isn’t very efficient, especially when SQL statements are embedded in loops, because each time the SQL command is executed, the database must parse it to determine its validity and then compile or interpret it".

    LVL 96

    Expert Comment

    by:Bob Learned
    Intermediate Microsoft Jet SQL for Access 2000:

    Inline Code
    Using SQL statements inline means that you use the SQL statements within the Visual Basic for Applications (VBA) programming language. Although a deep discussion of how to use VBA is outside the scope of this article, it is a simple task to execute SQL statements in code.

    In the acIntSQL database, there are two forms that use inline SQL statements that are executed through the Jet OLE DB provider and ADO: The Intermediate DDL Statements form demonstrates the data definition statements, while the Intermediate DML Statements form demonstrates the data manipulation statements.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Normally a window is moved by clicking on the caption bar and dragging. You may want your user to be able to move borderless forms or move a form by clicking anywhere in the form without the limitation to the caption bar. There are many ways to do i…
    A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    760 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

    8 Experts available now in Live!

    Get 1:1 Help Now