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
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.
XML Batch Updates Help
About XML Batch Updates
Adding New records