SQL and filemaker files in filemaker Pro 6.0 
Author Message
 SQL and filemaker files in filemaker Pro 6.0
Hey, just got filemaker 6.0 installed, and was told by the sales rep I could
use SQL statements to manipulate my data within my filemaker files. This
would be a big step for filemaker, but I as of yet can't get it to do
anything at all. Anyone knowledgeable about this, or is filemaker's SQL
support just a ruse by the company to pretend its becomming a legit DB
solution?


Sun, 20 Mar 2005 21:41:08 GMT
 SQL and filemaker files in filemaker Pro 6.0

Hi Wally,

FileMaker Pro 6.0 does include ODBC drivers on Windows and MacOS 8.6-9.x,
and a JDBC api via the Web Companion.

It is SQL92 compliant, but with exceptions.  Due to the current file
structure, FP6 doesn't have facilities for add/drop table or column.
Basically, today you can interrogate and update data, but not change the
schema via SQL.

Further, if the load of transactions you intend to make against FP6 data is
high, I'd recommend JDBC or XML over the ODBC driver for performance
reasons.  The existing ODBC driver is predicated on solutions integration at
the desktop with MSOffice apps etc., and not so much for transaction heavy
web sites or rdbms integration.
  Note that pushing and pulling data (using ODBC) outward from within a FP6
solution is a much more high performance option -- using Import via ODBC or
the Execute SQL script command.  I've got lots of customers integrating FMP
with SQLServer, Oracle et al for solutions deployment.

I wouldn't call the SQL support a ruse.  When consulting, I worked on
projects ranging from $10k to >$1M in which the SQL support never got in the
way of success.

Good luck.  HTH,

Andrew
--
Andrew LeCates
North American SE Manager



Quote:
> Hey, just got filemaker 6.0 installed, and was told by the sales rep I could
> use SQL statements to manipulate my data within my filemaker files. This
> would be a big step for filemaker, but I as of yet can't get it to do
> anything at all. Anyone knowledgeable about this, or is filemaker's SQL
> support just a ruse by the company to pretend its becomming a legit DB
> solution?



Sun, 20 Mar 2005 22:31:09 GMT
 SQL and filemaker files in filemaker Pro 6.0
I think you should call your sales rep up. SQL statements can be used to
manipulate data but not within FileMaker. It can be used to manipulate data
in and out of SQL databases but not internally.

--
Michael Stout

http://www.fmpdev.com/

Quote:
> Hey, just got filemaker 6.0 installed, and was told by the sales rep I could
> use SQL statements to manipulate my data within my filemaker files. This
> would be a big step for filemaker, but I as of yet can't get it to do
> anything at all. Anyone knowledgeable about this, or is filemaker's SQL
> support just a ruse by the company to pretend its becomming a legit DB
> solution?



Sun, 20 Mar 2005 22:53:56 GMT
 SQL and filemaker files in filemaker Pro 6.0
Hey, thanks so much!

What I'm looking for, specifically, is somewhere I can use Filemaker to
execute a query on my Filemaker DB, maybe something like...

SELECT Employes, Employe_Workorder_Ids FROM Main, work_orders WHERE
Employes.Employe_id = work_orders.Employe_id

example is totally fictional, but basicly I want to be able to select,
insert, and maybe update from my filemaker files. Where would I go to do
this in FM 6. Execute SQL script step wants an ODBC connection, and when I
try to connect to my FM DB it says that FM doesnt' support that connection.

I basicly want to be able to maniuplate my data with SQL, can I do this, and
where do I do this from within FM? Is it possible?


Quote:
> Hi Wally,

> FileMaker Pro 6.0 does include ODBC drivers on Windows and MacOS 8.6-9.x,
> and a JDBC api via the Web Companion.

> It is SQL92 compliant, but with exceptions.  Due to the current file
> structure, FP6 doesn't have facilities for add/drop table or column.
> Basically, today you can interrogate and update data, but not change the
> schema via SQL.

> Further, if the load of transactions you intend to make against FP6 data
is
> high, I'd recommend JDBC or XML over the ODBC driver for performance
> reasons.  The existing ODBC driver is predicated on solutions integration
at
> the desktop with MSOffice apps etc., and not so much for transaction heavy
> web sites or rdbms integration.
>   Note that pushing and pulling data (using ODBC) outward from within a
FP6
> solution is a much more high performance option -- using Import via ODBC
or
> the Execute SQL script command.  I've got lots of customers integrating
FMP
> with SQLServer, Oracle et al for solutions deployment.

