Here's some code I have to generate a SQL statement Public Function BuildRepSQL(ByRef clsRepLine As CRepLine, eType As aiDBStatus) As String
Dim sReturn As String
With clsRepLine
Select Case eType
Case aidbstatusdelete
sReturn = "DELETE * FROM tblRepLine WHERE [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2008/11/14/lessons-in-sql/
Posted
Nov 14 2008, 05:07 PM
by
Daily Dose of Excel