Jump to content

8.5 problem with "Get ( RecordNumber )"


This topic is 5605 days old. Please don't post here. Open a new topic instead.

Recommended Posts

OK, is anyone else seeing this. I am getting the wrong record number reporting when records are omitted from the found set. Get ( RecordNumber ) reports the record number as if all records were found...but it is intermittant. :) Have reported the bug to FM.

Link to comment
Share on other sites

The calculation must be unstored. You could also have some corruption but I don't recall vs. 8 having that 'losing its index mind' problem like 7 did; which would incorrectly display record numbers. What 8 version are you using? I haven't used 8.0v3 yet.

Link to comment
Share on other sites

Get ( RecordNumber) just displays the current record number - it has nothing to do with a found set. But I haven't tried 8.5 yet. Are you saying that you can view the last record in a found set with 20 records and it still says 20 even after omitting some records out of the set?

You are certified so I assume you know to check that the calc is unstored. Sorry I can't help more ...

I now see 8.5 in the subject - I look at a User's profile or the bottom of the first post.

Link to comment
Share on other sites

Actually it has everything to do with the found set since it is the record number IN the found set. On validating a field it returns the wrong record number. :P But yes, even after omitting it thinks it is the 20th record in your example. It doesn't seem to do this in other situations that I can find, but validation...interesting.

Anyways, I have uploaded a file to illustrate the point. Hope this helps. I know I haven't described this in the best way.

Get___RecordNumber__.fp7.zip

Edited by Guest
Link to comment
Share on other sites

The problem I see is the name of the field, "Get ( RecordNumber )". This is not a good name for a field, and Filemaker does warn you that the "selected name cannot be easily used in a calculation formula". I believe your validation formula fails because it refers to the field's content, instead of to the current record number.

Link to comment
Share on other sites

When you change your calc name, it works for me. One should NEVER name a field a function. It DOES matter. If it isn't correcting itself, it may be because it's vs. 8.5 but if you create a new calc and test it, I'll bet it works just fine. Creating a new calc works just like changing your existing calc - both produce the correct record number when you eliminate using a function as a field name.

Link to comment
Share on other sites

A single text field, validated by:

Get (RecordNumber) = 4

Create a few records, and fill the field with serial numbers. Now omit some records and/or sort them descending, so that the original record #4 is at a different position in the found set. The validation allows modification of the ORIGINAL #4 record, but not the current one.

Link to comment
Share on other sites

I am not ready to upgrade. I still have some network testing to complete in 8.0v2. I want to then compare to 8.0v3. The only thing that currently bothers us is speed (I've designed around everything else) and that is small trade-off compared to getting answers to FM's internal workings ... and those answers only come from the slight variations between versions. I wish I would have been doing this from 7 forward. :wink2:

Thanks, Michael, I see the Get(RecordNumber) issue as well now!

Link to comment
Share on other sites

Beleive me, it has nothing to do with the field name...that is only for display purposes to illustrate the point. Sorry for the confusion. The problem isn't what is displayed in the field, it is what is calculated in the validation of the field. See the validation script for the field. It should validate OK when you edit the fourth record of the found set, but not anyothers. However, it doesn't work when records are omitted BECAUSE the wrong record number is being returned. Like I said, sorry for the confusion. I didn't really have a good way of getting the point across. But glad that I am not going crazy (completely) and that someone else can see the error even with my poor explanation! :P

Edited by Guest
Link to comment
Share on other sites

This topic is 5605 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.