by Priyank M Bhat (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: (5 Votes)
Use this class to create select, insert, update, delete sql queries. It automatically manages datatype and build data according. I generated this code in order to reduce my time in creation of queries.
Inputs
Dim abc As New mQueryBuilder.QueryBuilder
With abc
.TableName = "User"
.QueryType = [Update Data]
.DateIdentifier = "#" ' change only needed for msaccess database, default value is '
.AddFields "UserID"
.AddFields "Password"
.AddFields "NDATE", Date
.AddCondition "UserID", "priyank"
.AddOrderBy "UserID"
Debug.Print .GetQuery
End With
Assumes
Use this class to create select, insert, update, delete sql queries. It automatically manages datatype and build data according. I generated this code in order to reduce my time in creation of queries. Code was developed in one hour time and code might have some bug. If anyone finds bug please let me know I shall fix the problem in my next version or will be thankfill to anyone who modifies and send me copy.
Code Returns
SQL Query
Upload