on 17/2/02 10:16 PM, subscriber at [EMAIL PROTECTED] wrote: > Only done this by exporting the FileMaker data to a tab delimited text file > and then using Rev to access the file. I guess you could import the text > file directly into your Rev stack. > > If the data is 'live' ie you want to query a changing Filemaker database > then I guess you could use the ODBC facilitiy (big thanks for this guys !) > in Rev to query the file.
I can confirm that the new revdb functions work in FileMaker (and if you need to do this more than once, a lot better than the manual export, not least because FileMaker annoyingly doesn't put field names in text exports). I had some trouble getting this to work at first, and in fact upgraded from FMP 5 to FMP 5.5 before I did - but I think in the end the main problem may have been that using the database manager to test the connection, and editing its sample query "select * from xxx;" always gave an error. It turns out that FMP can't handle the semi-colon immediately after the table name - if you put a space before the semi-colon, you'll go farther. (It might be an idea to adjust the sample query in the next release of the DB Manager.) Ben Rubinstein | Email: [EMAIL PROTECTED] Cognitive Applications Ltd | Phone: +44 (0)1273-821600 http://www.cogapp.com | Fax : +44 (0)1273-728866 _______________________________________________ improve-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/improve-revolution
