Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

aharown07's Achievements


Collaborator (7/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. OK, as often happens, when I get frustrated and quit looking for answers, then come back and try again later, answers materialize. So I have an answer to #1. In Access an auto-enter calculation is a "Default Value" calculation. Still no idea if these will calculate during an import, but will find out soon. Still interested in how to do portal-like stuff in Access. Edit: NO, it's not as simple as it seemed. Apparently Access won't accept a field reference in a default value calculation because there is no value in the referenced field yet... or something like that. So there appears to be no simple way to do this scenario: enter data in field AAA and field BBB; make field CCC concatenate the first 20 chars of AAA and BBB and put the result in CCC once and leave it there until you change AAA or BBB. (Appreciation for FileMaker continues to deepen!)
  2. Longtime FM Pro user, and it's still my go-to app builder whenever I have a choice. But now I've got to put together an Access-based solution at work. Might make sense to ask these questions in an Access forum, but so far, nobody there knows FileMaker, so... A couple things I could use some help on from anyone who has used both platforms a good bit. In FM, when I want to process imported data bit but not weight the solution down w/too many calc fields, I use an auto-enter calc that adjusts the data during import. So, what's the nearest equivalent to an auto-enter calculation in MS Access? I'm using calc fields so far, but have concerns about this getting slow eventually. How do you display a list of related records, like a portal, in MS Access?
  3. Thanks. I believe your value list approach will do the job in a pretty bulletproof way. Only changing the value list could break it. FM should edit the help documents a bit on the Max function. It reads 'Returns the highest valid value in a field.' This is not really quite what it does.... maybe "Returns the highest valid value among a set of fields" or something... All the examples are multiple field scenarios, but I was hoping the single-field-multiple-values scenario might have simply been omitted for brevity or maybe was too simple to need examples. Alas... Anyway, thanks.
  4. The Max function is not behaving as I expected. What I have is a "month" field that is number field. It accepts multiple values using checkboxes in the layout. But I have a script in which I want to take only the latest (highest number) from that field, assign to a variable and do stuff with it. But if the field has, say, 1 2 3 4 5 6 7 8 9 in it, Max gives me 123456789 rather than 9. So how can I consistently get the high number out of there? I've played with GetValue a bit, but that solution is a bit fragile, because the user could select the month number checkboxes in any order... meaning the highest is not always in a particular location in the series. I haven't done much with multivalue fields before this so... I'm probably just missing a concept or two. (I'm in FMP advanced 14)
  5. I'll be looking at that. I think there are several that will have to stay. But I'm sure there are ways to replace some of them with auto-enter replace calculations and store them.
  6. Thanks. Yeah, I think you're right. Thought I read somewhere that a GTRR via a sorted relationship was qicker... It certianly seems to do "finds" faster. But with some playing around... I'm not seeing a difference. So I'm back to going to a vanilla layout, freezing the window and doing the sort.
  7. Seems like I used to know how to do this... And I'm sure it's been answered, but I can't seem to come up with the right search string. I've got a table w/12,000 records in it.Ton of fields, several unstored calcs. It sorts rather slowly using the Sort command. Solution, I thought: set up a self-join TO with the sort set up in the relationship. GTRR to the TO. It does seem to be quicker. (The self join is by a numeric field crossproduct relationship) But... it doesn't retain it's current location in the found set. That is, I want to sort with record X selected, and after sorting, still be at record X. How to do that?
  8. Did find this, though, in a discussion somewhere... "A common cause of data corruption is backing up live files using third-party backup software (or even, manual duplication of a file). The best strategy is to use FMS's own backup scheduler, which is secure against this. In all other procedures, make sure the files are off-line before backing up." This is a possibility, since we've got some backup stuff running. Worth looking into, anyway.
  9. How I've been handling my files? Not sure what you mean. As for users, yes, they should properly exit the program before shutting down Windows. But I can't be there to hold their hand every moment. But none of this explains why the DB is suddenly so fragile when the same technology-challenged folks were using it before (on XP and FMP9) without difficulty, despite doing goofy things to the PC. Already did a fair amount of google searching. Most of what I'm finding so far is about recovery rather than causes and prevention.
  10. A solution I developed a few yrs ago recently migrated to FMP10 and to the Windows 7 OS. Users use the solution as a runtime app. Since moving to Win 7, we've been having a problem we didn't before. Users have always periodically shut the OS down--either by sudden power loss, absent mindedness or whatever--while the solution was still running. In the past, the file has usually been OK. But since going to FM10 and Win 7, the solution has corrupted files whenever 1- the machine is powered off (in this case, I can accept file damage as pretty much normal) 2- windows is rebooted while the app is still up So I'm trying to figure out why. This is not a server situation. Just client only, one user at a time. Are there certain kinds of functions etc. that might make the file more vulnerable to corruption in these cases? Each time it has happened, the file has been so badly clobbered we had to go back to a backup. (Thinking it might be virus protection affecting the file, I put the solution's main file on the don't scan list.... no noticeable result)
  11. Got it! Case(PatternCount(Item::Amount;".")=0;Item::Amount&".00"; PatternCount(Right(Item::Amount;2);".")=1;Item::Amount&"0"; Item::Amount)
  12. Thanks... I see the problem. The calculation result that sets the variable is text. The answer might be in the thread you linked to, but I'm not (yet) understanding it. Will have to do some more reading. Edit: problem is that these are usually negative numbers but also occasionally positive ones
  13. I'm generating a report in which the script goes through several records one at a time and sets a variable to contain values from multiple fields in each record (separated by tab characters usually). Most of the fields are text. But one is an 'amount' field which should look like 3.50 or .90 or 3.00, etc. So the zeros are important. At the end of the script, the variable is dumped into a field. Problem: the contents of the "amount" fields show as 3.5, .9 or 3 instead of 3.50, .90 or 3.00. I tried using SetPrecision() but no change. Apparently, the field's number format is not going into the variable along w/the field value.... either that or the fact that the variable stores both text and numbers, it's taking it all as text? (I guess, now that I think about it, I'm not 100% sure they are going into the variable without the formatting... it could be happening when the variable is dumped in the field?) In any case, how might I get these numerical values to look right in a big text field with alot of other stuff? Code snippet Set Variable... $rptitems&¶ &Globals::gTab &Item::Number&Globals::gTab & Item::Date&Globals::gTab &Payee::PayeeName&Globals::gTab&Item::Memo&Globals::gTab&SetPrecision(Item::Amount;2)
  14. What I want the script to do is perform a search on field A if it's text but search on field B if its numeric. So, basically, trying to use one search field to perform multiple searches based on user behavior. The app has an Amount field and also an Item Number field and a couple of text fields... so trying to search all of them from one box is probably a dream... it may be better to have one search box for text fields and one for the numeric fields or else buttons to route the script in one direction or the other. Another option might be to just decide on a sequence and whenever the search comes back empty, try it again on the next field until there are hits... or a "nothing found" message. ... Unfortunately, the amount field could well contain something like .59 so that eliminates one of the other ideas above
  15. Want to make a little "quicksearch" field in a solution. (Still in Fmp10adv). The script should check a global field and then proceed based on whether the field contains a number or text. So I need some "if" logic. Simple enough. But my brain's cramping on how to identify whether the field contains text or a number. Tried some IsValid combinations like IsValid(Abs(thefield)) but apparently the absolute value of some text is valid.... as is the Int of some text. So I need a boolean result based on whether the field contains text or a number. ... or maybe a reliable way to generate a particular error whenever it's text or whenever it's a number. Would be easy enough to condition the script on the error.
  • Create New...

Important Information

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