[AccessD] Function Error

Jim Lawrence accessd at shaw.ca
Fri Jan 27 13:09:52 CST 2006


Mike:

Will the SQL statements work in the query builder? 

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W
Sent: January 27, 2006 9:41 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Function Error


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


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




More information about the AccessD mailing list