IMinute.UpdateRowsFromDatabases Method

Sub UpdateRowsFromDatabases( _ 
   ByVal firstRow As Integer, _ 
   ByVal lastRow As Integer, _ 
   ByVal fieldsToUpdate As List(Of String), _ 
   Optional ByVal identifierFields As List(Of String) = Nothing, _ 
   Optional ByVal allowedDatabases As List(Of String) = Nothing _ 
)

This language is not supported or no code example is available.

void UpdateRowsFromDatabases( 
   int firstRow, 
   int lastRow, 
   List<string> fieldsToUpdate, 
   List<string> identifierFields = Nothing, 
   List<string> allowedDatabases = Nothing 
)

This language is not supported or no code example is available.

Parameters

firstRow

int

The first row to update in the minute (1-9999).

lastRow

int

The last row to update in the minute (1-9999).

fieldsToUpdate

List<string>

A list containing mnemonics of fields to be updated. They will be updated when they also exist in article databases.

identifierFields

List<string>

A list of fields which must be identical in the database and in the estimate to enable the update. When omitted, only the Reference field is taken into account. You can add Description, Manufacturer, Family and UserDefinedField. Only those fields are supported.

allowedDatabases

List<string>

When omitted, rows coming from any database is updated. You can list databases which should be taken into account as they appear in 'DatabasePath' and 'DatabaseSource' fields of the minute rows. The format must be as follows (the path number must have two digits): '01 - MyDbToInclude.qdb'.

This method requires the internal cache to be up to date, which is ususally the case, but there are some exceptions and you need to refresh it manually, see below.

Some methods use the internal cache for retrieving the minutes data. This is for performance reasons, especially, when one minute is accessed multiple times. These are (let's name them group 1): 
GetFieldValue, 
SetFieldValue, 
SetFieldValue, 
UpdateValuesConditionally, 
IEstimateVersion.UpdateMinuteValues.

And there are some methods that modify the minutes data, but they don't update the internal cache for performance reasons. These are (let's name them group 2): 
ClearRowValues, 
DeleteRow, 
InsertRows, 
InsertSetAtRow, 
InsertSetAtRow, 
GroupRows, 
UngroupRows, 
UpdateRowsFromDatabases.

So if you use the methods from group 2, you should update the internal cache manually before you call any method from the group 1. The cached data can be updated and retrieved with GetFullData method. You can update the cache also with the IWbs.Refresh method, but is it slower, because it does much more work.

See IMinute documentation for details about hidden "FreeField" field.

For historical reasons, this method doesn't throw any exception in case of any error. Instead, the error will be stored as a global error (if it was empty) in IGlobalErrors

.NET Framework