Re: Filemaker through ODBC
Bruce- Wednesday, October 3, 2007, 8:57:43 PM, you wrote: Variables were introduced in several different ways beginning with FileMaker 7 over 2 years ago. Can you display a variable on a layout? I seem to remember trying this and not being able to do it without creating a new calculated field... You cannot directly display a variable on a layout. Howver, you can use set field to set for example a global field to hold what you want. Also - layouts are dead. The web viewer is where it's at now and a web viewer can display anything including variables. You can have very dynamic layouts now. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Bruce- Wednesday, October 3, 2007, 8:57:43 PM, you wrote: Variables were introduced in several different ways beginning with FileMaker 7 over 2 years ago. Can you display a variable on a layout? I seem to remember trying this and not being able to do it without creating a new calculated field... -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Mark Wieder wrote: Bruce- Wednesday, October 3, 2007, 8:57:43 PM, you wrote: Variables were introduced in several different ways beginning with FileMaker 7 over 2 years ago. Can you display a variable on a layout? I seem to remember trying this and not being able to do it without creating a new calculated field... Requiring a field and an instruction to put a variable's value into it for display? Sounds like Rev to me. :) -- Richard Gaskin Managing Editor, revJournal ___ Rev tips, tutorials and more: http://www.revJournal.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: OpenBase - WAS: Re: Filemaker through ODBC
True, I should have clarified. FMP pushes it through your OS mail client, the mail.it plugin (among others) will email from within FMP (the mail.it plugin is excellent btw). Cheers, Luis. On 4 Oct 2007, at 05:03, Bruce Robertson wrote: Hiya, Anyone tried OpenBase (http://www.openbase.com/) as an alternative? I'll admit I haven't used it much, but found performance much better that FMP. I have seen a very impressive POS made with it, can't recall the name. Nice thing I noticed was that some functions are available as standard, whereas they're plugins in FMP (like integrated email for instance, although basic). Cheers, Luis. Not quite true. FileMaker has built in scriptable email generation that sends message through your mail client application. For a broader range of features such as multiple attachments you do need a plugin. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Hiya, FMP can import and output XML and apply an XSLT, if you're ok with not interfacing 'directly'. Cheers, Luis. On 3 Oct 2007, at 03:06, Mark Wieder wrote: Richard- Monday, October 1, 2007, 3:20:06 PM, you wrote: FileMaker's gotten pretty good in the last few releases. Why does it need a front-end? FileMaker by itself isn't programmable, although the latest version has a poorly-publicized php interface. -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Mark Schonewille [EMAIL PROTECTED] writes: I might start a project that should connect a Revolution front-end to a FM Pro database. One of the candidates to do this is ODBC. Reading the archives, I can't help thinking that the combination of ODBC and FM Pro may not be the best option. Does anyone have good experiences with ODBC and FM Pro? How easy or difficult is it to accomplish this? Hi Mark, We have several installations that routinely extract data from FMP via ODBC. It works fine, with a few minor limitations (which may by now have been dealt with anyway, these were set up a few years ago). The app itself routinely extracts data from various different databases, so the good thing about FMP via ODBC, as far as I'm concerned, is that configuring the app in these cases to extract from FMP was reasonably trivial. It is necessary to throw a dialog on screen to tell the user to make sure that Filemaker is open and has these databases open. However, one caveat: for the last 18 months, we've been having horrendous problems with one client using this facility. Their database solution, built for them in FMP by a third party developer, is the most insanely architected I've seen in a long while. Apart from a shudder of disgust, I didn't think it would be a problem; but in fact, especially as the client has added considerably more data, we've found this impacts on getting the data out over ODBC. In some cases it times out; even worse, in some cases it doesn't, but doesn't return all the data. I mostly blame the madmen who so badly designed the database solution; but the fact is that it 'works' viewed through FileMaker itself, but fails in various ways over ODBC. So just be aware, that while I don't think you should have a problem, if you were to try to connect to an exceptionally badly designed database (eg one in which extracting simple items of data required FileMaker to undertake chains of calculations) you might run into difficulties. - Ben ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
OpenBase - WAS: Re: Filemaker through ODBC
Hiya, Anyone tried OpenBase (http://www.openbase.com/) as an alternative? I'll admit I haven't used it much, but found performance much better that FMP. I have seen a very impressive POS made with it, can't recall the name. Nice thing I noticed was that some functions are available as standard, whereas they're plugins in FMP (like integrated email for instance, although basic). Cheers, Luis. On 3 Oct 2007, at 11:01, Ben Rubinstein wrote: Mark Schonewille [EMAIL PROTECTED] writes: I might start a project that should connect a Revolution front-end to a FM Pro database. One of the candidates to do this is ODBC. Reading the archives, I can't help thinking that the combination of ODBC and FM Pro may not be the best option. Does anyone have good experiences with ODBC and FM Pro? How easy or difficult is it to accomplish this? Hi Mark, We have several installations that routinely extract data from FMP via ODBC. It works fine, with a few minor limitations (which may by now have been dealt with anyway, these were set up a few years ago). The app itself routinely extracts data from various different databases, so the good thing about FMP via ODBC, as far as I'm concerned, is that configuring the app in these cases to extract from FMP was reasonably trivial. It is necessary to throw a dialog on screen to tell the user to make sure that Filemaker is open and has these databases open. However, one caveat: for the last 18 months, we've been having horrendous problems with one client using this facility. Their database solution, built for them in FMP by a third party developer, is the most insanely architected I've seen in a long while. Apart from a shudder of disgust, I didn't think it would be a problem; but in fact, especially as the client has added considerably more data, we've found this impacts on getting the data out over ODBC. In some cases it times out; even worse, in some cases it doesn't, but doesn't return all the data. I mostly blame the madmen who so badly designed the database solution; but the fact is that it 'works' viewed through FileMaker itself, but fails in various ways over ODBC. So just be aware, that while I don't think you should have a problem, if you were to try to connect to an exceptionally badly designed database (eg one in which extracting simple items of data required FileMaker to undertake chains of calculations) you might run into difficulties. - Ben ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Richard- Don't get me wrong about this - I'm not dismissing FMP out of hand by any means. We run our accounting system on FileMaker using a system I first cobbled together some ten years ago. But the lack of variables hurts, as does the fact that programming in FileMaker is limited to stringing together macro statements. I should retract my statement about the non-programmability, though, since it does satisfy my first-pass criterion for the definition, that of conditional branching. -- Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: OpenBase - WAS: Re: Filemaker through ODBC
Hiya, Anyone tried OpenBase (http://www.openbase.com/) as an alternative? I'll admit I haven't used it much, but found performance much better that FMP. I have seen a very impressive POS made with it, can't recall the name. Nice thing I noticed was that some functions are available as standard, whereas they're plugins in FMP (like integrated email for instance, although basic). Cheers, Luis. Not quite true. FileMaker has built in scriptable email generation that sends message through your mail client application. For a broader range of features such as multiple attachments you do need a plugin. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Richard- Don't get me wrong about this - I'm not dismissing FMP out of hand by any means. We run our accounting system on FileMaker using a system I first cobbled together some ten years ago. But the lack of variables hurts, as does the fact that programming in FileMaker is limited to stringing together macro statements. I should retract my statement about the non-programmability, though, since it does satisfy my first-pass criterion for the definition, that of conditional branching. Variables were introduced in several different ways beginning with FileMaker 7 over 2 years ago. The let statement was introduced with 7.0. Let ( [ myVariableName = FirstName + 78; myVariableName2 = 32]; MyVariableName myVariableName2 ) Script parameters were introduced with 7.0 Local variables ($yourVariableName) and global variables ($$yourVariableName) were introduced with 8.0 about 1.5 years ago. Besides providing variable for scripts and calculations they provide for scripted control of import, export, PDF and Excel document generation. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Richard- Monday, October 1, 2007, 3:20:06 PM, you wrote: FileMaker's gotten pretty good in the last few releases. Why does it need a front-end? FileMaker by itself isn't programmable, although the latest version has a poorly-publicized php interface. -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Mark Wieder wrote: Richard- Monday, October 1, 2007, 3:20:06 PM, you wrote: FileMaker's gotten pretty good in the last few releases. Why does it need a front-end? FileMaker by itself isn't programmable... Of course that depends on how one defines programmable. I guess it could mean a lot of different things to different people. Is it limited to things that require a lot of typing? What is the role of iconic systems? Is it really programming if you're not declaring types? Some people even question whether any 4GL, like Rev, is real programming. I'll leave all that to the philosophy majors. I'm just a developer so my job is much simpler: to deliver software solutions to users which provide a strong ROI for the owner. I've made some of those with FMP, and was glad I did. And so were my clients, their users, and their accountants. I'd have a sit-down with Todd Geist, one of the Rev community's most experienced FMP developers, before dismissing the product so out of hand. Like any 4GL, when what you need is what it does, it does it pretty well. -- Richard Gaskin Managing Editor, revJournal ___ Rev tips, tutorials and more: http://www.revJournal.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Mark Schonewille wrote: I might start a project that should connect a Revolution front-end to a FM Pro database. One of the candidates to do this is ODBC. Reading the archives, I can't help thinking that the combination of ODBC and FM Pro may not be the best option. Does anyone have good experiences with ODBC and FM Pro? How easy or difficult is it to accomplish this? FileMaker's gotten pretty good in the last few releases. Why does it need a front-end? -- Richard Gaskin Fourth World Media Corporation Developer of WebMerge: Publish any database on any Web site ___ [EMAIL PROTECTED] http://www.FourthWorld.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Dear Mark, I am a long time FileMaker Developer and have been using Revolution as a database front end for a short time. Because I am now using Rev as the interface for the database, a lot of the power of layouts, portals and scripts in Filemaker are no longer available. I have ended up using PostgreSQL as theback end and Rev as the front end (MySQL has costs associated with networked/enterprise usage). PostgreSQL avoids the increasingly expensive FileMaker licensing model and yet provides a very high performance database engine to drive a complex application. Rev is an excellent front end for this type of architecture as it supports PostgreSQL along with many other databases out of the box (come to think of it I have never seen a Rev box)... You have other choices of course and Ruslan may jump in to tell you about another option called Valentina at this point... Regards John DIVFONT face=Verdana size=2nbsp;/FONT/DIV p style=font-family: Arial;Technology Director brDebraneys br+61 (0) 2 9529 0007 Office br+61 (0) 4 3050 6980 Mobile brwww.debraneys.com/p -Original Message- From: Mark Schonewille [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 2, 2007 08:05 AM To: 'How to use Revolution' Subject: Filemaker through ODBC Hi, I might start a project that should connect a Revolution front-end to a FM Pro database. One of the candidates to do this is ODBC. Reading the archives, I can't help thinking that the combination of ODBC and FM Pro may not be the best option. Does anyone have good experiences with ODBC and FM Pro? How easy or difficult is it to accomplish this? Best regards, Mark -- Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Quickly extract data from your HyperCard stacks with DIFfersifier. http://differsifier.economy-x-talk.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Any experiences, Richard? Client is simply asking for a front-end. I don't know the exact details yet. Best regards, Mark Schonewille -- Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Quickly extract data from your HyperCard stacks with DIFfersifier. http://differsifier.economy-x-talk.com Op 2-okt-2007, om 0:20 heeft Richard Gaskin het volgende geschreven: FileMaker's gotten pretty good in the last few releases. Why does it need a front-end? -- Richard Gaskin Fourth World Media ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
John, Thanks, I'm aware of everything you wrote. I am looking for experiences with FM and ODBC. Best regards, Mark Schonewille -- Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Quickly extract data from your HyperCard stacks with DIFfersifier. http://differsifier.economy-x-talk.com Op 2-okt-2007, om 0:30 heeft John Tregea het volgende geschreven: Dear Mark, I am a long time FileMaker Developer and have been using Revolution as a database front end for a short time. Because I am now using Rev as the interface for the database, a lot of the power of layouts, portals and scripts in Filemaker are no longer available. I have ended up using PostgreSQL as theback end and Rev as the front end (MySQL has costs associated with networked/enterprise usage). PostgreSQL avoids the increasingly expensive FileMaker licensing model and yet provides a very high performance database engine to drive a complex application. Rev is an excellent front end for this type of architecture as it supports PostgreSQL along with many other databases out of the box (come to think of it I have never seen a Rev box)... You have other choices of course and Ruslan may jump in to tell you about another option called Valentina at this point... Regards John ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Np Mark, I do have the FmPro ODBC Rev connection working but haven't pounded on it to see what the performance is like. Regards JOhn DIVFONT face=Verdana size=2nbsp;/FONT/DIV p style=font-family: Arial;Technology Director brDebraneys br+61 (0) 2 9529 0007 Office br+61 (0) 4 3050 6980 Mobile brwww.debraneys.com/p -Original Message- From: Mark Schonewille [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 2, 2007 08:32 AM To: 'How to use Revolution' Subject: Re: Filemaker through ODBC John, Thanks, I'm aware of everything you wrote. I am looking for experiences with FM and ODBC. Best regards, Mark Schonewille -- Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Quickly extract data from your HyperCard stacks with DIFfersifier. http://differsifier.economy-x-talk.com Op 2-okt-2007, om 0:30 heeft John Tregea het volgende geschreven: Dear Mark, I am a long time FileMaker Developer and have been using Revolution as a database front end for a short time. Because I am now using Rev as the interface for the database, a lot of the power of layouts, portals and scripts in Filemaker are no longer available. I have ended up using PostgreSQL as theback end and Rev as the front end (MySQL has costs associated with networked/enterprise usage). PostgreSQL avoids the increasingly expensive FileMaker licensing model and yet provides a very high performance database engine to drive a complex application. Rev is an excellent front end for this type of architecture as it supports PostgreSQL along with many other databases out of the box (come to think of it I have never seen a Rev box)... You have other choices of course and Ruslan may jump in to tell you about another option called Valentina at this point... Regards John ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Hi John, Thanks for the reply. Was it an easy thing to do, or did you encounter many problems before you were able to establish the connection? Best regards, Mark Schonewille -- Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Quickly extract data from your HyperCard stacks with DIFfersifier. http://differsifier.economy-x-talk.com Op 2-okt-2007, om 0:40 heeft John Tregea het volgende geschreven: Np Mark, I do have the FmPro ODBC Rev connection working but haven't pounded on it to see what the performance is like. Regards JOhn ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Filemaker through ODBC
I am a long time FileMaker Developer and have been using Revolution as a database front end for a short time. Because I am now using Rev as the interface for the database, a lot of the power of layouts, portals and scripts in Filemaker are no longer available. I have ended up using PostgreSQL as theback end and Rev as the front end (MySQL has costs associated with networked/enterprise usage). PostgreSQL avoids the increasingly expensive FileMaker licensing model and yet provides a very high performance database engine to drive a complex application. Rev is an excellent front end for this type of architecture as it supports PostgreSQL along with many other databases out of the box (come to think of it I have never seen a Rev box)... You have other choices of course and Ruslan may jump in to tell you about another option called Valentina at this point... How predictable Ruslan has become - but I will beat him to it :-) Valentina for Revolution ADK 3.4 is available for building royalty free, single user database solutions with Valentina and Revolution. Valentina Developer Network (Revolution) lets you create and deploy local and client-server solutions using Valentina Embedded Server. VES is automatically initialized to support five simultanous connections - you can extend these or do a per deployment of VES Infinite. Lots of other included bits - additional connections, and Valentina Studio Admin for rapidly creating your databases, porting from other databases, searching and administering. ADK comes with 1 year of updates; VDN comes with 2 years of updates. Valentina supports Revolution on Mac OS X, Windows and Linux. Valentina is just bristling with features - it is well known for being extremely fast compared to other solutions, including MS SQL Server, MySQL and more. Both Paradigma and Runtime offer a bundle of Valentina for Revolution Professional and Revolution Studio for $499. Note please my bias below :-) Best regards, Lynn Fredricks President Paradigma Software http://www.paradigmasoft.com Valentina SQL Server: The Ultra-fast, Royalty Free Database Server ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Hi Mark, It was pretty straightforward, I defined the ODBC data source under Win XP and connected to it from the database query builder (Rev Enterprise 2.8.1) with no problem. I attached the query to a field table object and was able to read and update records without error. Usually I use the reOpenDatabase, revExecuteSQL etc, but for the sake of the experiment just went for the simple approach. Mind you I haven't tried this on a network yet, it was a local ODBC data source. I haven't explored how flexible the ODBC interface is but will have to get to that soon. The product I am building abstracts the presentation layer away from any particular brand of SQL (or ODBC) and will handle the mapping between multiple host database types. Regards John DIVFONT face=Verdana size=2nbsp;/FONT/DIV p style=font-family: Arial;Technology Director brDebraneys br+61 (0) 2 9529 0007 Office br+61 (0) 4 3050 6980 Mobile brwww.debraneys.com/p -Original Message- From: Mark Schonewille [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 2, 2007 08:42 AM To: 'How to use Revolution' Subject: Re: Filemaker through ODBC Hi John, Thanks for the reply. Was it an easy thing to do, or did you encounter many problems before you were able to establish the connection? Best regards, Mark Schonewille -- Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Quickly extract data from your HyperCard stacks with DIFfersifier. http://differsifier.economy-x-talk.com Op 2-okt-2007, om 0:40 heeft John Tregea het volgende geschreven: Np Mark, I do have the FmPro ODBC Rev connection working but haven't pounded on it to see what the performance is like. Regards JOhn ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Mark Schonewille wrote: Hi, I might start a project that should connect a Revolution front-end to a FM Pro database. One of the candidates to do this is ODBC. Reading the archives, I can't help thinking that the combination of ODBC and FM Pro may not be the best option. Does anyone have good experiences with ODBC and FM Pro? How easy or difficult is it to accomplish this? A few issues ago, Bill Marriott wrote an article in the RR newsletter about this exact thing. He hooked up a FM database to Rev without too much trouble. You might look through the old newsletters for it. Sorry I can't recall the date. -- Jacqueline Landman Gay | [EMAIL PROTECTED] HyperActive Software | http://www.hyperactivesw.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
Sounds good, John. Thanks for sharing your experience. This is good news after reading the somewhat disturbing information in the archives. Best regards, Mark Schonewille -- Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Quickly extract data from your HyperCard stacks with DIFfersifier. http://differsifier.economy-x-talk.com Op 2-okt-2007, om 0:56 heeft John Tregea het volgende geschreven: Hi Mark, It was pretty straightforward, I defined the ODBC data source under Win XP and connected to it from the database query builder (Rev Enterprise 2.8.1) with no problem. I attached the query to a field table object and was able to read and update records without error. Usually I use the reOpenDatabase, revExecuteSQL etc, but for the sake of the experiment just went for the simple approach. Mind you I haven't tried this on a network yet, it was a local ODBC data source. I haven't explored how flexible the ODBC interface is but will have to get to that soon. The product I am building abstracts the presentation layer away from any particular brand of SQL (or ODBC) and will handle the mapping between multiple host database types. Regards John ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Filemaker through ODBC
I've just found it, Jacque. Part III is about ODBC. Best regards, Mark Schonewille -- Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Quickly extract data from your HyperCard stacks with DIFfersifier. http://differsifier.economy-x-talk.com Op 2-okt-2007, om 1:16 heeft J. Landman Gay het volgende geschreven: A few issues ago, Bill Marriott wrote an article in the RR newsletter about this exact thing. He hooked up a FM database to Rev without too much trouble. You might look through the old newsletters for it. Sorry I can't recall the date. -- Jacqueline Landman Gay | [EMAIL PROTECTED] HyperActive Software | http://www.hyperactivesw.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
