Declare sql or not?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • J-P-W

    #1

    Declare sql or not?

    Hi,

    Should I:

    --------------------
    Dim sqlA As String
    sqlAll = "DELETE * FROM tblName;" '....or whatever!
    DoCmd.RunSQL sqlA
    --------------------

    Or is it acceptable to just:
    --------------------
    DoCmd.RunSQL (DELETE * FROM tblName;)
    --------------------

    I know both work, but is there a reason I should use one over the
    other?

    Thanks, Jon

Working...