sql question

GreenHell

I'm trying to delete rows from two dbs, using ASP.NET and VB and an access db. I want to delete rows where the lastlogindate is 60 days previous to the current date. Any ideas?


Dim queryString As String = "DELETE FROM users, CCard WHERE users.userid = ccard.id and LastLogindate < datetime.now"

Evil Phil

Is datetime.now an Access function? Maybe the code should be

Dim queryString As String = "DELETE FROM users, CCard WHERE
 users.userid = ccard.id and LastLogindate < " & datetime.now()

bonkey

I don't think Access allows you to delete from two tables with one query. I know its definitely not part of the SQL standards.

jc

Spunj

Far as I remember, Access allows Cascading deletes so all you have to do is delete the row from the parent table (users) and the corresponding child row will also be deleted.

You need to set up a Primary/Foreign Key relationship and theres a checkbox there which lets you specify whether or not to use Cascading deletes/updates.