View Single Post
  #11  
Old 04-23-2009, 02:27 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,003
This won't create the searches, but once you have created them (it sounded like you already did), you can update several in one step (specifying their ItemIDs as mentioned).

The initial steps outlined above for identifying the items and attributes to update should be a one-time effort, then you would periodically execute the customized SQL command to advance the searches.

You can save the SQL command in a .sql file (i.e., update.sql), then create a batch file (i.e., update.bat) like this:

sqlite3 mydb.urd <update.sql

Put sqlite3.exe, update.sql, and update.bat in the same folder as your database and double-click the .bat file (or set up a scheduled task, etc.) to run the command.
Reply With Quote