V4MD search in API way and cXtraStringGrid example request

[info at vallemediatime.com]

Thanks Igor and Ruslan
your help has been much profit...
Finally I've successful to obtain what I wanted but it has been much hard...
and I have had to use some lingo repeat-cycles for obtain the exactly field
that I want show on the result table, this is not good.

>> Iterator is designed to iterate through the table records - not table 's
fields.
For me this is a limit, if possible, can you add a new method for iterate
the table records with the option to select N field...
This may be useful for show only the necessary field-column that the user
need... like SQL.
Paolo


----- Original Message -----
From: "Igor Gomon" <giv at tlc.kherson.ua>
To: "Valentina Beta" <valentina-beta at lists.macserve.net>
Cc: <valentina at lists.macserve.net>
Sent: Wednesday, March 30, 2005 9:05 PM
Subject: Re: V4MD search in API way and cXtraStringGrid example request


> > I want explain better my problem, I don't understand if your suggest is
> > right for me, sorry.
> >
> > Table STUDENTS
> > --------------------------
> > ID | Name  |  Phone | ...
> > --------------------------
> > 1    Paolo       111
> > 2    Anna        222
> > 3    Igor          333
> > ...
> >
> > I search for "Paolo" in field Name and I want display only two column
(ID
> > and Name): NOT the Phone and other column,
> > how can I do this in API WAY?
> > --------------
> > ID | Name  |
> > --------------
> > 1   Paolo
> > ...
>
> on X
>     --....
>     fName = table.field("Name")
>
>     -- Find all the records in the table's field "Name" equal to "Paolo"
>     resultSet = fName.findValue("Paolo")
>     if CheckValError() then exit
>
>     -- Create set iterator on selection
>     rsIter = resultSet.makeNewIterator()
>     if CheckValError() then exit
>
>     -- Now iterate over resulting selection using set iterator.
>     if rsIter.firstItem() then
>         repeat while true
>             -- Go to the next record in the result set.
>             recID = rsIter.value
>             table.recId = recID
>             -- Get string value from the "Name" only field.
>             s = fName.getString()
>             -- Do with it whatever you want.
>             put s
>             -- Check for result set end.
>             if not setIter.nextItem() then
>                 exit repeat
>             end if
>         end repeat
>     end if
>
>     --Clean up.
>     rsIter = 0
>     resultSet = 0
>
> end X
>
>
> --
> Best regards,
> Igor Gomon
> -------------------------------------------------------------
> e-mail: giv at tlc.kherson.ua
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://listserv.macserve.net/mailman/listinfo/valentina
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 30/03/2005
>
>



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 30/03/2005