Strange Access 2 Delete Query

[IClarke]

I'm in the process of converting an old Access2 database to SQL server 7 and have come accross this query :

DELETE DISTINCTROW BOTrans.gl_tran_code, BOTrans.MatTest
FROM BOTrans
WHERE ((BOTrans.gl_tran_code) In ('stoki','stokr','stokx','wrton','tfer',"gjnl","jnal","jnye","jnye2","jnye3"))

It LOOKS like the person that wrote it was trying to delete only certain fields from the table, which I would normally use an update query for. Can anyone tell me if this delete query is (was)actually valid and if so what would it do ?

Thanks in advance
Ian.

[Ecniv]

Not come across that before.


Sorry


Looks vaguely liike Business Objects though.

Perhaps it was meant to delete the rows where the code matches those in that list... For what reason - only the original developer knows and they have probably forgotten by now


Vince

[IClarke]

This is the line that really gets me : DELETE DISTINCTROW BOTrans.gl_tran_code, BOTrans.MatTest

Ignoring the DISTINCTROW for a moment, Delete dose'nt usually take any parameters does it ? So why have two field names afetr the delete command ? I know it's an Access 2 database, just can't find any reference to using delete in that way.

[mendhak]

I did a search, which may prove to be eventually useless, but worth the click.

http://www.mvps.org/access/queries/qry0022.htm
http://support.microsoft.com/support.../Q168/4/38.asp

[Heribertt]

wath a streange code

it certainly will not work