Data application function access

[craig T.]

I would like to write a macro that would access a record by its position in the Data application. I know how to do this if I am making my own database in OPL but that is not what I want to do. I want to use the Data application. In the data application on the left side of the find box there is an indicator that tells me the position of the record stated in a ratio (e.g. 1/20). I would like to access the function that produces this ratio and I would like to be able to create a macro that will take me to 6/20 or 11/20 instantly. Any ideas on what I would need to do to access this.

[doogald]

I don't know about the Data application - I do not use it much - but you may be able to do this with the free PsiDat.

http://www.millican.info/Home/PsiDat.htm

[craig T.]

No, I want to use the Data Application, some OPX, and a macro so that I can just tell it to go to a record number and I am there. A work around I have used is to auto number my records starting with 0 and so on but this fails when I start deleting records. I am looking for position rather than a particular record so I do not want to punch in a particular record I want what ever record is in that position. If I filter the data base I want to move to same position but see a different record. I hope I am clear. I think this would be a simple task and much of the needed elements are apparent given the fact that the ratio is visible near the find box. I need to know if there is an OPX that I can use to get at a function that will let me do this. I looked at the data base OPX but I did not see anything that would let me do this. I am a very marginal programmer so I am probably missing something but with a little direction I can usually fumble my way through.

[WolfUK]

Would this work if you recorded a macro that opened the Data file, performed a Fn+Left Cursor to take you to the start of the file and then right cursors to move you through the file? You could get the macro to ask you for the record number and then use a loop for the right cursor to reach this (entered number-1).

[craig T.]

That was my first design but it is not practical if the data base is large. There needs to be a delay between each advancement so that it would take about 30 seconds to get to record 40. I want to just hit 40 if I can.

[brianh]

To the best of my knowledge, the direct jump in the Data app is not possible. The OPX's provided by Symbian will allow it in user defined OPL databases.

A workaround is possible, but I haven't been able to figure it out.

Unless, you created a simple listbox macro or defined button in Merlin that would automatically send the keypresses for a record change either forward or back. This could be set up to repeat the sending of keypresses, increasing numerically to match the data records. This would force the macro to be a little large, but would take out the dependancy on you numbering the records, etc.

Give me a little time to play with this idea (probably tonight) and I will post a macro tomorrow.

Hope this helps.