Record Selector Number

[Jerry Hartness]

Re: Record Selector Number

Tim, I used your example (msg # 12) some time ago and it works great. On my attachement I inquired on vehicle 105 for certain dates that come up with 62 records. The big number below all this is the actual record number in the database. Thanks for supplying it to us. Maybe Preston can use this in his appl.

thanks
JerryFixit.pngFixit2.png

[Tim Kiebert]

Re: Record Selector Number

Your welcome Jerry, glad you got some use out of it.

[SNusa]

Re: Record Selector Number

...Another function that could be used if one is uncomfortable with that warning in the help is COMPUTE_FIELD_STATISTICS(). Which in this case would be used as str(compute_field_statistics("Product_Id").count)

Question: How can you append .count to compute_field_statistics("Product_Id") as this returns a value of type C according to the wiki?
(I know the wiki also makes reference to this returned variable of type C also being a .Dot type variable.)

Looking at the help files, I notice that both the wiki & help file indicate this function returns a value of type C, but it's ALSO a .dot variable???? Possibly I don't fully understand the meaning of a .Dot variable....

If I didn't know better, I'd think the function "returns" a value of type C as stated in help, but actually "produces" a .Dot variable which has sub-elements / properties.... And therefore you can in fact append this call to a function with .count, which is a property of the .Dot variable???????

[Tim Kiebert]

Re: Record Selector Number

Hi Robert,

I would say the help/wiki is in error here. The return type in my testing is P. I never really noticed that it said C or if I did I didn't pay attention to it, or I did And have forgotten. I guess when I read dot var I assumed P

While having the Alphasports invoice form open try this in the interactive tasklist (the interactive that is part of the form editor not the main Interactive window. Although you could link the main interactive if you wanted to.)

?typeof(compute_field_statistics("browse1:description"))

and

?typeof(compute_field_statistics("browse1:description").count)

?compute_field_statistics("browse1:description")

?compute_field_statistics("browse1:extension")

Notice that running this against a numeric object that you get more info. This is the same as the Stat icon on the standard toolbar.

There is a similar function for a table pointer that sheds a bit more light on this. <TBL>.FIELD_STATISTICS() where the result variable is listed as P

[SNusa]

Re: Record Selector Number

Hi Robert,

I would say the help/wiki is in error here. The return type in my testing is P. I never really noticed that it said C or if I did I didn't pay attention to it. I guess when I read dot var I assumed P

While having the Alphasports invoice form open try this in the interactive tasklist (the interactive that is part of the form editor not the main Interactive window. Although you could link the main interactive if you wanted to.)<TBL>.FIELD_STATISTICS()

Hi Tim;

I know how to set the IW session using the menu (which does the same thing I presume you suggested I do.)
But I don't know how to get to the "Interactive Task List." ~ Could you show me a photo, or elaborate on what IW you are referring to? ~ Thanx.

Essentially, a "Dot Variable" is a Pointer, right? (& what's the difference, if any?)

Note: I did see that it is type P using the regular IW and setting the session. ~ Typo!

PS: I'm at the point where I could have/should have checked for that on my own. Problem is, I usually assume documentation is right, and I'm "misguided." ~ Just another part of my "steeping-stone.")

[Tim Kiebert]

Re: Record Selector Number

28-04-2012 9-07-26 AM.png

[SNusa]

Re: Record Selector Number

Got it, thanks Tim!

I thought the form should be running. Just the other day I realized you could set [link] the IW session to a particular window and use it while the form was running. "within the instance of the form" (thus providing relative object references etc. ~ nice feature)