OT: Filemaker 8

Tyler Style tyler.style at gmail.com
Mon Feb 6 21:56:17 PST 2006


Laura Brody wrote:
>> I can't really say what the project scope would be like, I must admit.
>> However, write access is already there in fpCGI, which makes me wonder 
>> about why it isn't in fpODBC.
> 
>     It is in there. End of discussion. Consider yourself corrected.

Nope.  It's not.  I can't connect to a filePro datastore using a third 
party app via ODBC.  End of discussion.  Consider yourself corrected.

>     Here is the problem. filePro predates just about everything
> else. It was around long before most "standards" existed. People
> bitch that filePro on Windows uses Esc to save a record and F10
> for Help, while "real Windows" programs use F10 to save a record
> and F1 for Help. The filePro programmers chose those keys long
> before Windows ever existed! I don't know when ODBC came along,
> but filePro was around long before it was a feature that a
> commercial database was expected to have. To add a feature
> retroactively is many times harder than to build it in from the
> begining. Hence the "challenges" filePro is facing 25 years later.

I can certainly believe that.  fP has many nonstandard useages, 
certainly linked to it's age.  I'm constantly agog at the fact that I 
can't have recursive functions due to the gosub call limit.  But ODBC 
has been around a long time now too: "Microsoft created ODBC by adapting 
the SQL Access Group CLI. It released ODBC 1.0 in September, 1992"  So, 
almost fourteen years.  Not exactly a new technology, either.  Oracle 
was founded in 1979, and it has managed to tack on ODBC.  PostGres was 
at demo stage in 1986, and they have ODBC too - and it's not even a 
commercial product.  So I don't think it's rather too much to ask, given 
that it's an IT industry standard as well (not just 'expected to have').

>     I don't have a problem with questions or opinions - even
> uninformed opionions. I *do* have a problem with nasty comments
> without any basis.

Until today, I wasn't even aware that Ken was responsible for filePro 
development.  I made a comment based on what I knew, which obviously 
wasn't much, and I said so at the time.  You took it is some kind of 
personal attack.  Which it obviously wasn't, as I couldn't even name a 
core app developer.  All I did was voice my opinion that it was either 
lazy programmers or bad marketing strategy that was behind the lack of 
ODBC server functionality, given that filePro has had plenty of time to 
develop it and that it's a widespread standard used to communicate with 
DB servers (which is hardly an opinion without basis, just a poorly 
informed basis).  You countered that it was more of a problem to do with 
inherent programming issues to the core applications, and I agreed that 
you probably would know better than I would as fP source code and APIs 
are closed source and I've never had any access to fpTech.  Negative is 
not the same as nasty.  Nasty implies that I had malicious intent behind 
my comments.  I don't.  Why would I?

>     Other develpers have solved these problems. What kind of
> gyrations did you have to do?

I've solved them too.  That doesn't mean it's a good solution, or a 
quick one.  They generally involve writing shell scripts and doing pain 
in the butt exports and imports of text files between applications that 
have to be manually initiated or scheduled using a third party app or OS 
feature.  My problem is that these solutions are poor workarounds at 
best that could be easily solved with a simple ODBC connection to a 
filePro datastore, if such were available.  Almost every application out 
there uses ODBC to communicate with datastores, and it's very fast to 
implement without having to devise a seperate workaround strategy unique 
to every situation where you have to work with a 3rd party app wanting 
to use filePro stored data.

>> If it's wrong, people will argue with or correct me, and we 
>> allbenefit.  If it's true, then I have confirmation of its 
>> validityfrom others and we still all benefit.
> 
>     Just keep the slander and flame-bait to a minimum, ok?

I'll try.  I admit I'm not particularly a people person.  But I don't 
consider what I said either slander or flame-bait, just negative.  And 
what crosses the line is in the eye of the beholder, no?  Can be a 
problem, especially if one has a high sensitivity to talking about some 
of the lacks of filePro.  :)



More information about the Filepro-list mailing list