Jump to content

Eden Morris

Members
  • Posts

    69
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by Eden Morris

  1. 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.
  2. If I were to sync my client on my desktop and use that file with all the records as my deployed file is there anything I need to do to that file first or will all the clients just pick up the new records from there with no conflicts?
  3. I have a table for images, it is set to push from the client. I want to make a script that will let me send a select statement to the host that will get the related images for a record and pull just those records to the client. Can you point me in the right direction to create this? I want to make sure that I do not reinvent the wheel if there is already a hook somewhere to do this. Also if you can think of any things to look out for such as preventing the regular sync process from deleting records that I have pulled?
  4. Ah! ok! when I change with another computer it works!
  5. Update: If I reset and not wipe then the changes and new records from the server will make it to the client.
  6. I have a copy of the demo host and client. I have one new table and have deleted the other tables. Here is what is happening. What Works The first sync will pull the records. Changing a record on the client will send the changes to the host. Creating new records on the client will create a record on the host What doesn't Work Changing a record on the host will not send to the change to the client. Creating a new record on the host will not cause that record to create on the client. Any thoughts?
  7. much better! thanks! I made it much simpler though...
  8. 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?
  9. 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)
  10. 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?
  11. oh! ok fixed for the next version. TY :)
  12. Im not sure I'm following you. What calculation are you talking about?
  13. I added that feature, what do you mean about it wraps?
  14. Come on people, I know there have to be bugs or at least features you want. :)
  15. Version 1.2.3

    2,492 downloads

    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...
    Free
  16. I have added the ability to limit the results window by starting value and maximum results
  17. So maybe I'm not getting this right.... This will work: SELECT "Year" FROM "Random Names" WHERE "Year" = 2000 This will not though and it looks like it should: SELECT "Year" AS Y FROM "Random Names" AS R WHERE R.Y = 2000 What am I doing wrong?
  18. There you go, I will try to keep that attachment up to date. the newest version will always be the URL though.
  19. THANK YOU.... I love learning new tricks. This is now part of the new version and is updated in the Read Me File.
  20. You can now attach a subquery when using "WHERE IN" by clicking on the icon to the right of the value field
  21. Can you give an example of what you mean?
  22. Arrrg! I could have swore I tried that in the beginning. But I just tried it now and it worked oh well, I have updated the database... much easier to read the code now.
  23. The file has been updated. Please see above. Also is there any documentation for FileMaker specific quirks in the ExecuteSQL() command so I don't have to figure them out? :)
×
×
  • Create New...

Important Information

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