1

Topic: Batch update problem

I have just tried to run the batch update: Det1 - creates new Determination for specified taxa

I get the following message:
The following error occurred while attempting to run the batch update SQL:
Must declare the scalar variable "@New_TLI_Key"

Help!

Craig

Craig Slawson
Staffordshire Ecological Record

2

Re: Batch update problem

Am I going to get any response to this problem, I need to use the batch file

Craig

Craig Slawson
Staffordshire Ecological Record

3 (edited by charliebarnes 04-05-2017 14:34:03)

Re: Batch update problem

I haven't read through the batch file or tested it or this, but looking at the code @NewTLI_Key (just the one underscore) is declared. I wonder if therefore line 56, where @New_TLI_Key is used, should read:

@NewTLI_Key <> TLI.Taxon_List_Item_Key

rather than

@New_TLI_Key <> TLI.Taxon_List_Item_Key
Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

4

Re: Batch update problem

Thanks Charlie

That cleared the error, only for two more to appear, but they were more straight-forward - it now works

Cheers
Craig

Craig Slawson
Staffordshire Ecological Record

5

Re: Batch update problem

spoke too soon!

1) doesn't appear to do all records as expected
i.e. Mesapamea secalis off Rec3 list > Mesapamea secalis agg. off Rec3 list changed 72 records, but didn't alter 38 records!
2) doesn't appear to clean itself out properly after running - trying to run it again produced the error "There is already an object named '#JNCC_NEWDATA' in the database" - closing and re-opening Recorder clears the error!

Craig

Craig Slawson
Staffordshire Ecological Record

6

Re: Batch update problem

scratch problem (1) that appears to be a problem in the Species Dictionary - I'll post it there!

Craig Slawson
Staffordshire Ecological Record