Get(PortalRowNumber) Function Problem

[MarkCirino]

Hi All,

This is my second (frtustrating) day with FM 7. I've been using FileMaker since the original version and I gotta say this is the hardest upgrade yet.

Anyway, I posted a question about problems with Time Formats on MacIntouch and someone was kind enough to tip me off to this forum. Thanks!

I'm trying to learn 7 by converting my "DisCollection" database of CDs and vinyl. I have a relationship of Tracks to Discs. The Disc layout has a portal with the Track "line items". I want the track numbers to be inserted automatically as I add each one. In the past I've used the Get (PortalRowNumber) function and had no problems. In version 7, however, the value retured for this function seems to be the Row Number + 1!

The first row I enter gets a 2, the second a 3, and so on!

Has anyone else seen this, or can anyone try reproducing it for me? I'd appreciate any help.

Thanks!

- Mark Cirino

FileMaker Version: 7

Platform: Mac OS X Panther

[Ocean West]

This is a strange behavior... I wonder if FMI knows about it Perhaps a bug...

I just tried this...

you could do Get(PortalRowNumber)- 1

But I don't see why we should have to

You could create an "Add" button

That goes to last portal row. and sets the related

track number to Get(PortalRowNumber) this seems to work.

[MarkCirino]

Thanks for the response, Stephen. In my new file, for now, I am using the "-1" solution. It's worse, however, in the converted version of my FM 6 file. The exact same Auto-Entry calculation in the converted file returns "0", so every new row is numbered "0".

I will not be recommending upgrading to FM 7 for any of my clients. It's just too flaky right now!

[-Queue-]

Sounds like 7 uses a two index for portal rows?

[ernst]

I tried to reproduce this problem, but here it all works like expected , i.e like in Filemaker 6.

??

Ernst

FM7 Developer, MacOS 10.3.3

[-Queue-]

Here's a weird thing. If you click in a portal into a calc field containing Get(PortalRowNumber), it displays correctly. If you click out of the field, it then displays as described above. The last row then displays as zero.

[Ilyse Kazar]

I don't know if I'd define this as a bug, because I never would have though of using PortalRow as an autoenter calc ... how does the child record know, upon creation, what portal row it's in in the parent? Keep in mind that the Status/Get functions are intended to be used *in scripts*, and though they will *sometimes* work when used in a calculation field or auto-enter calc, consider this a lucky benefit and not a behavior you can depend on staying the same.

I'm sorry, though, to hear that it worked for you in the past and that new behaviors in 7 broke your technique.

Meanwhile, if you script the portal-row creation (I personally don't like "allow creation" portals anyhow -- you can just control so many things better by script) and as the last step of your "New Track" script come back to the parent file and set the portal row # into the new child record ... that will work. IOW, FMP 7 *does* know what portal row you're in when you use the Get function as intended -- in a script. Set Field [Tracks::TrackNumber, Get(PRN)] works just fine.

[dreamingmind]

How 'bout setting the field to the count of related records instead of the portal row. You may still have to add one (haven't tried) because the record in the process of being created may or may not be counted. Either way, it would make some sense.

Don