English > Support

Mass Updates

<< < (2/2)

nostra:

--- Quote from: mgpw4me@yahoo.com on October 17, 2009, 01:53:04 am ---It just occurred to me that the modified date probably isn't changing because it's the "people" records that I'm re-adding.

As a test, I deleted the AKA titles and the modified date was correctly updated.

--- End quote ---

I'll check this and fix if needed

mgpw4me@yahoo.com:

--- Quote from: patch on October 17, 2009, 01:40:32 am ---
--- Quote from: nostra on October 17, 2009, 01:04:58 am ---The date modified field is updated if the imdb plugin changes smth... Without changes - no update...

--- End quote ---

Does anyone know if there is a better field to use when searching for records which need updating?
I sounds like "date modified" will actually do the reverse of what desired as choosing records update > x months ago will tend to select static records on imdb.
Perhaps a date last checked field should be added to the feature suggestion list

--- End quote ---

It would be "kewl" if sql queries could be used to populate custom fields ... select datetime() as custom_field_name in the custom field definition dialog.  Sorry if that's not firebird-proper syntax, but you get the idea.  There's pros and cons to this, but it would be one way to add a lot of flexibility to the program.  Limiting the sql to select statements would limit exposure.

mgpw4me@yahoo.com:
As long as I'm at it...

When doing retries do you disconnect / reconnect between each retry?  If not, it probably isn't of much value.  Even at levels of 25 retries, I get the same error rate on mass updates.

Navigation

[0] Message Index

[*] Previous page