"DELETE FROM [TableName] WHERE [Field]='value';"
Ray at work
"Joshua C. Clark" <Jo...@Network-Medics.Com> wrote in message
news:#fAM7aGA...@TK2MSFTNGP10.phx.gbl...
"Ray at work" <r...@work.spam> wrote in message
news:eV#LwkGAD...@TK2MSFTNGP11.phx.gbl...
"Ray at work" <r...@work.spam> wrote in message
news:eV#LwkGAD...@TK2MSFTNGP11.phx.gbl...
Ray at work
"Joshua C. Clark" <Jo...@Network-Medics.Com> wrote in message
news:uZJJ9oG...@TK2MSFTNGP11.phx.gbl...
2. Don't do "DELETE * FROM" It's just "DELETE FROM" When you delete, the
entire row is deleted, so you do not have to (/cannot) specify which columns
to delete.
If you execute "DELETE FROM TABLE" it will clear out the whole table, btw.
Ray at work
"Joshua C. Clark" <Jo...@Network-Medics.Com> wrote in message
news:OZNBR9GA...@TK2MSFTNGP12.phx.gbl...
> I have a SQL DB called eventlog, I have a table called table, my ODBC is
> correct, and I am using this Script, what am I missing,
>
> Const adOpenStatic = 3
> Const adLockOptimistic = 3
> Const adUseClient = 3
> Set objConnection = CreateObject("ADODB.Connection")
> Set objRecordset = CreateObject("ADODB.Recordset")
> objConnection.Open "DSN=eventlogs;"
> objRecordset.CursorLocation = adUseClient
> objRecordset.Open "Delete * FROM table" , objConnection, adOpenStatic,
> adLockOptimistic
> objConnection.Close
>
> "Ray at work" <r...@work.spam> wrote in message
> news:eH7ShtGA...@TK2MSFTNGP12.phx.gbl...
Ray at work
"Ray at work" <r...@work.spam> wrote in message
news:ujvQHIHA...@TK2MSFTNGP11.phx.gbl...
Const adOpenStatic = 3
Const adLockOptimistic = 3
Const adUseClient = 3
Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open "DSN=eventlogs;"
objConnection.Execute DELETE FROM TABLE "TABLE"
objConnection.Close
"Ray at work" <r...@work.spam> wrote in message
news:#3kcqLHA...@TK2MSFTNGP11.phx.gbl...
DELETE FROM THENAMEOFYOURTABLEFROMWHICHYOUWOULDLIKETODELETERECORDS
Ray at work
"Joshua C. Clark" <Jo...@Network-Medics.Com> wrote in message
news:ODcrHqHA...@TK2MSFTNGP11.phx.gbl...
Const adOpenStatic = 3
Const adLockOptimistic = 3
Const adUseClient = 3
Set objConnection = CreateObject("ADODB.Connection")
Set objRecordset = CreateObject("ADODB.Recordset")
objConnection.Open "DSN=eventlogs;"
objRecordset.CursorLocation = adUseClient
objRecordset.Open "Delete FROM event" , objConnection, _
adOpenStatic, adLockOptimistic
objConnection.Close
"Ray at work" <r...@work.spam> wrote in message
news:Os2YbuHA...@TK2MSFTNGP10.phx.gbl...
Set objConnection = CreateObject("ADODB.Connection")
With objConnection
.Open "DSN=eventlogs;"
.Execute "DELETE FROM EVENT"
.Close
End With
Set objConnection = Nothing
Ray at home
"Joshua C. Clark" <Jo...@Network-Medics.Com> wrote in message
news:eQtsGyHA...@TK2MSFTNGP12.phx.gbl...
That will still delete all records in the table. Remember to use your WHERE
clause.
DELETE FROM EVENT WHERE EVENT_DATE < Date() - 30
Ray at home
"Paul White" <p...@bigpond.net.auNOSPAM> wrote in message
news:9MQla.940$hF....@news-server.bigpond.net.au...
"Ray at home" <r...@ajf8jalskdfna.sefrhja7yasdf.com> wrote in message
news:O3H3WwXA...@TK2MSFTNGP11.phx.gbl...