Querydef documentation!!!

[MichaelRed]

Probably unimportant. MS has slightly shaded the truth re temporary (un named querydef objects. The Docs saay these are not saved. Not True. They are saved until the next compact / repair operation. Perhaps in the grand scheme this (the saving) is necessary.

To see this, create an unnamed query def (you do not have to actually execute it). open a new (standard) query:

SELECT MSysObjects.Name, MSysQueries.Attribute, MSysObjects.DateCreate, MSysObjects.DateUpdate, MSysQueries.Expression, MSysQueries.Name1, MSysQueries.Name2
FROM MSysQueries LEFT JOIN MSysObjects ON MSysQueries.ObjectId = MSysObjects.Id
WHERE (((MSysObjects.Name) Like "~TMPCLP*"))
ORDER BY MSysObjects.Name, MSysQueries.Attribute, MSysObjects.DateCreate;

the items shown include the unnamed query defs. Compact and repir the db and re-run the standard query - this presents an empty recordset!! QED



MichaelRed