Notes

This is a sundry collection of notes about the use of Batch Updates, pending the construction of a more comprehensive help system.

Entry date - to get an entry date fora new records use   SET @Date = GETDATE()

Current User - SET @UserID = (SELECT NAME_KEY FROM NAME WHERE
   <Condition field="Name.Name_Key" type="CurrentUserID" name="Current User ID"     operator="equal" /> )

Next Key - Use the following to get the next key. EXECUTE spNextKey 'TABLE NAME' , @SetItemKey  OUTPUT
The TABLE NAME is the name of the table the key is needed for. @setItemKey is a variable  (which must be declared)  which will hold the key.

Using an Alternative Database

You can create a new database within an SQL Server instance - for example to hold an extract of data to avoid size limitations on a database.  This can be updated by queries from NBNDate but you need to refer to the databse and also the owner. So for example with a database name EXTRACT with a table called EXTRACT1  the tables should be referred to as EXTRACT.dbo.EXTRACT1. Make sure the database and table has sufficient permissions to be accessed by NBNdata.  

Relate Topics:
  Condition
  Columns
  XML Batch Updates Help
  Introduction
  About XML Batch Updates
  Adding New records