Jump to content

Eden Morris

  • Content count

  • Joined

  • Last visited

  • Days Won


Eden Morris last won the day on May 15 2012

Eden Morris had the most liked content!

Community Reputation

2 Neutral

About Eden Morris

  • Rank

Profile Information

  • Gender

Recent Profile Visitors

4,523 profile views
  1. SQL Builder

  2. Pull select records

    I read that section and it looks like doing a sync before I upload the file should work and there is nothing else I need to do is that correct? I just want to make sure that there isn't anything odd that happens with the PersistentID or something else I am not thinking of.
  3. Ah! ok! when I change with another computer it works!
  4. yes, for this test. I am using my laptop.
  5. Update: If I reset and not wipe then the changes and new records from the server will make it to the client.
  6. replaceAll() Function

    much better! thanks! I made it much simpler though...
  7. replaceAll() Function

    I am trying to use the replaceAll() function on some text. If I insert the code as an input variable the code doesn't work. But if I copy the code text right into the script it works just fine. How should I format this so that it works?
  8. I feel like I'm missing something obvious. I'm trying to write some SQL to get an ID list for deleted records in a syncing solution. I'm finding that its slower than I'd like and this method feels like it's not efficient at all, anyone have a better idea? To explain what I'm doing I'm getting a list of ID's where the creation timestamp is before the last sync and then I check to see if it doesn't exist in the other file. The problem is that for every record I'm running rather large select statement within the EXISTS(). The table SP stands for Sync Projects and Q stands for Questions, I'm using SP to get only the questions that are attached to the projects on the client file. Get the ID's in the local file: ExecuteSQL("SELECT id FROM Q WHERE zCrTS < ? AND NOT EXISTS(SELECT * FROM H_Q WHERE Q.id=H_Q.id)";""; ""; $$LastSync) Get the ID's in the hosted file: ExecuteSQL("SELECT H_Q.id FROM H_Q , SP WHERE zCrTS < ? AND H_Q.id_project = SP.id AND NOT EXISTS(SELECT * FROM Q WHERE H_Q.id=Q.id)";""; ""; $$LastSync)
  9. If a field is referenced in an unstored calc from another table is just that result sent down the pipe or is the whole record from that other table cached and then the result is parsed on the client side?
  10. [Solutions] SQL Builder

    oh! ok fixed for the next version. TY :)
  11. [Solutions] SQL Builder

    Im not sure I'm following you. What calculation are you talking about?
  12. [Solutions] SQL Builder

    I added that feature, what do you mean about it wraps?
  13. [Solutions] SQL Builder

    Come on people, I know there have to be bugs or at least features you want. :)
  14. SQL Builder

    Version 1.2.3


    This SQL code generator will generate ExecuteSQL() code for FileMaker allowing you to use unsafe field names and make changes to database schema after making the code. If you have feedback of any kind such as bugs or feature requests please visit the support topic for this file. UPDATE 5/23/2012 Code window opens at start up Disabled field name check at start up. No bug fixes ( please send bug reports in the support topic ) UPDATE 5/23/2012 Added Settings page Added Loading page Fixed bug in code window UPDATE 5/16/2012 Misc bug fixes and UI tweaks UPDATE 5/15/2012 Table and Field ID's are now tracked allowing for auto repairing of table and field names after schema changes Misc bug fixes and UI tweaks UPDATE 5/13/2012 All new UI Support for more functions UPDATE 5/9/2012 (v1.0?!) Support for FROM and Right JOIN Table Aliases Misc. bug fixes Tweaked the UI UPDATE 5/5/2012 You can now group by a field without displaying it in the results Added JOIN Example UPDATE 5/4/2012 Added a Statement Creation Wizard ( v07 ) Improved Dynamic Parameters Support. ( v0601 ) Support for Dynamic Parameters. UPDATE 5/2/2012 ( Back From Vacation! ) Starting Value navigation buttons. Output code display options can be set at the bottom of the details layout. UPDATE 4/29/2012 Added warning icons that show up if a field no longer exists so that schema changes can be easily tracked down. Added starting value and maximum results in the results window. UPDATE 4/25/2012 Fixed "AND OR" Bug Insert functions into select field lines Adding a function to a WHERE line will change it into a HAVING line Manual entry will populate when entered on SELECT and WHERE/HAVING lines UPDATE 4/24/2012 Fixed bug in ORDER BY Table Occurrences are now all that is needed to populate the field list. UPDATE 4/23/2012 Added "Get at Date or Time" Check box for SELECT lines and an example of how it works. Statements can be assigned categories Simplified the code when there is no JOIN statement Code now has formatting to make reading the code easier Dropped the use of Quote() and now use escaped quotes You can attach a sub-query when using "WHERE IN" by clicking on the icon to the right of the value field UPDATE 4/22/2012 More Unsafe Names UNION drop down menu and examples showing how to use it. Documentation Thanks for the feedback so far...


  15. [Solutions] SQL Builder

    I have added the ability to limit the results window by starting value and maximum results

Important Information

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