Originally Posted by
June7
I think Zinrey is correct for the most part. The exception would be sql SELECT statements. Data macros work with sql actions (INSERT, UPDATE, DELETE). A SELECT can be nested as a subquery in an sql action, otherwise, I don't think SELECT is relevant to data macros.
The example in this thread where a datamacro had this this structure:
LOOK UP A RECORD IN qirCIRbyDate WHERE [qryCIR].[ProductID] = varProductID ALIAS qryCIR
SETRETURNVAR (varVersion, [qryCIR].[Version])
is equivalent to the SQL statement
SELECT Version AS varVersion FROM qirCIRbyDate WHERE [ProductID] = varProductID LIMIT 1
zinrey