Knowing Row number in table based on a value

Hi List I am in mid of a requirement where I need to walk through every row to get my particular row. Here the data to the table is coming from external Data Base(not of much concern about the source). This external Data Base returns 700-800 rows at once. And walking through 800 rows is really

Re: Knowing Row number in table based on a value

: Monday, May 12, 2008 1:00 PM To: arslist@ARSLIST.ORG Subject: Knowing Row number in table based on a value Hi List I am in mid of a requirement where I need to walk through every row to get my particular row. Here the data to the table is coming from external Data Base(not of much concern about

Re: Knowing Row number in table based on a value

Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Monday, May 12, 2008 1:00 PM *To:* arslist@ARSLIST.ORG *Subject:* Knowing Row number in table based on a value Hi List I am in mid of a requirement where I need to walk through every row

Re: Knowing Row number in table based on a value

Ganga, I don't know your requirement exactly, but why dont you use a Direct SQL statement to set your field instead of doing a table loop. Cheers, Chandru On Mon, May 12, 2008 at 2:00 PM, Ganga Prasad [EMAIL PROTECTED] wrote: ** Hi List I am in mid of a requirement where I need to

Re: Knowing Row number in table based on a value

: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ganga Prasad Sent: Monday, May 12, 2008 1:22 PM To: arslist@ARSLIST.ORG Subject: Re: Knowing Row number in table based on a value ** You are almost there..As I mentioned I need to go to the particular row where

Re: Knowing Row number in table based on a value

-- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad *Sent:* Monday, May 12, 2008 1:00 PM *To:* arslist@ARSLIST.ORG *Subject:* Knowing Row number in table based on a value Hi List I am in mid of a requirement

Re: Knowing Row number in table based on a value

Subject: Re: Knowing Row number in table based on a value ** Yes Your idea seems good as long as I have the capability to query the Databse. But here as I said the data to the table is coming from external database. I access the web services published by the database using ARSystem plugin c++ code

Re: Knowing Row number in table based on a value

: Knowing Row number in table based on a value So you get the data from the other system. Are you saving that data into a table (with your c++ code)? If so then you can do your own SQL query against the data you received. If not you could modify your c++ code to allow sending a parameter