I'm using MS Access 2003.
I'm wondering whether Now() gets calculated once during a query or once for each record that it applies to.
For example, consider the following query:
In practice, every record in tbl_liaImport will have the same CommunicationHeader when this Append query is run.
Question:
If every record in tblLiaImport has the same CommunicationHeader value, is it ever possible for the above query to insert two or more records? (I want to insert that single CommunicationHeader, along with the time that it was inserted.) So does the query evaluate Now() once at the beginning of the query, then use that same value for all rows, or does Now() get evaluated for each row under consideration. If for every row, then I can see the possibility that the query might find more than one distinct record, even though there's only one distinct CommunicationHeader.
Thanks for any help you can give.
Wayne
I'm wondering whether Now() gets calculated once during a query or once for each record that it applies to.
For example, consider the following query:
Code:
INSERT INTO tblLiaEdiHeader
(
CommunicationHeader,
ImportDateTime
)
SELECT DISTINCT
a.CommunicationHeader,
Now()
FROM tblLiaImport a;
In practice, every record in tbl_liaImport will have the same CommunicationHeader when this Append query is run.
Question:
If every record in tblLiaImport has the same CommunicationHeader value, is it ever possible for the above query to insert two or more records? (I want to insert that single CommunicationHeader, along with the time that it was inserted.) So does the query evaluate Now() once at the beginning of the query, then use that same value for all rows, or does Now() get evaluated for each row under consideration. If for every row, then I can see the possibility that the query might find more than one distinct record, even though there's only one distinct CommunicationHeader.
Thanks for any help you can give.
Wayne