General discussion
November 13, 2002 at 01:55 AM
johngreer

Access 2000 – SQL if

by johngreer . Updated 23 years, 4 months ago

Here’s what I want to do:

INSERT INTO History
SELECT [Imported].[Price] AS Price, [Imported].[Date] AS [Date]
FROM Imported;

DELETE Imported.*
FROM Imported;

BUT I only want to run the DELETE if the INSERT worked. Does SQL have the capability to check things that ran before and conditionally run other things? e.g. IF abc THEN def

This discussion is locked

All Comments