Jump to content

adellos

Members
  • Content count

    15
  • Joined

  • Last visited

  • Days Won

    1

adellos last won the day on March 10 2016

adellos had the most liked content!

Community Reputation

1 Neutral

About adellos

  • Rank
    member

Recent Profile Visitors

1,417 profile views
  1. Hey Matt, I decided to roll my own sync. It was a more work then I expected, but so far it's working well. I realize that's not the solution for everybody as writing your own sync is not a lightweight task. The benefit for me was twofold. No 3rd party licensing costs and no "black box" when it comes to syncing. I've also done syncing before in other programming languages so I knew what I was getting into, mostly. So I wasn't facing design challenges (as in how the syncing works in the abstract) but I did face FileMaker challenges (as in FileMaker is finicky and IMHO makes a lot of sacrifices in language features for making scripting more accessible to the layman). Examples would be the fact that SQL is view only, that you can only pass a single parameter to a script, that there's no native nth field functionality, that there's no native hashing, no native UTC support. These can all be worked around, I did so, but it was a lot of extra work. If I had to pick one of the 3rd party solutions, I'd probably pick GoZync because it's 100% FileMaker; I believe no plugins or external software are used by GoZync. MirrorSync would be a very close 2nd because 360Works seems really on top of their game. It's its reliance on Java that's off putting to me. Not that anything is wrong with Java per se, but it makes me nervous for longer term support, especially on OS X which is my target. Of course, FileMaker Server itself uses java, so… HTH, Anthony
  2. David - Yup - confusing. I'd say there's some bugs in how the ExecuteSQL is implemented internally related to how it parses the SQL string and date values.
  3. Dan - That's a hair "apples to oranges" since you're using the timestamp function (which returns a date like this '1/1/1900 12:00:00 AM') while I was using a string literal with a SQL format date. FWIW using a string literal with the same format as what the timestamp function returns also works fine,so: "SELECT id FROM timestamp_test WHERE timestamp_no_index > '1/1/1900 12:00:00 AM'" works just as well as using the Timestamp function It's still buggy behavior to have the SQL date format work properly for non-indexed timestamp fields, but not for indexed timestamp fields. Indexing should not make SQL syntax become invalid IMHO. Anthony David - In regards to this: The date shouldn't have to be formatted that way, it's backwards, but it does work. The SQL-92 standard says it should be YYYY-MM-DD, so not sure why it's backwards with FMP. I'm going the route Dan suggested and using the format Timestamp returns or just using the Timestamp function which seems to always work. Anthony
  4. Try this query: "SELECT id FROM timestamp_test WHERE timestamp_no_index > '2012-20-09 00:00:00'" I think the day has to come before the month in the string literal used as the timestamp value in the WHERE condition.
  5. adellos

    Playing Audio on the iPad

    Fair enough. What I was getting at is that it looks like FM Go implements the "MPMoviePlayerViewController" class to handle media playback from container controls, and that that control is only fullscreen;so I get the design/engineering decision to not let a check box setting made at design time switch the whole UI context every time a record is entered. What I think might work as a pattern is: storing media files in containers saving the media file in the container to the FileMaker Go Documents or Temp path with a generic name "sound_file.mp3" using Export Field Contents Opening that generic file in a web view Unfortunately, when I tried to do a test along those lines, I got an obscure iOS web view related error. "Frame load interrupted". This may be because i chose mp3 as my format, it may not. So it appears that FileMaker Go was able to find the file, but the web viewer had difficulty playing it back. Hope some of that might be helpful! Anthony
  6. Right - it's flakey. As long as I leave the index off, the ExecuteSQL has worked as expected for me. I reported this as in issue in the "issue reports" forum @ forums.filemaker.com.
  7. adellos

    Playing Audio on the iPad

    I couldn't make it work and this note from FileMaker Pro 12 Advanced's help doesn't sound promising: In Filemaker Go, content in container fields is displayed by the iOS like other iOS audio, video, and PDF files. I could imagine the FMI engineers not wanting a setting on a field to automatically switch out of the layout context to the iOS quicktime playback screen. Maybe a web viewer? On FileMakerGo it will play YouTube in the layout, so I'm guessing if it pointed to a page that had the audio file and auto-played it that would work. Of course it's no longer a pure FileMaker solution at that point. One interesting thing was that I could airplay the youtube video running in the web container. Kinda neat! Anthony
  8. David - I take it you got the same behavior? I can't work out a way that it makes sense that indexes should break SQL queries against timestamp fields. I've been out of the FileMaker 'world' for awhile. Is there a best practice for submitting bugs to FMI?
  9. Lee, Sorry about uploading the sample file for my post (I did write a post in the forum you indicated was the correct one) in the wrong place. This is the first time I've attached a file and didn't realize the posting mechanism has an "attach file" at the bottom, I was looking for it in the "toolbar" instead. Thank you for moving the file for me. Anthony
  10. I've found what I have to think is a bug with indexes and ExecuteSQL. I've attached a very simple sample. To see the buggy behavior, do the following. Go into the "Define Database" window. Set the indexing value for the field 'timestamp_with_index' to 'none'. Run the script: 'timestamp_lookup'. Now go back into the "Define Database" window and set the indexing value for the field 'timestamp_with_index' to 'all'. Run the script: 'timestamp_lookup'. The second time you run it, the left "column" in the dialog should have no id values. This seems to be a bug with explicitly creating an index for a timestamp field and using ExecuteSQL to search against that same timestamp field. I'm running FileMaker Pro Advanced 12.0v2 on Mountain Lion (10.8.2) Anthony
  11. Sample file for displaying timestamp index bug with ExecuteSQL timestamp test.fmp12.zip
  12. You figure this out yet? I'm not sure what you're asking for but I think it's something along the lines of having a query: SELECT id, name, address_one, city, state FROM customers WHERE id = 12 Where the value 12 would correspond to a customer picked from a pop-up menu by a user? If that's the case, you might benefit from using a global field. Somewhat counter-intuitively (at least to me), global fields work on a session level, meaning their local to an instance of FileMaker. So say you have a two-field value list where the first (hidden) value is the id from the 'customers' and the second(displayed) value is 'name' from the same table. You could store the selected id in a global field named something like: global_customer_id You would then refer to that global field when you built your executeSQL function, so something like this: ExecuteSQL("SELECT id, name, address_one, city, state FROM customers WHERE id = " & global_customer_id) hth! anthony (Notice that I didn't put single-quotes around the id value because in my imagined scenario, the id is a number field and I believe that even in v12, FileMaker is picky about quotes around numeric values in WHERE conditions)
  13. Ocean - thanks. I'd looked at FMGoSync but it seems a tad neglected. I hadn't seen SyncMobile, but it appears to be in beta. David - Thanks for the summary. It jibes with the videos I've watched for both. Anyone else have something to contribute? I'd love to hear it. Thank you! Anthony
  14. So what's are the differences, pros/cons between mirrorsync and gozync? Are they 100% competitors or are there some differences in how they're supposed to be use/problem they're trying to solve? Thanks, Anthony Some background: I have a situation where users will be using an iPad/FileMaker Go 12 solution for data collection that would be synced with FMS 12 running on OS X server. The use-case is such that the solution users will often be in remote areas with no cellular coverage, so working directly with the remote host is not viable. Since I'd prefer not to "roll-my-own" sync, I did some research and it seems like the two go-to solutions are mirrorsync from 360Works and gozync from seedcode. So looking for some feedback to people who've used either/both.
×

Important Information

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