> I wouldn't call the SQL support a ruse.  When consulting, I worked on
> projects ranging from $10k to >$1M in which the SQL support never got in
the
> way of success.

> Good luck.  HTH,

> Andrew
> --
> Andrew LeCates
> North American SE Manager


at

> > Hey, just got filemaker 6.0 installed, and was told by the sales rep I
could
> > use SQL statements to manipulate my data within my filemaker files. This
> > would be a big step for filemaker, but I as of yet can't get it to do
> > anything at all. Anyone knowledgeable about this, or is filemaker's SQL
> > support just a ruse by the company to pretend its becomming a legit DB
> > solution?



Sun, 20 Mar 2005 23:07:31 GMT
 SQL and filemaker files in filemaker Pro 6.0
What SQL source are you trying to connect to?

--
Michael Stout

http://www.fmpdev.com/

Quote:
> Hey, thanks so much!

> What I'm looking for, specifically, is somewhere I can use Filemaker to
> execute a query on my Filemaker DB, maybe something like...

> SELECT Employes, Employe_Workorder_Ids FROM Main, work_orders WHERE
> Employes.Employe_id = work_orders.Employe_id

> example is totally fictional, but basicly I want to be able to select,
> insert, and maybe update from my filemaker files. Where would I go to do
> this in FM 6. Execute SQL script step wants an ODBC connection, and when I
> try to connect to my FM DB it says that FM doesnt' support that connection.

> I basicly want to be able to maniuplate my data with SQL, can I do this, and
> where do I do this from within FM? Is it possible?



>> Hi Wally,

>> FileMaker Pro 6.0 does include ODBC drivers on Windows and MacOS 8.6-9.x,
>> and a JDBC api via the Web Companion.

>> It is SQL92 compliant, but with exceptions.  Due to the current file
>> structure, FP6 doesn't have facilities for add/drop table or column.
>> Basically, today you can interrogate and update data, but not change the
>> schema via SQL.

>> Further, if the load of transactions you intend to make against FP6 data
> is
>> high, I'd recommend JDBC or XML over the ODBC driver for performance
>> reasons.  The existing ODBC driver is predicated on solutions integration
> at
>> the desktop with MSOffice apps etc., and not so much for transaction heavy
>> web sites or rdbms integration.
>>   Note that pushing and pulling data (using ODBC) outward from within a
> FP6
>> solution is a much more high performance option -- using Import via ODBC
> or
>> the Execute SQL script command.  I've got lots of customers integrating
> FMP
>> with SQLServer, Oracle et al for solutions deployment.

>> I wouldn't call the SQL support a ruse.  When consulting, I worked on
>> projects ranging from $10k to >$1M in which the SQL support never got in
> the
>> way of success.

>> Good luck.  HTH,

>> Andrew
>> --
>> Andrew LeCates
>> North American SE Manager


> at

>>> Hey, just got filemaker 6.0 installed, and was told by the sales rep I
> could
>>> use SQL statements to manipulate my data within my filemaker files. This
>>> would be a big step for filemaker, but I as of yet can't get it to do
>>> anything at all. Anyone knowledgeable about this, or is filemaker's SQL
>>> support just a ruse by the company to pretend its becomming a legit DB
>>> solution?



Sun, 20 Mar 2005 23:16:34 GMT
 SQL and filemaker files in filemaker Pro 6.0
I'm trying to use SQL to manipulate the data in my Filemaker files.


Quote:
> What SQL source are you trying to connect to?

> --
> Michael Stout

> http://www.fmpdev.com/

> > Hey, thanks so much!

> > What I'm looking for, specifically, is somewhere I can use Filemaker to
> > execute a query on my Filemaker DB, maybe something like...

> > SELECT Employes, Employe_Workorder_Ids FROM Main, work_orders WHERE
> > Employes.Employe_id = work_orders.Employe_id

> > example is totally fictional, but basicly I want to be able to select,
> > insert, and maybe update from my filemaker files. Where would I go to do
> > this in FM 6. Execute SQL script step wants an ODBC connection, and when
I
> > try to connect to my FM DB it says that FM doesnt' support that
connection.

> > I basicly want to be able to maniuplate my data with SQL, can I do this,
and
> > where do I do this from within FM? Is it possible?



