Announcement

Collapse
No announcement yet.

How do you move / goto record using php?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do you move / goto record using php?

    Normally, when I open a form, it will display the first record as defined by SQL.

    How do I move to certain record using PHP / javascript? For example, the form contain customer number 10000 to 90000. When I first open it, it shows record for customer number 10000. If I want to goto customer number 50000, how do I do it using php code (NOT Quick search).

    Thanks.

  • #2
    Originally posted by capecode View Post
    Normally, when I open a form, it will display the first record as defined by SQL.

    How do I move to certain record using PHP / javascript? For example, the form contain customer number 10000 to 90000. When I first open it, it shows record for customer number 10000. If I want to goto customer number 50000, how do I do it using php code (NOT Quick search).

    Thanks.
    That won't be easy. Of course you can if you are in full control, i.e. within events, but the only thing I can think of is by modifying the SQL. But then you are influencing the resultset which isn't what you want I think. You might find an opening if you dive a bit in the generated code and look how the 'goto' works.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Thanks aducom,

      You are right, modifying SQL will not work the way I want it. I guess I have to find other ways.

      Comment

      Working...
      X