move the record point

Topic: move the record point (Read 1017 times) previous topic - next topic

move the record point

May 04, 2020, 10:16:01 PM

I am writing extra code and need to know how can I move the record pointer to the next record . And how retrieves the value of the specified field from the current connection's recordset.

Re: move the record point

Reply #1 – May 05, 2020, 01:48:36 AM

@ccortes‍ your question is not clear enough.

Re: move the record point

Reply #2 – May 05, 2020, 02:10:40 PM

I have a recordset based on a query. I need to know if this recordset has records and move across the records making some operations with the data of each record, until the end of file

Re: move the record point

Reply #3 – May 05, 2020, 04:34:36 PM

@ccortes‍ you need to use an if statement to check if the recordset has a record and a for loop to go through the data and perform your operation.
Note: To do this, you need a knowledge of PHP.

Re: move the record point

Reply #4 – May 05, 2020, 06:40:08 PM

With other tool, I used If(db$->next_record()). Whit phprad says Call to undefined method PDODb::next_record()

Re: move the record point

Reply #5 – May 06, 2020, 10:27:16 AM

@ccortes‍ that is because that function does not exist in phprad.

Re: move the record point

Reply #6 – May 07, 2020, 03:43:26 PM

Is there a similar function?

Re: move the record point

Reply #7 – May 08, 2020, 12:33:46 AM

@ccortes‍ Currently, no. You have to query the next record yourself.