> >> Hi Wally,

> >> FileMaker Pro 6.0 does include ODBC drivers on Windows and MacOS
8.6-9.x,
> >> and a JDBC api via the Web Companion.

> >> It is SQL92 compliant, but with exceptions.  Due to the current file
> >> structure, FP6 doesn't have facilities for add/drop table or column.
> >> Basically, today you can interrogate and update data, but not change
the
> >> schema via SQL.

> >> Further, if the load of transactions you intend to make against FP6
data
> > is
> >> high, I'd recommend JDBC or XML over the ODBC driver for performance
> >> reasons.  The existing ODBC driver is predicated on solutions
integration
> > at
> >> the desktop with MSOffice apps etc., and not so much for transaction
heavy
> >> web sites or rdbms integration.
> >>   Note that pushing and pulling data (using ODBC) outward from within a
> > FP6
> >> solution is a much more high performance option -- using Import via
ODBC
> > or
> >> the Execute SQL script command.  I've got lots of customers integrating
> > FMP
> >> with SQLServer, Oracle et al for solutions deployment.

> >> I wouldn't call the SQL support a ruse.  When consulting, I worked on
> >> projects ranging from $10k to >$1M in which the SQL support never got
in
> > the
> >> way of success.

> >> Good luck.  HTH,

> >> Andrew
> >> --
> >> Andrew LeCates
> >> North American SE Manager


Osmond
> > at

> >>> Hey, just got filemaker 6.0 installed, and was told by the sales rep I
> > could
> >>> use SQL statements to manipulate my data within my filemaker files.
This
> >>> would be a big step for filemaker, but I as of yet can't get it to do
> >>> anything at all. Anyone knowledgeable about this, or is filemaker's
SQL
> >>> support just a ruse by the company to pretend its becomming a legit DB
> >>> solution?



Mon, 21 Mar 2005 20:46:53 GMT
 SQL and filemaker files in filemaker Pro 6.0
So what you are saying is the SQL support is a glorified import/export
feature with the ability to modify data outside of FileMaker, but not
inside?


Quote:
> I think you should call your sales rep up. SQL statements can be used to
> manipulate data but not within FileMaker. It can be used to manipulate
data
> in and out of SQL databases but not internally.

> --
> Michael Stout

> http://www.fmpdev.com/

> > Hey, just got filemaker 6.0 installed, and was told by the sales rep I
could
> > use SQL statements to manipulate my data within my filemaker files. This
> > would be a big step for filemaker, but I as of yet can't get it to do
> > anything at all. Anyone knowledgeable about this, or is filemaker's SQL
> > support just a ruse by the company to pretend its becomming a legit DB
> > solution?



Mon, 21 Mar 2005 20:55:47 GMT
 SQL and filemaker files in filemaker Pro 6.0
Hi Wally,

FileMaker is _not_ a traditional rdbms with enforced separation between the
data layer and the application/business logic layers.  It doesn't have an
administrable transaction model.  But because of this, it gains most of it's
unique benefits for ease of use and rapid app development.

Inside of a FileMaker application solution or even between discreet
solutions, SQL would be redundant to the built in search/sort/edit etc.
capabilities that are at hand, that are much simpler, and that for most
users more powerful.

SQL as implemented in FileMaker is there to allow FMP to interact with
database software that requires it (Import/Execute SQL), or to allow
database software that requires it to interact with FileMaker (the ODBC
driver).  These are the urgent areas that have required SQL support for our
customers.

It's not so much about glorifying import/export.  It's about providing the
right mix of tools for solutions development in its space.  As I said
before, I've developed for projects large and small, and limitations of SQL
never precluded success.

As for your sales rep, I would assume that there was an honest
miscommunication.  We encounter customer integration projects daily and your
rep probably assumed that a question about whether "SQL statements can be
used to manipulate data" referred to another source for the SQL query.  If
you have a moment, email the rep's name and I'll try to clarify with

filemaker.com)

Thanks and Good luck,

Andrew
--
Andrew LeCates
North American SE Manager
FileMaker Inc.



Quote:
> So what you are saying is the SQL support is a glorified import/export
> feature with the ability to modify data outside of FileMaker, but not
> inside?



>> I think you should call your sales rep up. SQL statements can be used to
>> manipulate data but not within FileMaker. It can be used to manipulate
> data
>> in and out of SQL databases but not internally.

