Getting specific record number

[Chris Aernoudt]

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