delete queries

[nate0057]

Hi everybody,

I would like to replace the following code

delquery = "DELETE PPAPlinks.*, PPAPlinks.ILINK, PPAPlinks.REVN, PPAPlinks.PARTN, PPAPlinks.CREQ, PPAPlinks.ORDN "
delquery = delquery & "FROM PPAPlinks "

By another code like this:

delquery = DELETE * FROM PPAPLinks

But a message error appear : "Expected: End of statement"

What could I do??

Thanks a lot.

 

[Alansidman]

I'm guessing that you have defined (DIM) delquery as a string? You probably need to surround that string with quotation marks. " "

 

[nate0057]

Effectively I defined delquery as a string and you're totally right. I've tried different things but I haven't thought about the quotation marks.
It works
Thank you