Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Sat Jan 28 15:31:18 CST 2006
O. I meant the use of the variable or field name Row in his SQL. I was wondering what it referred to exactly and maybe there was a conflict with the reserved word. Rocky Jim Lawrence wrote: > Hi Rocky: > > Isn't the record defined as a row and a field as a column? > > Here is a piece of code that works with a recordset, a standard data set > should not work much differently. > > Dim RowPosition as long > Dim ColumnPosition as integer > > RowPosition = 1200 > ColumnPosition = 12 > > With rsMyRecordset > .Move First > .Move (RowPosition) > MyFieldValue = .Fields(ColumnPosition) > End With > > HTH > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - > Beach Access Software > Sent: January 28, 2006 10:05 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Function Error > > 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