UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> SQL Query    

clsSQLQuery generates the SQL statement for Select, Append, and Delete queries. Text versions of clsSQL Query and related classes can be downloaded from Media:clsSqlQuery.zip The zip file includes a standard module basTester for testing the query creator.

The class makes use of two 'helper' classes, clsTables and clsFields which enable Intellisens when you are coding the names of tables or fields. There is one read-only property defined in these classe for each table or field that you want to refer to in the code:

example from clsTables

CODE

Option Compare Database
Option Explicit

Friend Property Get tblAddresses() As String
   tblAddresses = "tblAddresses"
End Property

Creative Commons License
SQL Query by UtterAccess Wiki is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.
Editing and revision of the content is freely encouraged; for details, see Expected Usage.

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 3,517 times.  This page was last modified 16:43, 25 November 2013 by Glenn Lloyd.   Disclaimers