Display last record

[edech]

Upon opening a form, I want to go to & display the last record in the table. I've tried Fetch last record OnInit and also OnActivate, even OnFetch but the 1st record in the table still gets displayed. The records are in record number order. Can you help?

[Stephen Williams]

RE: Display last record

Well, it should work! I do it all the time!

Can you post a sample of your Oninit or OnActivate code so we can check it out...

Steve

[edech]

RE: Display last record

I clicked on OnInit, inserted a command under Action Script, selected Forms (on the right), and selected Fetch Last and finished.

I got it to work by converting the FetchLast Action script to xbasic and changing from PARENT.fetch_last() to PARENTFORM.fetch_last().

Wish I knew why the original wouldn't fly!

Many thanks.

[Stan Mathews]

RE: Display last record

It may well have worked and not been resynching the form to the parent. Just because you fetch to a record in the table doesn't mean that record will be displayed.

[edech]

RE: Display last record

Can you help me understand what I didn't do right when I went to Form, Actions, clicked on OnInit, Action Script, Insert Command, Fetch Last, and Finish. If that won't display the last record in the table when the form is opened, how would I do it?

Thanks for your patience

[Tom Cone Jr]

RE: Display last record

Ed, I'll bet you specified 'parent' as the object upon which the fetch_last method would function. That won't work, cause the form doesn't have a 'parent'. It should have been the word 'this', instead of the default 'parent'.


The onInit event is tied to the form already. It's an event of the form, not an event of an object on the form. So, if you want to build a script for the OnInit event of the form you refer to the form, itself, as 'this'.


If, instead, you were using fetch_last with an embedded browse object on the form, and were using it in a script tied to the browse object, instead of the form, you would refer to the form as 'parent' or sometimes 'parentform'. In this instance 'this' would refer to the embedded browse.


I suggest you review Chapter 6: Objects, in the xbasic ref. manual, for a discussion of the ways in which 'objects' are referenced.


Hope this helps.


-- tom

[vasant panjabi]

RE: Display last record

after fetch_last()

insert:-

sys_send_keys("{ctrl-end}")

rgds,
v.p.

[Mick Magnuson]

RE: Display last record

I am sure you have probably figured this out by now, but for anyone else who didn't get the answer for this, here is the "Oninit" event script to go to the last record when opening a form.

dim tbl as p
tbl=table.current()
tbl.index_primary_put("Record_Number")
tbl.fetch_last()
parentform.resynch()
END

Note: The index name can be any saved index.

[edech]

RE: Display last record

Many thanks. I'm on board now.

Ed

[Jean-P. B�dard]

RE: Display last record

Hi Mick,

I am using same script as yours but the form open to the last record only the first time I open it. If I go to another form in my application and then go back to the first form, it it will not go to last record and will not reindex:

dim tbl as p
tbl=table.current()
tbl.index_primary_put("Doss")
tbl.fetch_last()
parentform.resynch()
end

Any suggestions ?

Thanks

[Stan Mathews]

RE: Display last record

I would try putting the same script on the onactivate event for the form as well as the oninit. This should take care of first entry and subsequent returns to the form.

[Jean-P. B�dard]

RE: Display last record

Thanks Stan,

Good idea I will try.

Best regards

JP

[Jean-P. B�dard]

RE: Display last record

Stan,

Works great.

Thanks again

JP