SQL features of FMP9

Post removed (X-No-Archive: yes)

Re: SQL features of FMP9

Post removed (X-No-Archive: yes)

Re: SQL features of FMP9

On Nov 29, 11:05 am, Martin Trautmann wrote:
> On 29 Nov 2007 15:59:29 GMT, Martin Trautmann wrote:
>
>
>
>
>
> > Hi all,
>
> > I just received a newsletter for FMP9 and a new (?) SQL resource kit.
>
> > There's no obvious docu which features of SQL actually are supported.
>
> > How about
>
> > create table
> > insert into
> > update
> > delete from
>
> > I guess that SELECT ist supported pretty well - but I do not want to
> > query only.
>
> I've found the ODBC guide by now - just to make this clear: I wanted to
> get this done not via ODBC, but directly from a .sql file

I don't know how much interest you have in using an external sql
datastore (MySQL being free is nice, SQL server, Oracle, DB2--all the
heavy hitters are options as they are all ANSI SQL compliant (with
additional varied features for each)).

The main point of FM's announcment's, and the big push of v9 has been
that now FM can readily be used for reporting and interfacing with
more enterprise level database applications; i.e. the data no longer
has to be stored in FileMaker proprietary format/tables.

There has been, for a while, the ExecuteSQL script step, but I don't
think that is what you are referring to here?

In terms of the SQL supported, that is dependent on what flavor of SQL
is supported by the backend database you choose to use. You can have
any .sql file operate off of the backend datastore (obviously insert,
update, group by, having, aggregates, etc....) and use native FM
querying and reporting tools off of those underlying tables and/or
interim views created on the underlying _external_ tables to present,
summarize, and report on that.

best,
sg

Re: SQL features of FMP9

Post removed (X-No-Archive: yes)