Jump to content


  • Posts

  • Joined

  • Last visited

Curtis_B's Achievements


Explorer (4/14)

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

Recent Badges



  1. Awesome! Thanks Lee, I didn't realize that the 2nd find request would also inherit the ship date limitation of the first request. I assumed a 2nd find request was a concurrent OR type of request (in this case, allowing any ship date).
  2. Hello, I've been a FM7 user for 4 years now, and I do consider myself to be pretty well aware of what can be done and what can't. However this request threw me for a loop this morning. Our accountant asked for a report of all orders that shipped out of state in 2007. In my mind, I'm thinking that means I need to find a ship date of 1/1/07...12/31/07 AND the state does NOT equal MN. I am aware of the 'omit' flag for finds, but have never really needed to use it. I'm not sure how that would help me in this situation since I also need to limit the year to '07. I'm stumped. I ended up just making a copy of the file and butchering the copy to get what I needed ( just deleting records I don't want to account for ), but I'm surprised that I couldn't do it right in the first place. Can anyone make a suggestion as to what I missed? An SQL equivalent of what I want would be: SELECT * FROM db.Orders WHERE SHIPDATE LIKE "2007%" AND STATE != "MN"
  3. I had this same problem and solved it. Your post didn't mention installing mysql connector, I'm assuming you already know about that step and have done it. http://www.mysql.com/products/connector/odbc/ This is what happened to me, I installed the connector, and Mysql still did not show up on my System DSN list and I was baffled. I eventually found this thread on the mysql forum: http://forums.mysql.com/read.php?37,31449,31449#msg-31449 As it turns out, this is a glitch with the mysql connector installation (I think) but it doesn't affect everyone. The fix is to locate a registry entry, export it, do some manual editing, and import the saved changes. All of the instructions are detailed in the mysql forum thread link above. Good Luck... so far, I like using FM with Mysql, but I haven't had enough spare time to do any thorough testing.
  4. We have an invoice counter field which is global. It basically just keeps track of the next invoice number to use. We need this to simulate an auto-increment (although it can't actually be an auto-increment for reasons I won't get into here). As it stands, we use a global field, which works great for one person, but of course does not work well for multiple people. I'm trying to figure out how I can setup this invoice counter to stay current across multiple users. Any input would be appreciated. Thanks, Curt
  5. Yes, that attachment was a tremendous help. I have never set up a condition as a relationship to a new table occurence before. I didn't even realize I could do that. Thanks, problem solved Curt
  6. Awesome, that did satisfy my simple example. Thank you. Now, here's where things get complicated. Each claim is considered either 'on time' or 'late'. I can represent this status in a number of ways. My Ultimate goal on the list of office locations is to calculate the number of 'on time' claims vs. 'late' claims. To add another level of complexity, this number will be based on a user inputted date range (globals, I currently have them in the office locations table). So basically, I want to add conditions on top of this summary. Any suggestions? I apologize if this explaination is too vague. Thanks again, Curt
  7. Maybe it's getting too late for my brain, but I'm stuck on a concept here. I have two related tables, office locations and claims. Each office location will have many claims. Each claim will be linked to only one office (by inputting an office id). For the sake of clarity I will simplify my objective in this post. Lets say I want to have a list in the office locations table, where all offices will be listed row by row. For each row there will be a calculation telling me how many claims that office has in total. I'm not sure how to accomplish this. I know that in SQL I would be selecting the row count where officeid = officeid, for each office. Your help is appreciated! Curt
  8. I'm hoping to do the sql equivalent of 'select distinct' in a filemaker find. I'm in version 7. I know I could write a script to give me distinct values, but I would hope this is a built in function. The manual makes no mention of such functionality. Thanks
  9. Does anyone know how to get rid of the 'no found records' dialogue box? I hate the fact that my employees can (and do) press cancel when they need to be continuing the script that is running. thanks
  10. I come from a php programming background. I'm trying to do something in filemaker where the script would check if something exists, and if it does not, then carry out certain procedures. In php, it's a simple if statement like this: if(!$variable){ then do this; } Let me know if you can tell me how to do this, I appreciate it. Curt
  11. Thought I would speak up here. I have a php/mysql site running remotely on our webserver and FMS running locally on our network here. We love FM for our in house information system, and php/mysql on the web end of things, so I recently developed a solution that automatically replicates FM >MySQL daily (or could be as often as needed). There is no need for incoming web>fm data for our solution, so it is just intended to display information. When I get some free time I'll document how I did everything and post it in this forum. Curt
  12. Good Afternoon, I'm working on my first bar code solution in FMP. My reader terminates with the Carraige Return/Enter key. This will perform a find if I am scanning the search criteria, however aside from the finds, I'm hoping to use barcodes for data entry purposes in browse mode (tracking production progress in a manufacturing environment). If I'm in a script that is in browse mode and pausing (using the pause/resume script step) at a field for scanning (and moving on) the Carraige Return/Enter key does not resume the script, it merely starts a new line in that same field. I've noticed it's the Enter key by the keypad that will move the script along in the same situation. Can anybody shed some light on this subject? I'd really like to re-program my termination keystroke to be the enter key by the keypad, but my scanner's manual does not list that as an option. Worst case scenario, our employees can press enter after scanning, but it seems unnecessary. Thanks, Curt
  13. I have noticed Stanley mention that barcodes can trigger scripts. He even posted the code for [ctrl-1] for use with code 3 of 9 as being *$H1$J*, unfortunately for me that does not trigger my ctrl-1 script in filemaker using the same barcode font. What I'm hoping to do is have a list of barcode script triggers (ctrl-1, ctrl-2, etc) so each employee can scan the specific task (script) and then our physical job ticket (invoice number). So after the script is initiated it will pause in the invoice number field, until the job ticket is scanned and then the information has been properly updated. As a default, my scanner uses carraige return as a terminator. I'm assuming I have to remove any terminator to properly make use of a ctrl-1 barcode (so as to not interupt the script). I did this and the forementioned code still does not seem to trigger my script. Anyone have any advice for me? I am open to purchasing whatever font that may be necessary if it's a matter of using something different. I'm using a WASP WCS 3900 scanner. Is it possible that the limitation is in the scanner? Storing a preamble will not help me as there will be multiple scanning stations in our workshop where different employees will be scanning for different reasons (different scripts). On a related note, I can't seem to find codes for control characters anywhere on the 'net. Your help is greatly appreciated, thanks! Curt ------ UPDATE I emailed the manufacturer and this was their response: Unfortunately all the different barcode symbologies are limited in what characters can be encoded by the ASCII set. The CTRL isn't an ASCII character so cannot be put into a barcode. In general no keystroke combination can be entered either, such as Shift 5. You can put % in, but that's not the same as hitting the shift key then hitting the 5. It's its own ASCII character, whereas Shift isn't on the ASCII chart.
  14. I've finally figured it all out today. I have successfully setup an EFFORTLESS filemakerpro >> MySQL solution. I am very excited about this. So far I only have it going for one table, eventually this will be setup for all tables that apply. What happens is this, a filemaker pro script triggers the entire process: -show all records (optional) -sort records (optional) -export records (must be a tab seperated text file) -open url (local batch file ftpconnect.bat) -open url (remote php file www...import.php) the ftpconnect.bat uses windows command line ftp commands to connect to my webserver's ftp, erase the existing (previous) TAB file, upload the current TAB file (non-public folder). import.php deletes the MySQL table, re-creates it, and then uses the LOAD DATA LOCAL INFILE command to import the TAB file into the MySQL table. and that's it. My ultimate goal is to setup a customer fullfillment system for a printing company, which will not only display real time data but accept incoming requests (quotes, re-orders, etc.). The incoming requests will remain in the php/mysql world. I will no doubt be developing this solution as time goes on. Curt
  • Create New...

Important Information

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