Focusing Record Pointer in First Position on LIST form ??

pskannaa
pskannaa Member Posts: 138
Can you suggest me, how to set the focus on list Form in First Record position...

because while clicking button,i am calculating data and insert the record in table using looping. so the pointer is set in the last record position.

I WANT TO PLACE IN FIRST RECORD POSITION, WHICH TRIGGER,COMMENT SHOULD I USE !!!

Comments

  • DenSter
    DenSter Member Posts: 8,307
    Look at the SourceTablePlacement form property, which you can set to Last.
  • pskannaa
    pskannaa Member Posts: 138
    No, what i mean that i want to set the record pointer in the FIRST position...
    Eg: in List i hav 75 records(rows)....when i opened the form the pointer is focusing on last ROW, but i want to be focus the pointer in FIRST ROW.
  • Belias
    Belias Member Posts: 2,998
    :-k :-k :-k :-k :-k
    maybe you can set the same property to first instead of last....but i'm not totally sure :mrgreen: :whistle:
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • devu_13
    devu_13 Member Posts: 101
    Hi Experts
    By set SavedTablePlacement property i lost my data in list form.can u explain in better way?
    Devendra Kr. Sharma
    IBIZ Consulting Services,India
  • Belias
    Belias Member Posts: 2,998
    (i'm not expert but i reply anyway :mrgreen: )
    it's not possible to lose data in this way...try to clear filters and/or refresh the form...
    then check if you set the right property (maybe you set savevalues to "no"?).
    anyway, no property can delete data in your underlying table
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • DenSter
    DenSter Member Posts: 8,307
    All that this property does is put the cursor in a predefined position, it does not cause data to be lost. I believe it is you who needs to explain your requirement a little further.
  • canadian_bacon
    canadian_bacon Member Posts: 91
    when opening the form - in the OnOpenForm trigger add code:
    FINDFIRST;

    when pushing the button - in the OnPush trigger for the button add code:
    FINDFIRST;
  • Belias
    Belias Member Posts: 2,998
    when opening the form - in the OnOpenForm trigger add code:
    FINDFIRST;

    when pushing the button - in the OnPush trigger for the button add code:
    FINDFIRST;
    there are 3 reasons for not doing this:
    1. write code when there is a specific property for this
    2. use FINDFIRST when maybe in this case is better to use find('-')....this is not always true...
    3. you have to write the code in each form accessing this form: this is the worst thing :!:
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • pskannaa
    pskannaa Member Posts: 138
    FindFirst/ setting property for "First"....No LUCK !!!

    any other idea....
  • Belias
    Belias Member Posts: 2,998
    have you got some code under onopenform trigger?
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • DenSter
    DenSter Member Posts: 8,307
    pskannaa wrote:
    FindFirst/ setting property for "First"....No LUCK !!!
    I am going out on a limb here and say that you are not telling us everything. That property is basically hard coding the form to put the cursor on the first/last/saved position. You must have some code on the form that overrides this property.