1 Reply by JImlach

  • JImlach
  • Member
  • Offline
  • Registered: 12-05-2006
  • Posts: 36

Re: JNCCDET5

I have tried to run a batch update to change validation level on new data imported. I get the error 'S.V. Survey key could not be bound'!!  As anyone any idea what that means?

Thanks

Janet

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,627

Re: JNCCDET5

</Condition>
Janet

Looks like there is an error in it in both the default and quick report.  Alias is not given for Survey table . Needs a minor change in two places.


Insert Into #JNCC_NEWDATA (Original_Key,Indicator)
SELECT DISTINCT

TDET.Taxon_Determination_Key, 1
FROM
Survey SV                      ***********************  SV added as an alias in both quick and default sections


Mike

Mike Weideli

MikeWeideli's Website