1 Reply by DaveSlade

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Re: Display Unchecked Records error

I'm getting a new error when using the 'Display Unchecked Records' add-in. I know that there are around 1200 records currently unchecked - is this too many for the add-in to handle?

Dave


Exception occurred in application Recorder 6 at 01/02/2008 10:52:59.
Version : 6.10.4.120

Exception path:
EOleException : Incorrect syntax near the keyword 'IN'

Last event\actions:
  actObservations invoked
  TfrmObservations created
  TfrmObservations activated
  TfrmSurveyDetails created
  TfrmSurveyDetails destroyed
  TfrmSurveyDetails created
   invoked
  TdlgContainer created
  TdlgContainer activated

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 1,046,100 KB

DLLs loaded:
  advapi32.dll (5.1.2600.2180)
  comctl32.dll (5.82.2900.2982)
  comdlg32.dll (6.0.2900.2180)
  gdi32.dll (5.1.2600.3159)
  HHCtrl.ocx (5.2.3790.2847)
  kernel32.dll (5.1.2600.3119)
  mpr.dll (5.1.2600.2180)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1117.0)
  ole32.dll (5.1.2600.2726)
  oleaut32.dll (5.1.2600.3139)
  shell32.dll (6.0.2900.3241)
  user32.dll (5.1.2600.3099)
  version.dll (5.1.2600.2180)
  winmm.dll (5.1.2600.2180)
  winspool.drv (5.1.2600.2180)

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk

2 Reply by Sarah Shaw

  • Sarah Shaw
  • Veteran
  • Offline
  • Registered: 23-06-2006
  • Posts: 267

Re: Display Unchecked Records error

Hi Dave

Are you receiving this error when you try to run the addin or when trying to display (expand) the filtered records?

I have managed to use the addin to filter down to 81,479 unchecked occurrences, however this took a while and I am having problems expanding the filtered surveys displayed (I get an error message but it isn't the one you posted).

Also can I double check the version you are using? (I'm guessing it's the most recent but just to be certain)

Kind regards,

Sarah Shaw
Biodiversity Information Assistant
JNCC

3 Reply by DaveSlade

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Re: Display Unchecked Records error

The error occurs when trying to run the addin. It gets as far as opening the hierarchy window if it is not already open, but then does not apply the filter, giving the exception posted above.

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk

4 Reply by DaveSlade

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Re: Display Unchecked Records error

It would appear that this is an intermittent problem, and I cannot as yet find any pattern to it. I also now know that when it appears not to have worked, The fully hierarchy is displayed, but checked Taxon Occurrences are not shown, only unchecked ones.

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk