I am currently writing a script that i would like to search the entire database for terms. I utilized the history of a current project but the code manually adds each field. is there a shortcut to add all fields from the database?
task.AddFieldToInc "ACCOUNT_NUMBER"
task.AddFieldToInc "DESCRIPTION"task.AddFieldToInc "DATE"
task.AddFieldToInc "NAME"
profit814
Offline
Last seen: 3 years 10 months ago
Joined: 03/18/2018 - 17:12
Try
task.IncludeAllFields
This will copy all the fields from the source file.
Brian
When i make the edit above, i get "Error on line 433- Object does not support this propery or method.i listed the full function below. Thanks for the help.
' Data: SearchFunction Search Dim db As database Dim task As task Dim dbName As String Set db = Client.OpenDatabase(filename) Set task = db.Search task.IncludeAllFields task.RecordFilesPrefix = "Search for Key Terms" task.PerformTask "plug ", 0, 0, 1 dbName = "Search for Key Terms" Client.OpenDatabase(dbName) Set task = Nothing Set db = NothingEnd Function
Hi, I just looked at what is allowed in the Search function and you have to list all the fields. Unfortunately you can't use the task.IncludeAllFields in this function like you can in other functions. I just sent an email to IDEA asking for this option but for now you will have to list the fields.
Brian