Jump to content

MMQuery convenience/helper functions


This topic is 4359 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello all,

I'm interested to know if anyone who's used MMQuery uses the convenience/helper functions we've added to the plug-in or if you just use the ExecuteSQL(Ex) functions. For instance, I personally use the AddRecord function a lot. Also, are there other convenience functions that you would find useful if added?

Thanks,

Jake

Link to comment
Share on other sites

Hello Jake,

I think the helper functions are great for people new to SQL and they're also convenient even for those with more SQL experience. I recently presented on internal SQL at PauseOnError and promoted your plug-in as my SQL plug-in of choice. Our SmartPill plug-in has SQL but we don't yet support the new API which is very nice.

In regards to other functions that would be useful, it would be nice to have an easy way to apply a query to the current found set (as FileMaker developers, were so used to context, it gets a bit tricky when we have to think in SQL queries). Kevin Frank has a method for doing this and I'm guessing it uses something like the List function combined with an IN clause. Just an idea, but perhaps you could develop functions that apply updates or deletes to all records in the current found set.

Regards,

Micah

Link to comment
Share on other sites

This topic is 4359 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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