[AccessD] Function Error

Fri Jan 27 11:41:20 CST 2006

Sorry about that,

If I run qryInmatesBinNumberUpdate it runs fine.

If I run

SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = '0'

OR

SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = 0 

They both give me invalid procedure call

Interesting......

-----Original Message-----
From: Gustav Brock [mailto:Gustav at cactus.dk] 
Sent: Friday, January 27, 2006 10:35 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Function Error

Hi Mike, you didn't reveal the result of this:

>2005-01-27 16:09:23

Have you tried running this on its own: 

  qryInmatesBinNumberUpdate

and this in a new query:

  SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = '0'

or should it be:

  SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = 0

/gustav

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com