|Subject:||Re: Get the current Form viewed Record No.
|Date:||29 Oct 2020 11:40:45 -0400
|From:||"Kevin Zawicki" <firstname.lastname@example.org>
Not knowing your context,..
If you know the key fields you would capture them in/from the form into variables,
maybe an array, dynarray, strings.
Then open a tcursor to the table and locate the record based on keys.
There are many ways to do this.
Or if the whole table is in the DM, you have direct access to the record
you are on, just because you cannot se the fields does not mean you cannot
read them. Add them to the form invisible, use the DM read, etc.
John Wright <email@example.com> wrote:
>Thanks for that... yes it is the physical record number I wanted to use
>and yes, the table is keyed. I didn't realise that the record numbers
>could change under certain circumstances but really it is a current
>table number that is relevant as the consequential report would run
>straight away so it would not matter that the Table Number had changed.
>I just thought it would be more simple to just use the table number
>rather than needing to capture the key values! What is the best way then
>to capture the key values from the record in view please?
>Thanks for the prompt reply.
>On 29/10/2020 13:23, Kevin Zawicki wrote:
>> Do you mean the physical record number in the paradox table?
>> That is not a static value in Paradox tables.
>> If you filter or sort or link, the record number can change.
>> Is your table keyed?
>> If keyed, I would capture the key values or the form record and then search
>> on the key values in the table.
>> John Wright <firstname.lastname@example.org> wrote:
>>> It is some time since I done anything new on Paradox and I have been
>>> trying to obtain the current Form viewed Record Number to use it to
>>> output a Report (using a button on the Form) on that particular record
>>> by capturing the record number and reusing it to do the detail search
>>> the table. I have tried a number of ways without success. I want to use
>>> the record No. because many (example) names are similar defined by other
>>> entries so it is not to select by visible details on that record.
>>> Can someone offer me a simple method to do that and capture it for use