RunQuery




Public Sub RunQuery(strSQLAction as String)
Dim qdfTemp as QueryDef
'Setta ed esegue la query

Set qdfTemp = db.CreateQueryDef("NewQuery")
With qdfTemp
.SQL = strSQLAction
.Execute
.Close
End With
' Cancella la Query

Set qdfTemp = Nothing
db.QueryDefs.Delete "NewQuery"
DoEvents
With db
.TableDefs.Refresh
.QueryDefs.Refresh
End With
End Sub
Richiede che il database sia gia aperto e settato











( runquery.html )- by Paolo Puglisi - Modifica del 17/12/2023