Sunday, November 1, 2009

Which of the following in conjunction with portal sorting, could slow database response?

a) A Field Or Fields In A Sort Order Are Unstored

b) A Field Or Fields In The Sort Order Are Complex Calculations Using Many Fields

c) A Field Or Fields In The Sort Order Are Calculations Using Other Relationships

d) All Of The Above

=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================

For a more challenging quiz environment, check out our interactive FileMaker quiz product at http://www.dwaynewright.com/inbiz/quiz/index.html


More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Wednesday, September 16, 2009

Portals can be made to show a custom sort order by ...

a) Manage Relationship dialog box

b) Portal Setup dialog box

c) Both A and B

d) Neither A or B

=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================


More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Tuesday, September 8, 2009

A portal field with the OnObjectEnter script trigger will fire when tabbed into for each portal row.

a) True

b) False

=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================


More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Monday, September 7, 2009

A READER ASKS: Portal Row Misbehaving

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

APPENDIX 1: A Reader Asks

A READER ASKS
I have been STUMPED & STUCK with an issue in FileMaker - I came across your blog in searching for some solutions so I thought I'd try sending an email. I think I'm probably an intermediate level user of FileMaker... We upgraded from FP5 to FP 9v03 and since then I am unable to enter data into a portal that pulls information from a related class file. I can enter the code that pulls up the class information - class, teacher, room number, etc. in the first row of the portal... When I click into the 2nd row to enter a new class - one of two things happen - the information from the first row automatically clicks into the 2nd row, and I am unable to enter any data. OR, I click into the 2nd row and it's inactive - I am unable to enter any data... Any thoughts? Suggestions?

-------
DWAYNE RESPONDS
Any thoughts I have are at best ... unqualified. This type of problem would likely need hands on inspection and that would fall into a category of services I would need to charge for. It would likely take less than a hour for me to figure out, describe and fix and my current rates are $85.00 for this. Any unused time would be in a retainer for you to use any other time you might run into a stumbling block.

OFF THE TOP OF MY HEAD
It sounds like someone might have attached a script to the portal row (via a transparent box) or a script to a field(s) in the portal row. A change elsewhere in the database (possibly the update itself) might have caused the script to break and that is why you are getting the odd behavior.

If there isn’t an attached script, then we might have a field that doesn’t belong in the portal row, due to a relationships mixup. Although I would have to say I’ve seen many relationship mixups in my day and none of them have the behaviors you described.

Then we have the barrel full of monkeys that might be a poorly designed relationship graph and how it is incorrectly applied to the context of the layout itself.

If you want to purchase a support hour and send me the files, I’d be happy to give it a look over. I can send you a PayPal invoice that you can pay with a PayPal account or a credit card such as Visa, MasterCard or American Express.
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit http://www.dwaynewright.com/donate.html

Sunday, August 30, 2009

Which two characters in a portal row will display a count of each portal row in order?

a) @@

b) ##

c) ^^

d) //

=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================


More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Saturday, August 29, 2009

Which of the following is NOT an option in the Portal Setup dialog box?

a) Allow deletion of portal records

b) Show [ enter number here ] number of portal rows

c) Show horizontal scrollbar

d) Alternate background with

=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================


More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Thursday, August 20, 2009

Portals have ...

a) Calculation Capabilities

b) Filtering Capabilities

c) Both A and B

d) Neither A or B

=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================


More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.