>> --
>> Michael Stout

>> http://www.fmpdev.com/

>>> Hey, just got filemaker 6.0 installed, and was told by the sales rep I
> could
>>> use SQL statements to manipulate my data within my filemaker files. This
>>> would be a big step for filemaker, but I as of yet can't get it to do
>>> anything at all. Anyone knowledgeable about this, or is filemaker's SQL
>>> support just a ruse by the company to pretend its becomming a legit DB
>>> solution?



Tue, 22 Mar 2005 01:18:00 GMT
 SQL and filemaker files in filemaker Pro 6.0
Hi Andrew,

Thanks again for a well thought out reply. I'm mostly dissapointed because
there was that miscommunication. I'm well aware of FMP's abilities for ease
of use and RAD qualities. I was under the impression that FMP was going to
offer a more sophisticated SQL API with FMP 6. Just having the fuctionality
to perform a select on my data would make it so much easier when dealing
with multiple file solutions. Sometimes a days work could be reduced to five
or ten minutes. But whichever, thanks for the informative reply that
answered my question perfectly. Much appriciated.

Wally.


Quote:
> Hi Wally,

> FileMaker is _not_ a traditional rdbms with enforced separation between
the
> data layer and the application/business logic layers.  It doesn't have an
> administrable transaction model.  But because of this, it gains most of
it's
> unique benefits for ease of use and rapid app development.

> Inside of a FileMaker application solution or even between discreet
> solutions, SQL would be redundant to the built in search/sort/edit etc.
> capabilities that are at hand, that are much simpler, and that for most
> users more powerful.

> SQL as implemented in FileMaker is there to allow FMP to interact with
> database software that requires it (Import/Execute SQL), or to allow
> database software that requires it to interact with FileMaker (the ODBC
> driver).  These are the urgent areas that have required SQL support for
our
> customers.

> It's not so much about glorifying import/export.  It's about providing the
> right mix of tools for solutions development in its space.  As I said
> before, I've developed for projects large and small, and limitations of
SQL
> never precluded success.

> As for your sales rep, I would assume that there was an honest
> miscommunication.  We encounter customer integration projects daily and
your
> rep probably assumed that a question about whether "SQL statements can be
> used to manipulate data" referred to another source for the SQL query.  If
> you have a moment, email the rep's name and I'll try to clarify with

> filemaker.com)

> Thanks and Good luck,

> Andrew
> --
> Andrew LeCates
> North American SE Manager
> FileMaker Inc.


at

> > So what you are saying is the SQL support is a glorified import/export
> > feature with the ability to modify data outside of FileMaker, but not
> > inside?



> >> I think you should call your sales rep up. SQL statements can be used
to
> >> manipulate data but not within FileMaker. It can be used to manipulate
> > data
> >> in and out of SQL databases but not internally.

> >> --
> >> Michael Stout

> >> http://www.fmpdev.com/

> >>> Hey, just got filemaker 6.0 installed, and was told by the sales rep I
> > could
> >>> use SQL statements to manipulate my data within my filemaker files.
This
> >>> would be a big step for filemaker, but I as of yet can't get it to do
> >>> anything at all. Anyone knowledgeable about this, or is filemaker's
SQL
> >>> support just a ruse by the company to pretend its becomming a legit DB
> >>> solution?



Wed, 23 Mar 2005 01:27:54 GMT
 
 [ 9 post ] 

 Relevant Pages 

1. PC Filemaker Pro v3 file to Mac Filemaker Pro 2.1

2. PC Filemaker Pro v3 file to Mac Filemaker Pro 2.1

3. Filemaker 5.5 Files in Filemaker 6.0 Developer???

4. Filemaker Pro Server V3 and Filemaker Pro V5.5

5. Filemaker Pro Unlimited or Filemaker Pro Server?

6. filemaker server and filemaker pro unlimited

7. FileMaker Demonstrates FileMaker Pro 5 on Mac OS X

8. Claris Filemaker II -> Claris Filemaker Pro 3.0

9. Need help getting this AppleScript working in FileMaker Pro 6.0

10. FileMaker Pro 6.0 (Mac) Conversion Error

11. Some inquiries regarding Filemaker Pro 6.0 (trial)

12. Importing FileMaker Pro file into SQL 7 using DTS


 
Powered by phpBB® Forum Software