Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by Oldfogey

  1. Thanks Ocean West. Brilliant idea. Should get me going but still leaves me with dozens of FMP files half written in V10. Such is life!
  2. I'm still using FMP 10. Well, I was until a few days ago. I made the mistake of deleting my FMP from WIN7. No worries - just re-install it. It keeps asking me for a 'qualifying product'. Although I have the CDs for a few earlier versions, I cannot find any of the associated paperwork; so, no luck. (We've been moving from house to house for a few years and lots of stuff has gone missing or been buried in unrelated boxes.) Please don't nag me about backup! My backup wants a password; guess where I keep a record of my passwords. Yep, in a FMP file. Does anyone have any idea how to get around the problem of missing 'qualifying product'? I haven't tried contacting FMP themselves, as I doubt if they'd like to help a v10 user.
  3. Thanks for the suggestion, Olger. Does that mean you know that there is a problem? If so, my son would almost certainly have trouble with a runtime solution!
  4. Does anyone know if there is a problem using FM10 Advanced to develop solutions while runnning WIN 7? I've been retired for a few years and supported one (ex)-customer using WIN 7 with no problems making minor mods. Recently, I got a request from my son to write a fairly trivial DB for his business. I've had funny glitches like a double-click on a button not letting me edit the button's text; closed the DB and re-opened it - no worries! Today I nearly went insane trying to get 'Constrain Found Set' to behave! On top of that, my memory isn't what it used to be, so when things do not behave as I think they should, I wonder is it me or the FMP/WIN7 combination or all three. Any clues? (To answer the obvious question, I cannot justify an upgrade to V12, especially as I'd have to pay full price.)
  5. I've been sort of retired for a few years and my son has asked me to design a very simple DB for him. I have FMP V10 (Advanced) and Win 7. He has Win 8. Will a runtime v10 solution run on win 8? (I'd love to upgrade to V13 but FMP's prices are ridiculous for retirees, no matter how keen.)
  6. Thanks, Iawaid. You had me worried for a moment. My field names are all fine. I'm guessing you objected to the '&'s. My 'Field1 & Field2' referred to the calculation. My fields are Field1 and Field2.
  7. I just noticed that I am descibed as a 'veteran' here. On another forum I joined recently, they listed me as a 'Junior Member'. This is very confusing. I never know whether to wear hipsters or proper trousers. As for my hair do ... Wouldn't it be an idea for all internet forum moderators to come up with standards?
  8. Can anyone throw some light on this problem? I have a simple table of addresses, linked to a person table. There are two auto-enter by calc fields. One is Line1 & Line2; the other is Suburb & State & Postcode. Really complex stuff. Both have 'do not update' unflagged. Both have do not calc if all empty. The basic fields are entered in a portal when new people are added. Recently, for a new batch of people, these calcs have stopped working on initial entry - but only for some people. On my system, if I change the Suburb, for instance, the calc works. At first glance, it looks as though the Address records in the portal are not being committed - ever! My customer is using V8.5 (on WIN XP) but, recently, I upgraded to V10 (on Win 7) In theory, this should be irrelevant but I can't help wondering.
  9. Recently, I took my new laptop away from home with me. Amongst the many things I hadn't got around to doing was putting my password DB on it. I couldn't log on to the Forum so I ticked 'Forgotten password'. This was quite a few days ago and I'm still waiting for the promised email. Back home now and all is sorted but thought I should mention it. Does clicking that send an email from my machine? If so, that would explain it; I was using someone else's ISP, so no outward email. (Platform Windows 7, which isn't in drop down list.)
  10. Thanks for that info, Comment. Looks very interesting and I just wish I'd seen it a few years ago. (Sorry about the delayed response; been sort of out of action.)
  11. I've done a lot of work with labels/cards of all kinds of sizes. Only once have I ever found a standard FMP label layout work properly. I just use custom sizes all the time. Very little messing about required.
  12. I'm guessing that your exports are scripted. Correct? If not, ignore this. Exporting from FMP can be a nightmare if you are developing or, worse, modifying a DB. Every time, you delete, add or rename a field, you need to re-code the scripted export. Otherwise, you are likely to get output you were not expecting. As far as I'm aware, there is no simple solution to this. If there is, I'd love to hear it.
  13. I have a customer who is a bit worried about my long grey beard and glittering eye and wants some Australian contacts in case I drop dead. (Or if they get fed up with my errors.) It's a not-for-profit outfit but reasonably wealthy. Their office is the database secretary's laptop. She is located on the Gold Coast but commutes fairly regularly to Sydney, Brisbane and Melbourne. I'm in Sydney and, although it has been most valuable to meet physically during the main development stages, we've managed quite well using email and phone. I have sort of finished development of their main membership database. There is still a fair bit of work to do. One large(?) segment is just a table with some old copied layouts. The DB Sec didn't know what was required so I just copied the basics from their old DB. At this stage, I just want to hand over a few names, so if I can use your name or if you have any more questions, please contact me at [email protected] or 02 9905 7006 after Sept 7. (FMP 8.5)
  14. I think you'll find this is an undocumented feature in Excel. I don't remember the exact details but I had a problem with formatting empty cells in Excel 2003 - it just wouldn't take properly. I remember! (I think) I formatted a group of numeric, or maybe date, fields; the group included some empty cells. When I entered data into the empty cells, the data stayed unformatted. Sorry to be so vague but formatting was the least of my worries at the time.
  15. My apologies for apparently ignoring you, Gentlemen. (If you don't tell me your troubles, I won't tell you mine.) This problem more or less resolved itself. Firstly, the customer is on XP, not Vista - phew! Secondly, the problem doesn't exist. There was a bug in my coding which necessitated multiple clicks on the 'Return' button; this became a time problem! Don't ask me how.
  16. Hey, Rufus. I'll bet money that you've got a conditional 'Go To Layout' script step hidden away in there somewhere.
  17. Thanks, IdealData. I'd missed the stuff about Vista. I've been trying to get them upgraded for ages. Trouble is they live in the boondocks with slow net and the upgrade is humungous. I'll have another go! (Soren, I really don't know what you are on about. Firstly, if the CF was bloated, I'd have the problem too and I don't. Why on earth would navigation between layouts use "Bloated layout objects"? I simply get the layout number and store it. My first port of call for ANY problem is ME. I don't blame customers for my problems or their own whims - in spite of being proved wrong continually.)
  18. Does anyone know of an issue where a CF written in Developer (of course) has dramatically reduced performance on a machine running basic FMP? I use a simple CF to navigate through layouts and a customer is complaining that 'Return' takes a long time to do anything - like a cup of coffee time. They all work fine for me and her machine is newer and presumably faster than mine. I'm using FMD 8.5v2 on XP, customer is using FMP 8.5v1, on Vista I think. (Note the 'v1'.)
  19. I'll jump in a bit deeper and suggest avoiding any special characters in file names - unless you have an excellent memory and remember which ones are OK.
  20. I played around with this and came up with a similar CF but I had few 'wonders'. Would a sort followed by a scan be quicker? Would it be an idea to include a check for the (latest) value count being greater than the count of the remaining values? I think I'd be trying to find out a bit more about the data characteristics if possible, because efficiency depends so much on these. Finally, I wondered where the values came from in the first place. Presumably, they are in individual records? In this case, a sort with summary counts should provide the required values with very little trouble. Even better(?) a self-join on Value'. Just curious but too lazy to satisfy my own curiosity.
  21. Go to File->File Options->Text and tick 'Always use Current System settings'. If you are having trouble, I'm guessing that you are looking at sample files; the above will fix that - assuming of course that your system is set to Oz format! Most of the time FMP will then display your dates in the local format. You might have to tailor the odd date field (do it in layout mode) but it's unlikely. Good luck!
  22. Sorry for the delay, UpNorth. Been trying to stave off hunger. Another apology, I should not have mentioned GetSummary(). It doesn't work across tables. I was just trying to make the point that you can get your basic report, as you have done, fairly quickly; the only thing you haven't got at that stage is the set of stored totals. You'd be lucky to get your coffee made while the report was running. There are umpteen ways then to get those totals copied into you Client table. (I have to wonder why you want them there when you can always regenerate them.) By far the easiest way is to create those relationships. Do you have three different types of WO records or three different hour fields in each record? If the latter, you only need 12 relationships. Probably the next simplest is to just loop through the WO records and transfer each subtotal across to the client table. Looong time but let it run overnight. You could also create a new file by exporting the summary data. It is then a piece of cake to use a simple relationship to display the totals or, if you insist, transfer them to the main Client table.
  23. I am; it's nuts. My last post was ambiguous. I have never suggested such a thing but most of your (and others') comments refer to just that. I have no quarrel at all with FMP not providing a Max() that handles text. My beef is that they imply the current one does. The issue with weak vs strong typecasting is very simple. If you are working with a strong typecasting 'language' it should be a bit weaker and if you are working with a weak one, it should be a bit stronger. I would not want to change FMP in that area.
  24. Agreed. Comment, I would never dream of arguing with you about the way FMP operates. Ever since I raised the question of why Max() did not operate the way FMP implies it does, I've been besieged with implications that I am some kind of nut for thinking that you can find the maximum of a set of text values (even though a few well-respected packages do just that!) or that I want to compare, or find the maximum of, different data types.
  25. Sorry, Genx, for not responding. I solved the DB problem ages ago by just using conversions to Number - much simpler than adding yet another relationship. The current discussion is about FMP and the Max() function.
  • Create New...

Important Information

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