Dick Applebaum wrote: > Alex, If I recall correctly, Both 4D & Claris allow you to export files in > CSV or other formats. > > These can be read directly into Perl and manipulated as lists. > > You can do a little more programming and convert them into hashes, which > then can be used in the Perl DBM modules to tie the hash to a database (a > hash saved to disk). > > This works OK for small db's but is not recommended for large ones. > > If you find an SQL db accessable to MacPerl, it is a fairly simple task to > write a general program to populate an SQL db from a CSV (or the like). I > have done this with Cold Fusion MS SQL coming from CSV files such as Excel > spreadsheets, etc... no big deal. > > It should be only slightly more involved to export a multi-table relational > db (such as 4D) to CSV, then populate multiple tables in an > SQL-equivalent. You will probably need to export/import/populate each > table separately, and be responsible for resolving the key fields which > interrelate the tables. > > I haven't done much with the later versions of 4D, but years ago, when SQL > was gaining popularity, the ACIUS developers were programming 4D to conform > to SQL standards... so I'd be surprised if it did not qualify as an SQL db > that runs on the Mac. > > Also there are at least 2 offerings (1 from ACIUS) that allow 4D to be used > as a [web] server db... and I think that Filemaker offers the same. > > If the above is true, you may need only move your dbs to the equivalent > server version. > > HTH > > Dick > > Please post what you find out! > > At 4:05 PM -0700 12/3/98, Alex wrote: > >I have a problem: > >I need to get data from database and use it in MacPerl. > >I have 4D Dimension and Claris File Works. > >Do you have modules for they or any other database? > > > >Or, exists any SQL Servers on Mac? > > > >Alex. > > Thanks, but CSV is temporary format. As I think: One Operator makes changes in the database and my web-page automatically refreshes (MacPerl from SQL gets new data). It is only one possible variant. It is because of I make my diplom project. Thanks & bye. Alex. P.S. If I'll do this work I'll send sources in chat (newsgroup) or I'll write where you will get it. ***** Want to unsubscribe from this list? ***** Send mail with body "unsubscribe" to mac-perl-request@iis.ee.ethz.ch