The Shadow Posted March 23, 2007 Share Posted March 23, 2007 Are there any plugins around that provide an interface to the "experimental" ExecuteSQL() FM plug-in API call? I'd like to use it, but would rather find a plug-in for it that's already built and tested. Link to comment Share on other sites More sharing options...
Peter Wagemans Posted April 17, 2007 Share Posted April 17, 2007 We're finalising the myFMbutler DoSQL plug-in next week. I'm already using it for a few months now, and it's really VERY useful. There's a few things you have to keep in mind when using it - no spaces in field names allowed, and the error reporting from the API is limited to "parse error". The DoSQL plug-in will not be freeware, and I'm not responsible for the pricing, but I guess the price tag will be in the "symbolic" range, to cover the effort we made creating the examples and the doing the testing. Link to comment Share on other sites More sharing options...
Genx Posted April 17, 2007 Share Posted April 17, 2007 Why not just use the FileMaker Execute SQL script step? Link to comment Share on other sites More sharing options...
The Shadow Posted April 18, 2007 Author Share Posted April 18, 2007 (edited) I was just looking for someone who had built the plug-in wrapper around the FileMaker plug-in call. I can make a mac-only version using XCode, but would like to have a X-platform one. Edited April 18, 2007 by Guest Link to comment Share on other sites More sharing options...
Peter Wagemans Posted April 28, 2007 Share Posted April 28, 2007 Hi Genx, You don't understand what the plug-in does. It makes you talk with SQL commands to FileMaker itself. There is no need for any driver installation. You can use SQL statements in scripts, but it also possible to make calculation fields with the SQL plug-in, much like to DoScript plug-in. This makes it possible to make and delete FileMaker records, and obtain information from tables that are even unrelated in the FileMaker Relation Graph. All becomes clear in the example files bundled with the plug-in. We have finalised these, but there's still some more things to be done. myFMbutler is planning to release it in the second week of May. Link to comment Share on other sites More sharing options...
Genx Posted April 28, 2007 Share Posted April 28, 2007 ... mmm, yeah sounds interesting I guess... Link to comment Share on other sites More sharing options...
Søren Dyhr Posted April 28, 2007 Share Posted April 28, 2007 Peter ...would it be x-platform or Mac first and then later?? --sd Link to comment Share on other sites More sharing options...
murtje Posted May 1, 2007 Share Posted May 1, 2007 The plug-in will be released for Mac and Windows. Koen Link to comment Share on other sites More sharing options...
Adam Dempsey Posted May 1, 2007 Share Posted May 1, 2007 Can anyone explain to me about the syntax of the ExecuteSQL function? I am interested in trying to get it working. Thanks Link to comment Share on other sites More sharing options...
Genx Posted May 1, 2007 Share Posted May 1, 2007 Hi Dempsey, in relation to what exactly? Construction of FileMaker tables or just in general? In general: standard sql statements, in relation to FileMaker table construction: www.filemaker.com, search ODBC. Link to comment Share on other sites More sharing options...
Adam Dempsey Posted May 1, 2007 Share Posted May 1, 2007 Oh ok, if its just standard SQL i'll have a play later, cheers Might try including something in MooPlug if I get it working Link to comment Share on other sites More sharing options...
rogermax Posted May 3, 2007 Share Posted May 3, 2007 Are you still on track for 2nd week of May for the doSQL plugin? Link to comment Share on other sites More sharing options...
Søren Dyhr Posted May 4, 2007 Share Posted May 4, 2007 The Monkeybread thingy came some days ago with features in the vicinity of this SQL'ing: http://www.monkeybreadsoftware.de/filemaker/index.shtml --sd Link to comment Share on other sites More sharing options...
Peter Wagemans Posted May 15, 2007 Share Posted May 15, 2007 Indeed. Todd released a few days ago. I just read that my collegue got all materials ready. We have released ours today. Check it out. Following the examples included is the best way to go. The demo works for an hour each time you launch FileMaker. Link to comment Share on other sites More sharing options...
murtje Posted May 15, 2007 Share Posted May 15, 2007 Peter, it's maybe a good idea to post the link : You can download a demo version from: http://www.myfmbutler.com Koen Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6212 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 accountSign in
Already have an account? Sign in here.
Sign In Now