ExecuteSQL plug-ins

[The Shadow]

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.

[Peter Wagemans]

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.

[Genx]

Why not just use the FileMaker Execute SQL script step?

[The Shadow]

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

[Peter Wagemans]

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.

[Genx]

... mmm, yeah sounds interesting I guess...

[Søren Dyhr]

Peter ...would it be x-platform or Mac first and then later??

--sd

[murtje]

The plug-in will be released for Mac and Windows.

Koen

[Adam Dempsey]

Can anyone explain to me about the syntax of the ExecuteSQL function? I am interested in trying to get it working.

Thanks

[Genx]

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.

[Adam Dempsey]

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

[rogermax]

Are you still on track for 2nd week of May for the doSQL plugin?

[Søren Dyhr]

The Monkeybread thingy came some days ago with features in the vicinity of this SQL'ing:

http://www.monkeybreadsoftware.de/filemaker/index.shtml

--sd

[Peter Wagemans]

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.

[murtje]

Peter, it's maybe a good idea to post the link :

You can download a demo version from: http://www.myfmbutler.com

Koen