[AccessD] Removing Extended Properties from stored queries?
Ryan W
wrwehler at gmail.com
Fri Jun 25 14:23:53 CDT 2021
Is there a way to remove the extended unseen properties from stored Queries?
I'm using the undocumented SaveAsText to dump forms/reports/modules/etc to
file and I'm seeing some remnants of hidden query properties in one query
that were originally in another query.
These are from a query that was once called qryBottleOrderCompleteness. I
copied it to qry_OtherMname and changed the SQL text (since it was a
passthrough) but these remain. I only see them in my data dumps/git
commits...
Begin Begin dbText "Name"
="qryBottleOrderCompletness.ClientID" dbInteger "ColumnWidth"
="1665" dbBoolean "ColumnHidden" ="0" dbLong
"AggregateType" ="-1" End Begin dbText "Name"
="qryBottleOrderCompletness.ProjectID" dbLong "AggregateType"
="-1" dbInteger "ColumnWidth" ="1860" dbBoolean
"ColumnHidden" ="0" End Begin dbText "Name"
="qryBottleOrderCompletness.BottleOrder" dbLong "AggregateType"
="-1" End Begin dbText "Name"
="qryBottleOrderCompletness.TestCode" dbLong "AggregateType"
="-1" End Begin dbText "Name"
="qryBottleOrderCompletness.BottleOrderTestQuantity" dbLong
"AggregateType" ="-1" dbInteger "ColumnWidth" ="2730"
dbBoolean "ColumnHidden" ="0" End Begin dbText "Name"
="qryBottleOrderCompletness.WorkOrders" dbLong "AggregateType"
="-1" End Begin dbText "Name"
="qryBottleOrderCompletness.CountOfTestsLogged" dbLong
"AggregateType" ="-1" dbInteger "ColumnWidth" ="2340"
dbBoolean "ColumnHidden" ="0" End Begin dbText "Name"
="qryBottleOrderCompletness.PctReceived" dbLong "AggregateType"
="-1" EndEnd
More information about the AccessD
mailing list