Code Inline SQL

Posted on 2005-05-10
Medium Priority
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
  • 2
LVL 96

Accepted Solution

Bob Learned earned 2000 total points
ID: 13969548
Example of a definition of inline SQL:

An alternative to inline SQL for ADO developers:

"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
ID: 13969584
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.



Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

839 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