Getting specific record number

[Olaf Schmidtmann]

Hi,

Chris, I think he wanted the position of the record in a cursor of more
records.
But your select * from table where shirt_style = 'polo' is usefull to get
the RecID. Afterwards you may loop a list of all RedIDs (the RecID column of
the table) and get its position.
Sorry, I don't have any better idea right now ... :-(

Cheers
Olaf

P.S. Nice website, Maz.


> -----Original Message-----
> From: Chris Aernoudt [mailto:chris at pixellink.be]
> Sent: Friday, July 18, 2003 10:54 AM
> To: 'Valentina Developers'
> Subject: RE: Getting specific record number
> 
> 
> Yeah, select * from table where shirt_style = 'polo'
> 
> -----Original Message-----
> From: valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Mark
> Maslowski
> Sent: vrijdag 18 juli 2003 9:51
> To: Valentina Developers
> Subject: Getting specific record number
> 
> It's late and my brain is slowly turning to mush but I cannot figure
> this
> out...
> 
> I am using Val for Director and I have a cursor with about 
> 100 records.
> I
> need to find the record position (and go there) of a record where a
> field
> equals a specific value. For instance, I need to go to the record that
> has a
> field name "shirt_style" that contains "polo." From there, 
> the user can
> click a next or back button to step through the other records.
> 
> I can do this with a repeat loop to look at each "shirt_style" field
> until I
> get to the one I want but I thought there might be an easier 
> way to get
> this
> information.
> 
> Am I missing something really obvious?
> 
> Thanks.
> 
> - Maz
> 
> *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
> 
> Mark D. Maslowski
> Partner/Designer/Programmer
> 
> MAJICo - The Mark and June Interactive Company
> Serving Northern California - from Napa to Monterey!
> www.majico.com
> 
> 831-336-3343 voice       831-336-3353 fax
> 
> *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>