[AccessD] Function Error

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Sat Jan 28 12:05:05 CST 2006


How is Row defined as a field in the table that the query uses?

Rocky


Gowey Mike W wrote:
> 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
>
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list